VIEW: APPS.PO_HEADERS_AP_V

Source

View Text - Preformatted

SELECT POH.SEGMENT1 PO_NUMBER , PLC.DISPLAYED_FIELD PO_TYPE , POH.PO_HEADER_ID PO_HEADER_ID , POH.VENDOR_ID VENDOR_ID , POH.CURRENCY_CODE CURRENCY_CODE , POH.APPROVED_FLAG APPROVED_FLAG , POH.CLOSED_CODE CLOSED_CODE , POH.ORG_ID , POH.CONSIGNED_CONSUMPTION_FLAG , POH.TYPE_LOOKUP_CODE , PER.FULL_NAME BUYER FROM PO_LOOKUP_CODES PLC, PO_HEADERS POH, PER_ALL_PEOPLE_F PER WHERE POH.TYPE_LOOKUP_CODE IN ('STANDARD', 'BLANKET', 'PLANNED') AND PLC.LOOKUP_CODE = POH.TYPE_LOOKUP_CODE AND PLC.LOOKUP_TYPE = 'PO TYPE' AND POH.PCARD_ID is NULL AND PER.PERSON_ID = POH.AGENT_ID AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE AND PER.EFFECTIVE_END_DATE

View Text - HTML Formatted

SELECT POH.SEGMENT1 PO_NUMBER
, PLC.DISPLAYED_FIELD PO_TYPE
, POH.PO_HEADER_ID PO_HEADER_ID
, POH.VENDOR_ID VENDOR_ID
, POH.CURRENCY_CODE CURRENCY_CODE
, POH.APPROVED_FLAG APPROVED_FLAG
, POH.CLOSED_CODE CLOSED_CODE
, POH.ORG_ID
, POH.CONSIGNED_CONSUMPTION_FLAG
, POH.TYPE_LOOKUP_CODE
, PER.FULL_NAME BUYER
FROM PO_LOOKUP_CODES PLC
, PO_HEADERS POH
, PER_ALL_PEOPLE_F PER
WHERE POH.TYPE_LOOKUP_CODE IN ('STANDARD'
, 'BLANKET'
, 'PLANNED')
AND PLC.LOOKUP_CODE = POH.TYPE_LOOKUP_CODE
AND PLC.LOOKUP_TYPE = 'PO TYPE'
AND POH.PCARD_ID IS NULL
AND PER.PERSON_ID = POH.AGENT_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE