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.PO_QUOTATION_APPROVALS_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'