GL Chart of Accounts - Inactive Accounts Listing
Description
- Categories
- BI Publisher
- Application
- General Ledger
- Source
- Chart of Accounts - Inactive Accounts Listing (XML)
- Short Name
- GLXACDAL_XML
- DB package
- GL_GLXACDAL_XMLP_PKG
Imported from BI Publisher
Inactive Accounts Listing
Inactive Accounts Listing
SQL 29 lines
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 |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Account From | Char | |
| Account To | Char | |
| Disabled Date | Date |