GL Budget - Organization Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Budget - Organization Listing (XML)
Short Name: GLXRLBOL_XML
DB package: GL_GLXRLBOL_XMLP_PKG
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
Data Access Set ID
 
Number
Budget Organization
 
LOV Oracle
Ledger
 
LOV Oracle