GL Chart of Accounts - Inactive Accounts Listing

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Inactive Accounts Listing
Application: General Ledger
Source: Chart of Accounts - Inactive Accounts Listing (XML)
Short Name: GLXACDAL_XML
DB package: GL_GLXACDAL_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

SELECT
  null     FLEX_DATA_ALL,
  decode(cc.enabled_flag, 'Y', '*', '') ENABLED,
  cc.start_date_active      START_DATE,
  cc.end_date_active        END_DATE, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_desc_bal', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'GL_BALANCING', 'N', 'DESCRIPTION') FLEX_DESC_BAL, 
	--&FLEX_LPROMPT_BAL FLEX_LPROMPT_BAL, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_bal', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') FLEX_FIELD_BAL, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_desc_all', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') FLEX_DESC_ALL, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_all', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_FIELD_ALL
FROM
  gl_code_combinations cc
WHERE
  cc.chart_of_accounts_id = :P_STRUCT_NUM
AND
  &FLEX_WHERE_ALL
AND
  cc.template_id is NULL
AND
  (cc.enabled_flag = 'N'
    OR
           NVL(to_char(cc.end_date_active, 'YYYYMMDD'), '99990101')
                 < to_char(:P_DATE, 'YYYYMMDD')
    OR
           NVL(to_char(cc.start_date_active, 'YYYYMMDD'), '10000101')
                 > to_char(:P_DATE, 'YYYYMMDD'))
ORDER BY
  &FLEX_ORDERBY_ALL
Parameter Name SQL text Validation
Account From 
 
 Char
Account To 
 
 Char
Disabled Date 
 
 Date
Download
 
Related Blitz Reports
AR Customer Upload CAC Cost Group Accounts Setup INV Organization parameters listing CAC Inventory Accounts Setup ECC Procurement, Purchase Orders AP Supplier Upload JH Asset details EOS ARAP COPY OF: CAC Resource Costs ECC Procurement, Requisitions
Blitz Report™

Blitz Report™ provides multiple benefits: