Query to get description of GL Code Combination

Query to get description of GL Code Combination
Oracle Apps EBS sql to get description of GL Code Combination

SELECT GCC.CONCATENATED_SEGMENTS ACCOUNT,
       GL_FLEXFIELDS_PKG.GET_CONCAT_DESCRIPTION (GCC.CHART_OF_ACCOUNTS_ID,
                                                 GCC.CODE_COMBINATION_ID)
          DESCRIPTION
  FROM GL_CODE_COMBINATIONS_KFV GCC
 WHERE gcc.CODE_COMBINATION_ID = 2003

Related posts:

• PTD and YTD balances query in Oracle R12
• Query to find all Expense report entry delegations
• Query to find vacation rules in Oracle R12
• View accounting query in oracle apps R12
• Query to get AR invoice SLA and GL details
• Accounting entries not transferred to the General Ledger
• Query to find all APIs of Oracle Apps modules
• R12 AR cash receipt SLA and GL details query
• Oracle apps AR Applications and SLA details
• Oracle EBS query to get AP Invoice SLA Details
• Oracle EBS query to get AR Invoice SLA Details
• Oracle AR Remit to address query
• Oracle Apps iExpense credit card details query
• Query to get customer tax registration details in R12
• Purchase Requisition Vertex debug xml query in Oracle EBS
• Purchase Order Vertex debug xml query in Oracle EBS
• AP Invoice Vertex debug xml query in Oracle EBS
• AR Invoice Vertex debug xml query in Oracle EBS
• Query to find AP invoice workflow item key in oracle apps
• Query to find period status for Inventory General Ledger Purchasing Payables Receivables Fixed Assets
• Oracle apps EBS sql to get Fixed Asset (FA) details with Net Book Value (NBV) and Depreciation
• Query to find Sales Orders that are shipped but not invoiced
• Query to get Customer Bank Account Details
• Query to get description of GL Code Combination
• Query to find Purchase Order and Invoice Details
• Query to find AP Invoices matched with receipts
• Query to find Supplier Bank Details
• Query to find Credit Memos on an AP invoice
• Query to find the AP invoices that are applied to multiple Purchase Orders
• AR Invoice grouping rule from RA_INTERFACE_LINES_ALL
• Query to find shipset and fulfilment set

Upload your own post and refer it anywhere anytime: