VIEW: APPS.ITG_CPO_PO_SCHED_V

Source

View Text - Preformatted

SELECT plla.po_header_id, plla.po_line_id, plla.line_location_id, plla.shipment_num psclinenum FROM po_line_locations_all plla WHERE NVL(plla.shipment_type,'xx') <> 'PREPAYMENT'

View Text - HTML Formatted

SELECT PLLA.PO_HEADER_ID
, PLLA.PO_LINE_ID
, PLLA.LINE_LOCATION_ID
, PLLA.SHIPMENT_NUM PSCLINENUM
FROM PO_LINE_LOCATIONS_ALL PLLA
WHERE NVL(PLLA.SHIPMENT_TYPE
, 'XX') <> 'PREPAYMENT'