PA AutoAccounting Segment Rule Pairings
Description
Categories: BI Publisher
Application: Projects
Source: IMP: AutoAccounting Segment Rule Pairings (XML)
Short Name: PAXAASRP_XML
DB package: PA_PAXAASRP_XMLP_PKG
Source: IMP: AutoAccounting Segment Rule Pairings (XML)
Short Name: PAXAASRP_XML
DB package: PA_PAXAASRP_XMLP_PKG
Run
PA AutoAccounting Segment Rule Pairings and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Function Name |
|
LOV Oracle |
