Sunday 5 February 2017

PO Approver Group Query

SELECT   HOU.NAME,
         PCGA.CONTROL_GROUP_NAME,
         PCGA.DESCRIPTION,
         PCR.OBJECT_CODE,
         PCR.RULE_TYPE_CODE,
         PCR.AMOUNT_LIMIT,
            PCR.SEGMENT1_LOW
         || '.'
         || PCR.SEGMENT2_LOW
         || '.'
         || PCR.SEGMENT3_LOW
         || '.'
         || PCR.SEGMENT4_LOW
         || '.'
         || PCR.SEGMENT5_LOW
         || '.'
         || PCR.SEGMENT6_LOW
         || '.'
         || PCR.SEGMENT7_LOW
         || '.'
         || PCR.SEGMENT8_LOW
            "LOW_VALUE",
            PCR.SEGMENT1_HIGH
         || '.'
         || PCR.SEGMENT2_HIGH
         || '.'
         || PCR.SEGMENT3_HIGH
         || '.'
         || PCR.SEGMENT4_HIGH
         || '.'
         || PCR.SEGMENT5_HIGH
         || '.'
         || PCR.SEGMENT6_HIGH
         || '.'
         || PCR.SEGMENT7_HIGH
         || '.'
         || PCR.SEGMENT8_HIGH
            "HIGH_VALUE"
  FROM   PO_CONTROL_GROUPS_ALL PCGA,
         PO_CONTROL_RULES PCR,
         HR_OPERATING_UNITS HOU
 WHERE       PCGA.CONTROL_GROUP_ID = PCR.CONTROL_GROUP_ID
             and PCGA.ORG_ID =HOU.ORGANIZATION_ID
         --AND PCGA.CONTROL_GROUP_NAME = 'ENVS Buyer AG'
         --AND PCGA.ORG_ID = 103
         order by HOU.NAME,
         PCGA.CONTROL_GROUP_NAME

No comments:

Post a Comment