GL Budget - Organization Listing
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Budget Organization Listing
Application: General Ledger
Source: Budget - Organization Listing (XML)
Short Name: GLXRLBOL_XML
DB package: GL_GLXRLBOL_XMLP_PKG
Description: Budget Organization Listing
Application: General Ledger
Source: Budget - Organization Listing (XML)
Short Name: GLXRLBOL_XML
DB package: GL_GLXRLBOL_XMLP_PKG
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
select null C_FLEXDATA, be.name org_name, be.description org_description, l6.meaning org_password, be.start_date, be.end_date, l1.meaning entry_code, ba.currency_code, l3.meaning funds_check_level_code, l4.meaning amount_type, l5.meaning boundary_code, bv.budget_name funding_budget_name, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('c_desc_acct_seg', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') C_DESC_ACCT_SEG from gl_budget_assignments ba, gl_code_combinations cc, gl_budget_entities be, gl_budorg_bc_options bc, gl_lookups l1, gl_lookups l3, gl_lookups l4, gl_lookups l5, gl_lookups l6, gl_budget_versions bv /*where cc.code_combination_id = ba.code_combination_id and ba.budget_entity_id = decode(:P_BUDGET_ENTITY_ID, '-1', ba.budget_entity_id, to_number(:P_BUDGET_ENTITY_ID))*/ where cc.code_combination_id = ba.code_combination_id and ba.budget_entity_id = decode(:P_BUDGET_ENTITY_ID_NEW, '-1', ba.budget_entity_id, to_number(:P_BUDGET_ENTITY_ID_NEW)) and ba.ledger_id = :P_LEDGER_ID and be.budget_entity_id = ba.budget_entity_id and bc.range_id(+) = ba.range_id and l1.lookup_code = ba.entry_code and l1.lookup_type = 'ENTRY_CODE' and l3.lookup_code(+) = bc.funds_check_level_code and l3.lookup_type(+) = 'FUNDS_CHECK_LEVEL' and l6.lookup_code = be.budget_password_required_flag and l6.lookup_type = 'YES/NO' and l4.lookup_code(+) = bc.amount_type and l4.lookup_type(+) = 'PTD_YTD' and l5.lookup_code(+) = bc.boundary_code and l5.lookup_type(+) = 'BOUNDARY_TYPE' and bv.budget_version_id(+) = bc.funding_budget_version_id and decode(be.security_flag,'Y', decode(fnd_data_security.check_function(1.0, 'GL_DAS_BUDGET_ORG_V','GL_DAS_BUDGET_ORG', to_char(be.budget_entity_id),null,null,null,null, fnd_global.user_name),'T','Y','N'),'Y') = 'Y' order by be.name, ba.ordering_value, &P_ORDERBY, ba.currency_code, bv.budget_name |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger |
|
LOV Oracle | |
Budget Organization |
|
LOV Oracle |