eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CHV_AUTHORIZATION_HEADERS_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'