View: PO_DOCUMENT_HEADERS_VIEW

Product:	PO - Purchasing
Description:	Header information in PO_HEADERS, PO_RELEASES, and PO_REQUISITION_HEADERS
Implementation/DBA Data:	APPS.PO_DOCUMENT_HEADERS_VIEW

View Text

SELECT PORH.REQUISITION_HEADER_ID
, 'REQUISITION'
, DECODE(PORH.TYPE_LOOKUP_CODE
, 'STANDARD'
, 'PURCHASE'
, PORH.TYPE_LOOKUP_CODE)
, PORH.SEGMENT1
, TO_NUMBER('0')
, PODT.TYPE_NAME
, PO_EMPLOYEES_SV.GET_EMP_NAME(PORH.PREPARER_ID)
, PORH.PREPARER_ID
, PORH.CREATION_DATE
, PORH.DESCRIPTION
, PORH.NOTE_TO_AUTHORIZER
, PORH.ORG_ID
FROM PO_REQUISITION_HEADERS PORH
, PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
WHERE PODB.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND PODB.DOCUMENT_SUBTYPE = DECODE(PORH.TYPE_LOOKUP_CODE
, 'STANDARD'
, 'PURCHASE'
, PORH.TYPE_LOOKUP_CODE)
AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE
AND PODT.LANGUAGE = USERENV('LANG')
AND PODT.ORG_ID = PODB.ORG_ID
AND PODB.ORG_ID = PORH.ORG_ID UNION SELECT POH.PO_HEADER_ID
, DECODE(POH.TYPE_LOOKUP_CODE
, 'BLANKET'
, 'PA'
, 'CONTRACT'
, 'PA'
, 'STANDARD'
, 'PO'
, 'PLANNED'
, 'PO'
, POH.TYPE_LOOKUP_CODE)
, POH.TYPE_LOOKUP_CODE
, POH.SEGMENT1
, NVL(POH.REVISION_NUM
, 0)
, PODT.TYPE_NAME
, PO_EMPLOYEES_SV.GET_EMP_NAME(POH.AGENT_ID)
, POH.AGENT_ID
, POH.CREATION_DATE
, POH.COMMENTS
, POH.NOTE_TO_AUTHORIZER
, POH.ORG_ID
FROM PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_HEADERS POH
WHERE PODB.DOCUMENT_TYPE_CODE = DECODE(POH.TYPE_LOOKUP_CODE
, 'STANDARD'
, 'PO'
, 'PLANNED'
, 'PO'
, 'BLANKET'
, 'PA'
, 'CONTRACT'
, 'PA'
, POH.TYPE_LOOKUP_CODE)
AND PODB.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE
AND PODT.LANGUAGE = USERENV('LANG')
AND PODT.ORG_ID = PODB.ORG_ID
AND PODB.ORG_ID = POH.ORG_ID UNION SELECT POR.PO_RELEASE_ID
, 'RELEASE'
, POR.RELEASE_TYPE
, POH.SEGMENT1 || '-' || POR.RELEASE_NUM
, NVL(POR.REVISION_NUM
, 0)
, PODT.TYPE_NAME
, PO_EMPLOYEES_SV.GET_EMP_NAME(POR.AGENT_ID)
, POR.AGENT_ID
, POR.CREATION_DATE
, POH.COMMENTS
, POH.NOTE_TO_AUTHORIZER
, POR.ORG_ID
FROM PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_HEADERS_ALL POH
, PO_RELEASES POR
WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND PODB.DOCUMENT_TYPE_CODE = 'RELEASE'
AND PODB.DOCUMENT_SUBTYPE = POR.RELEASE_TYPE
AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE
AND PODT.LANGUAGE = USERENV('LANG')
AND PODT.ORG_ID = PODB.ORG_ID
AND PODB.ORG_ID = POR.ORG_ID

Columns