VIEW: APPS.CHV_AUTHORIZATIONS_V

Source

View Text - Preformatted

SELECT CAU.ROWID , CAU.REFERENCE_ID , CAU.AUTHORIZATION_CODE , PLC.DISPLAYED_FIELD , CAU.AUTHORIZATION_SEQUENCE , CAU.PRIMARY_UNIT_OF_MEASURE , CAU.PURCHASING_UNIT_OF_MEASURE , CAU.SCHEDULE_QUANTITY_PRIMARY , CAU.SCHEDULE_QUANTITY , CAU.TIMEFENCE_DAYS , CAU.CUTOFF_DATE , CAU.LAST_UPDATE_DATE , CAU.LAST_UPDATED_BY , CAU.CREATION_DATE , CAU.CREATED_BY , CAU.ATTRIBUTE_CATEGORY , CAU.ATTRIBUTE1 , CAU.ATTRIBUTE2 , CAU.ATTRIBUTE3 , CAU.ATTRIBUTE4 , CAU.ATTRIBUTE5 , CAU.ATTRIBUTE6 , CAU.ATTRIBUTE7 , CAU.ATTRIBUTE8 , CAU.ATTRIBUTE9 , CAU.ATTRIBUTE10 , CAU.ATTRIBUTE11 , CAU.ATTRIBUTE12 , CAU.ATTRIBUTE13 , CAU.ATTRIBUTE14 , CAU.ATTRIBUTE15 , CAU.LAST_UPDATE_LOGIN , CAU.REQUEST_ID , CAU.PROGRAM_APPLICATION_ID , CAU.PROGRAM_ID , CAU.PROGRAM_UPDATE_DATE FROM CHV_AUTHORIZATIONS CAU, PO_LOOKUP_CODES PLC WHERE CAU.REFERENCE_TYPE = 'SCHEDULE_ITEMS' AND CAU.AUTHORIZATION_CODE = PLC.LOOKUP_CODE AND 'AUTHORIZATION_TYPE' = PLC.LOOKUP_TYPE

View Text - HTML Formatted

SELECT CAU.ROWID
, CAU.REFERENCE_ID
, CAU.AUTHORIZATION_CODE
, PLC.DISPLAYED_FIELD
, CAU.AUTHORIZATION_SEQUENCE
, CAU.PRIMARY_UNIT_OF_MEASURE
, CAU.PURCHASING_UNIT_OF_MEASURE
, CAU.SCHEDULE_QUANTITY_PRIMARY
, CAU.SCHEDULE_QUANTITY
, CAU.TIMEFENCE_DAYS
, CAU.CUTOFF_DATE
, CAU.LAST_UPDATE_DATE
, CAU.LAST_UPDATED_BY
, CAU.CREATION_DATE
, CAU.CREATED_BY
, CAU.ATTRIBUTE_CATEGORY
, CAU.ATTRIBUTE1
, CAU.ATTRIBUTE2
, CAU.ATTRIBUTE3
, CAU.ATTRIBUTE4
, CAU.ATTRIBUTE5
, CAU.ATTRIBUTE6
, CAU.ATTRIBUTE7
, CAU.ATTRIBUTE8
, CAU.ATTRIBUTE9
, CAU.ATTRIBUTE10
, CAU.ATTRIBUTE11
, CAU.ATTRIBUTE12
, CAU.ATTRIBUTE13
, CAU.ATTRIBUTE14
, CAU.ATTRIBUTE15
, CAU.LAST_UPDATE_LOGIN
, CAU.REQUEST_ID
, CAU.PROGRAM_APPLICATION_ID
, CAU.PROGRAM_ID
, CAU.PROGRAM_UPDATE_DATE
FROM CHV_AUTHORIZATIONS CAU
, PO_LOOKUP_CODES PLC
WHERE CAU.REFERENCE_TYPE = 'SCHEDULE_ITEMS'
AND CAU.AUTHORIZATION_CODE = PLC.LOOKUP_CODE
AND 'AUTHORIZATION_TYPE' = PLC.LOOKUP_TYPE