VIEW: APPS.PO_SHIPMENTS_VAL_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')