[Home] [Help]
View: PO_SHIPMENTS_VAL_V
View Text
SELECT DISTINCT PH.SEGMENT1
, PH.PO_HEADER_ID
, POL.ITEM_ID
, POL.UNIT_MEAS_LOOKUP_CODE
, PH.TYPE_LOOKUP_CODE
, PLC.DISPLAYED_FIELD
, PH.COMMENTS
, PH.VENDOR_ID
, POLL.SHIP_TO_ORGANIZATION_ID
, PH.ORG_ID
FROM PO_HEADERS PH
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL POLL
, PO_LOOKUP_CODES PLC
WHERE PH.TYPE_LOOKUP_CODE IN ('BLANKET'
, 'STANDARD'
, 'PLANNED')
AND NVL(PH.CANCEL_FLAG
, 'N') != 'Y'
AND PH.TYPE_LOOKUP_CODE = PLC.LOOKUP_CODE
AND PLC.LOOKUP_TYPE = 'PO TYPE'
AND NVL(PH.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND POL.PO_LINE_ID = POLL.PO_LINE_ID
AND PH.PO_HEADER_ID = POLL.PO_HEADER_ID
AND NVL(POLL.APPROVED_FLAG
, 'N')= 'Y'
AND NVL(POLL.CANCEL_FLAG
, 'N') = 'N'
AND NVL(POLL.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND POLL.SHIPMENT_TYPE IN ('STANDARD'
, 'BLANKET'
, 'SCHEDULED')
Columns
Name |
SEGMENT1 |
PO_HEADER_ID |
ITEM_ID |
UNIT_MEAS_LOOKUP_CODE |
TYPE_LOOKUP_CODE |
DISPLAYED_FIELD |
COMMENTS |
VENDOR_ID |
SHIP_TO_ORGANIZATION_ID |
ORG_ID |