GL Chart of Accounts - Inactive Accounts Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Chart of Accounts - Inactive Accounts Listing (XML)
Short Name: GLXACDAL_XML
DB package: GL_GLXACDAL_XMLP_PKG
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
Chart of Accounts ID
 
Number
Disabled Date
 
Date
Account To
 
Account From