Query for Approval groups

SELECT pcr.control_rule_id, pcga.control_group_name, pcr.object_code,
       pcr.rule_type_code, pcr.amount_limit,
       (   segment1_low
        || ‘.’
        || segment2_low
        || ‘.’
        || segment3_low
        || ‘.’
        || segment4_low
        || ‘.’
        || segment5_low
        || ‘.’
        || segment6_low
        || ‘.’
        || segment7_low
        || ‘.’
        || segment8_low
        || ‘.’
        || segment9_low
       ) low_value,
       (   segment1_high
        || ‘.’
        || segment2_high
        || ‘.’
        || segment3_high
        || ‘.’
        || segment4_high
        || ‘.’
        || segment5_high
        || ‘.’
        || segment6_high
        || ‘.’
        || segment7_high
        || ‘.’
        || segment8_high
        || ‘.’
        || segment9_high
       ) high_value
  FROM apps.po_control_rules pcr, apps.po_control_groups_all pcga
 WHERE pcga.control_group_id =  pcr.control_group_id
 AND pcr.control_group_id in (select distinct control_group_id from apps.po_position_controls_all where org_id = :ou_name)

  • September 27, 2016 | 13 views
  • Comments