VIEW: APPS.PO_ACCEPTANCES_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))