GL Chart of Accounts - Detail Listing
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Chart of Accounts Listing Report
Application: General Ledger
Source: Chart of Accounts - Detail Listing (XML)
Short Name: GLXRLCOA_XML
DB package: GL_GLXRLCOA_XMLP_PKG
Description: Chart of Accounts Listing Report
Application: General Ledger
Source: Chart of Accounts - Detail Listing (XML)
Short Name: GLXRLCOA_XML
DB package: GL_GLXRLCOA_XMLP_PKG
Run
GL Chart of Accounts - Detail Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select null FLEX_DATA_ALL, null FLEX_DATA_BAL, null FLEX_DATA_SEG, decode(gcc.detail_posting_allowed_flag, 'Y', '*', '') POSTING_ALLOWED, decode(gcc.detail_budgeting_allowed_flag, 'Y', '*', '') BUDGET_ALLOWED, decode ( gcc.summary_flag, 'Y', ' ', gl1.description ) ACCOUNT_TYPE, gcc.summary_flag SUMMARY_FLAG, decode(gcc.summary_flag, 'Y', '*', '') SUMMARY, gcc.enabled_flag ENABLED_FLAG, decode(gcc.enabled_flag, 'Y', '*', '') ENABLED, gcc.start_date_active START_DATE, gcc.end_date_active END_DATE, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_bal_unpad', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') FLEX_FIELD_BAL_UNPAD, fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_bal_pad', 'SQLGL', 'GL#', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'PADDED_VALUE') FLEX_FIELD_BAL_PAD, 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', 'FULL_DESCRIPTION') FLEX_DESC_BAL, --null FLEX_APROMPT_BAL, --null FLEX_LPROMPT_BAL, &FLEX_FIELD_SEG_UNPAD FLEX_FIELD_SEG_UNPAD, &FLEX_FIELD_SEG_PAD FLEX_FIELD_SEG_PAD, &FLEX_DESC_SEG FLEX_DESC_SEG, --null FLEX_APROMPT_SEG, --null FLEX_LPROMPT_SEG, 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_lookups gl1, gl_code_combinations gcc where gcc.chart_of_accounts_id = :P_STRUCT_NUM and &FLEX_WHERE_ALL and gcc.account_type = gl1.lookup_code and gl1.lookup_type = 'ACCOUNT TYPE' order by gcc.summary_flag, gcc.enabled_flag desc, &FLEX_ORDERBY_BAL, &FLEX_ORDERBY_SEG, &FLEX_ORDERBY_ALL |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Account From |
|
Char | |
Account To |
|
Char | |
Order By |
|
LOV Oracle |