FND Design Data [Home] [Help]

View: PO_SHIPMENTS_VAL_V

Product: PO - Purchasing
Description: 10SC ONLY - Retrofitted
Implementation/DBA Data: ViewAPPS.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