View: POS_CHV_AUTHORIZATIONS_V

Product:	POS - iSupplier Portal
Description:	used to select the detailed info related to authorization
Implementation/DBA Data:	APPS.POS_CHV_AUTHORIZATIONS_V

View Text

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

Columns