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 |