View: PO_ACCEPTANCES_V

Product:	PO - Purchasing
Description:	10SC ONLY
Implementation/DBA Data:	APPS.PO_ACCEPTANCES_V

View Text

SELECT POA.ROWID ROW_ID
, POA.ACCEPTANCE_ID
, POA.LAST_UPDATE_DATE
, POA.LAST_UPDATED_BY
, POA.LAST_UPDATE_LOGIN
, POA.CREATION_DATE
, POA.CREATED_BY
, POA.PO_HEADER_ID
, POA.PO_RELEASE_ID
, POA.ACTION
, POA.ACTION_DATE
, POA.EMPLOYEE_ID
, POA.REVISION_NUM
, POA.ACCEPTED_FLAG
, POA.ACCEPTANCE_LOOKUP_CODE
, POA.NOTE
, POA.ATTRIBUTE_CATEGORY
, POA.ATTRIBUTE1
, POA.ATTRIBUTE2
, POA.ATTRIBUTE3
, POA.ATTRIBUTE4
, POA.ATTRIBUTE5
, POA.ATTRIBUTE6
, POA.ATTRIBUTE7
, POA.ATTRIBUTE8
, POA.ATTRIBUTE9
, POA.ATTRIBUTE10
, POA.ATTRIBUTE11
, POA.ATTRIBUTE12
, POA.ATTRIBUTE13
, POA.ATTRIBUTE14
, POA.ATTRIBUTE15
, POA.REQUEST_ID
, POA.PROGRAM_APPLICATION_ID
, POA.PROGRAM_ID
, POA.PROGRAM_UPDATE_DATE
, POC.DISPLAYED_FIELD ACCEPTANCE_TYPE
, FULL_NAME
, EMPLOYEE_NUMBER
, POA.ACCEPTING_PARTY
, POA.ROLE
, POA.ERECORD_ID
, POA.SIGNATURE_FLAG
FROM PO_ACCEPTANCES POA
, PO_LOOKUP_CODES POC
, PER_PEOPLE_F HR
, PO_AGENTS PA
WHERE POC.LOOKUP_TYPE(+) = 'ACCEPTANCE TYPE'
AND POC.LOOKUP_CODE(+) = POA.ACCEPTANCE_LOOKUP_CODE
AND PA.AGENT_ID = HR.PERSON_ID(+)
AND POA.EMPLOYEE_ID = PA.AGENT_ID(+)
AND POA.PO_LINE_LOCATION_ID IS NULL
AND TRUNC(SYSDATE) BETWEEN NVL(HR.EFFECTIVE_START_DATE
, TRUNC(SYSDATE))
AND NVL(HR.EFFECTIVE_END_DATE
, TRUNC(SYSDATE))

Columns