PA AutoAccounting Segment Rule Pairings

Description

Application: Projects
Source: IMP: AutoAccounting Segment Rule Pairings (XML)
Short Name: PAXAASRP_XML
DB package: PA_PAXAASRP_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

SELECT     srp.application_id application_id1_a
,       srp.function_code function_code1_a
,       srp.id_flex_code  id_flex_code1_a
,       st.id_flex_structure_name
,       st.description structure_description
,       t.function_transaction_code transaction_code
,       t.function_transaction_name transaction_name
,       t.description transaction_description
,       e.meaning enabled_flag
,       srp.segment_num
,       seg.segment_name
,       r.rule_name
FROM    fnd_id_flex_structures_vl st
,       pa_function_transactions t
,       fnd_lookups e
,       fnd_id_flex_segments_vl seg
,       pa_rules r
,       pa_segment_rule_pairings srp
WHERE   nvl(:p_function_code, srp.function_code) = srp.function_code
and     st.id_flex_code = srp.id_flex_code
and     st.id_flex_num = srp.id_flex_num
and     t.application_id = srp.application_id
and     t.function_code = srp.function_code
and     t.function_transaction_code = srp.function_transaction_code
and     e.lookup_code = t.enabled_flag
and     e.lookup_type = 'YES_NO'
and     seg.id_flex_code = srp.id_flex_code
and     seg.id_flex_num = srp.id_flex_num
and     seg.segment_num = srp.segment_num+1
and     r.rule_id = srp.rule_id
 and srp.application_id=:application_id
 and srp.function_code=:function_code
 and srp.id_flex_code=:id_flex_code
ORDER BY
        st.id_flex_structure_name
,       srp.function_transaction_code
,       srp.segment_num