VIEW: APPS.POS_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