GL Other - MassAllocation Formula Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Other - MassAllocation Formula Listing (XML)
Short Name: GLXRLMAB_XML
DB package: GL_GLXRLMAB_XMLP_PKG
select  gll2.meaning		line_type,
            glafl.amount		amount,
            decode(glafl.amount, NULL, null, NULL)	C_FLEXDATA,
            glafl.ledger_action_code	ledger_action_code,
            glafl.segment_types_key	segment_types_key,
            glafl.ledger_currency	ledger_currency,
            gll8.meaning		currency_type,
            glafl.entered_currency	entered_currency,
            glafl.amount_type	amount_type,
            gll3.meaning		relative_period,  
            gll5.description	balance_type,
            decode(glafl.actual_flag, 'E', glet.encumbrance_type,
                                                           glbv.budget_name)	budget_encumbrance_type,
            --glafl.allocation_formula_id, 
			glafl.allocation_formula_id allocation_formula_id1, 
	--fnd_flex_xml_publisher_apis.process_kff_combination_1('accountingflexfield', 'SQLGL', 'GLLE', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') AccountingFlexfield, 
	GL_GLXRLMAB_XMLP_PKG.account_action_codeformula(glafl.amount, glafl.ledger_action_code, glafl.segment_types_key) Account_Action_Code
from    gl_alloc_formula_lines       glafl,
            gl_encumbrance_types      glet,
            gl_budget_versions           glbv,
            gl_lookups                          gll2,
            gl_lookups                          gll3,
            gl_lookups                          gll5,
            gl_lookups                          gll8,
            gl_ledgers		glled,
            gl_ledger_relationships	gllr
where glafl.budget_version_id       = glbv.budget_version_id (+)
and      glafl.encumbrance_type_id  = glet.encumbrance_type_id (+)
and      gll2.lookup_type                   = 'ALLOCATION_LINE_TYPE'
and      gll2.lookup_code                   = to_char(glafl.line_number)
and      gll3.lookup_type (+)              = 'PERIOD CODE'
and      glafl.relative_period              = gll3.lookup_code (+)
and      gll5.lookup_type (+)              = 'BATCH_TYPE'
and      glafl.actual_flag    = gll5.lookup_code (+)
and      gll8.lookup_type (+) = 'GL_CURRENCY_TYPE'
and      gll8.lookup_code (+) = glafl.currency_type
and      glled.ledger_id (+) = glafl.ledger_id
and      gllr.target_ledger_id (+) = glafl.ledger_id
and      gllr.source_ledger_id (+) = glafl.ledger_id
and      gllr.target_currency_code (+) = glafl.ledger_currency 
 and glafl.allocation_formula_id=:allocation_formula_id
order by
         glafl.line_number
Parameter Name SQL text Validation
GL_SRS_COA_UNVALIDATED
 
Number
Allocation Batch Name
 
LOV Oracle