GL Budget - Organization Range Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Budget - Organization Range Listing (XML)
Short Name: GLXBOR_XML
DB package: GL_GLXBOR_XMLP_PKG
select  bar.budget_entity_id budget_entity_id1,
            bar.sequence_number LINE,
           &SELECT_FLEX_LOW  FLEXDATA_LOW,
           &SELECT_FLEX_HIGH FLEXDATA_HIGH,
           lec.description TYPE,
           bar.currency_code CURRENCY,
           lst.meaning STATUS,
           lfcl.meaning FUNDS_CHECK_LEVEL,
           lat.meaning AMOUNT_TYPE,
           lbc.meaning BOUNDARY,
           bv.budget_name FUNDING_BUDGET,
	GL_GLXBOR_XMLP_PKG.flexfield_lowformula(&SELECT_FLEX_LOW) FLEXFIELD_LOW,
	GL_GLXBOR_XMLP_PKG.flexfield_highformula(&SELECT_FLEX_HIGH) FLEXFIELD_HIGH
from gl_lookups lec,
         gl_lookups lst,
         gl_lookups lfcl,
         gl_lookups lat,
         gl_lookups lbc,
         gl_budget_versions bv,
        gl_budorg_bc_options bc,
        gl_budget_assignment_ranges bar
where bar.ledger_id = :P_LEDGER_ID
/*and     bar.budget_entity_id = decode(:P_BUDGET_ENTITY_ID,
                                                      '-1', bar.budget_entity_id,
                                               to_number(:P_BUDGET_ENTITY_ID))*/
and     bar.budget_entity_id = decode(:P_BUDGET_ENTITY_ID1,
                                                      '-1', bar.budget_entity_id,
                                               to_number(:P_BUDGET_ENTITY_ID1))
and     bc.range_id(+) = bar.range_id
and     lec.lookup_type(+) = 'ENTRY_CODE'
and     lec.lookup_code(+) = bar.entry_code
and     lst.lookup_type(+) = 'GLBAAR_STATUSES'
and     lst.lookup_code(+) = bar.status
and     lfcl.lookup_type(+) = 'FUNDS_CHECK_LEVEL'
and     lfcl.lookup_code(+) = bc.funds_check_level_code
and     lat.lookup_type(+) = 'PTD_YTD'
and     lat.lookup_code(+) = bc.amount_type
and     lbc.lookup_type(+) = 'BOUNDARY_TYPE'
and     lbc.lookup_code(+) = bc.boundary_code
and     bv.budget_version_id(+) = bc.funding_budget_version_id
and bar.budget_entity_id=:budget_entity_id
--and bar.budget_entity_id=:P_BUDGET_ENTITY_ID1
order by bar.sequence_number, bv.budget_name
Parameter Name SQL text Validation
Funds Check On
 
Data Access Set Id
 
Number
Budget Organization
 
LOV Oracle
Ledger
 
LOV Oracle