View: PO_HEADERS_AP_V

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

View Text

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
, CONSIGNED_CONSUMPTION_FLAG
FROM PO_LOOKUP_CODES PLC
, PO_HEADERS POH
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

Columns