VIEW: APPS.PO_HEADER_RELEASE_V

Source

View Text - Preformatted

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 , POH.VENDOR_SITE_ID , 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)

View Text - HTML Formatted

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
, POH.VENDOR_SITE_ID
, 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)