View: PO_HEADER_RELEASE_V

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

View Text

SELECT POH.SEGMENT1
, PODT.TYPE_NAME
, PLC.DESCRIPTION
, POH.COMMENTS
, POH.PO_HEADER_ID
, POH.TYPE_LOOKUP_CODE
, POH.REVISION_NUM
, POH.AGENT_ID
, PODB.SECURITY_LEVEL_CODE
, POV.VENDOR_NAME
, PAPF.FULL_NAME
, POH.START_DATE
, POH.END_DATE
, POH.AUTHORIZATION_STATUS
, POH.FOB_LOOKUP_CODE
, POH.FREIGHT_TERMS_LOOKUP_CODE
, POH.VENDOR_CONTACT_ID
, POH.TERMS_ID
, POH.BLANKET_TOTAL_AMOUNT
, POH.COMMENTS
, POH.NOTE_TO_VENDOR
, POH.NOTE_TO_RECEIVER
, POH.SHIP_VIA_LOOKUP_CODE
, POH.CONTERMS_EXIST_FLAG
, POH.PENDING_SIGNATURE_FLAG
, POH.AMOUNT_LIMIT
, POH.MIN_RELEASE_AMOUNT
, POH.PRICE_UPDATE_TOLERANCE
, POH.ORG_ID
FROM PO_LOOKUP_CODES PLC
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_HEADERS POH
, PO_VENDORS POV
, PER_PEOPLE_F PAPF
WHERE POH.TYPE_LOOKUP_CODE IN ('BLANKET'
, 'PLANNED')
AND NVL(POH.GLOBAL_AGREEMENT_FLAG
, 'N') = 'N'
AND NVL(POH.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POH.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND NVL(POH.FROZEN_FLAG
, 'N') <> 'Y'
AND PLC.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND PLC.LOOKUP_CODE = POH.AUTHORIZATION_STATUS
AND PODB.DOCUMENT_TYPE_CODE = DECODE(POH.TYPE_LOOKUP_CODE
, 'BLANKET'
, 'PA'
, 'PO')
AND PODB.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
AND PODB.ORG_ID = POH.ORG_ID
AND PODB.ORG_ID = PODT.ORG_ID
AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE
AND PODT.LANGUAGE = USERENV('LANG')
AND POH.APPROVED_DATE IS NOT NULL
AND TRUNC(NVL(POH.END_DATE
, SYSDATE+1)) >= TRUNC(SYSDATE)
AND POH.VENDOR_ID = POV.VENDOR_ID
AND POH.AGENT_ID = PAPF.PERSON_ID
AND PAPF.EFFECTIVE_START_DATE = (SELECT MAX(PAPF2.EFFECTIVE_START_DATE)
FROM PER_PEOPLE_F PAPF2
WHERE PAPF.PERSON_ID = PAPF2.PERSON_ID)

Columns