Product: | CHV - Supplier Scheduling |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CHV_AUTHORIZATION_HEADERS_V |
SELECT CA.REFERENCE_ID
, CA.REFERENCE_TYPE
, CA.AUTHORIZATION_CODE
, CA.SCHEDULE_QUANTITY
, CA.PURCHASING_UNIT_OF_MEASURE
, CA.HIGH_AUTH_QUANTITY
, CSH.SCHEDULE_NUM
, CSH.SCHEDULE_REVISION
, CSH.SCHEDULE_HORIZON_START
, HIGH_AUTH_SCHEDULE_ITEM_ID
, POL.DISPLAYED_FIELD
FROM CHV_AUTHORIZATIONS CA
, CHV_SCHEDULE_HEADERS CSH
, PO_LOOKUP_CODES POL
, CHV_SCHEDULE_ITEMS CSI
WHERE CA.HIGH_AUTH_SCHEDULE_ITEM_ID = CSI.SCHEDULE_ITEM_ID
AND CSH.SCHEDULE_ID = CSI.SCHEDULE_ID
AND CA.REFERENCE_TYPE = 'CUM_PERIODS'
AND CA.AUTHORIZATION_CODE = POL.LOOKUP_CODE
AND POL.LOOKUP_TYPE = 'AUTHORIZATION_TYPE'