SELECT pcr.control_group_id,
pcga.control_group_name
rule_type_code,
object_code,
amount_limit,
segment1_low,
segment1_high,
segment2_low,
segment2_high,
segment3_low,
segment3_high,
segment4_low,
segment4_high,
segment5_low,
segment5_high,
segment6_low,
segment6_high,
segment7_low,
segment7_high,
segment8_low,
segment8_high,
segment9_low,
segment9_high,
segment10_low,
segment10_high
FROM po_control_rules pcr
,po_control_groups_all pcga
WHERE pcga.control_group_id = pcr.control_group_id
No comments:
Post a Comment