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
Run GL Chart of Accounts - Inactive Accounts Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
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
FA Asset Impairments CAC Cost Group Accounts Setup INV Organization parameters listing CAC Inventory Accounts Setup OPM2 XXSJ Report VAT Register FA Asset Inventory CAC Item Cost Summary GL Account Analysis CST Periodic Material and Receiving Distribution Details
Blitz Report™

Blitz Report™ provides multiple benefits: