/* account derivation rule */
SELECT xsr.user_sequence Priority,xsr.VALUE_TYPE_CODE,xsr.VALUE_CODE_COMBINATION_ID,xc.user_sequence seq
,xc.SOURCE_TYPE_CODE,xc.SOURCE_CODE,xc.LINE_OPERATOR_CODE,xc.VALUE_TYPE_CODE VLAUE_TYPE,xc.VALUE_CONSTANT
FROM xla_seg_rule_details xsr,
xla_conditions xc
WHERE segment_rule_code = 'XX_RCA_COMBINATION1'
AND xsr.SEGMENT_RULE_DETAIL_ID = xc.SEGMENT_RULE_DETAIL_ID
AND xsr.application_id = xc.application_id
-- AND xsr.user_sequence > 600
-- AND xsr.user_sequence <= 1020