GL Chart of Accounts - Inactive Accounts Listing
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
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 |