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