View: PO_QUOTATION_APPROVALS_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_QUOTATION_APPROVALS_V

View Text

SELECT PQA.ROWID ROW_ID
, PQA.QUOTATION_APPROVAL_ID
, PQA.LINE_LOCATION_ID
, PQA.LAST_UPDATE_DATE
, PQA.LAST_UPDATED_BY
, PQA.LAST_UPDATE_LOGIN
, PQA.CREATION_DATE
, PQA.CREATED_BY
, PQA.APPROVAL_TYPE
, PLC.DISPLAYED_FIELD DISPLAYED_APPROVAL_TYPE
, PLC1.DISPLAYED_FIELD
, PQA.APPROVER_ID
, HRE.FULL_NAME APPROVER_NAME
, PQA.COMMENTS
, PQA.START_DATE_ACTIVE
, PQA.END_DATE_ACTIVE
, PQA.ATTRIBUTE_CATEGORY
, PQA.ATTRIBUTE1
, PQA.ATTRIBUTE2
, PQA.ATTRIBUTE3
, PQA.ATTRIBUTE4
, PQA.ATTRIBUTE5
, PQA.ATTRIBUTE6
, PQA.ATTRIBUTE7
, PQA.ATTRIBUTE8
, PQA.ATTRIBUTE9
, PQA.ATTRIBUTE10
, PQA.ATTRIBUTE11
, PQA.ATTRIBUTE12
, PQA.ATTRIBUTE13
, PQA.ATTRIBUTE14
, PQA.ATTRIBUTE15
, PQA.REQUEST_ID
, PQA.PROGRAM_APPLICATION_ID
, PQA.PROGRAM_ID
, PQA.PROGRAM_UPDATE_DATE
, PQA.ORG_ID
, PQA.APPROVAL_REASON
FROM PO_QUOTATION_APPROVALS PQA
, HR_EMPLOYEES HRE
, PO_LOOKUP_CODES PLC
, PO_LOOKUP_CODES PLC1
WHERE HRE.EMPLOYEE_ID = PQA.APPROVER_ID
AND PQA.APPROVAL_TYPE = PLC.LOOKUP_CODE
AND PLC.LOOKUP_TYPE = 'QUOTE APPROVAL TYPE'
AND PQA.APPROVAL_REASON = PLC1.LOOKUP_CODE
AND PLC1.LOOKUP_TYPE = 'QUOTE APPROVAL REASON'

Columns