VIEW: APPS.ITG_SP_PO_LINE_SCHED_V

Source

View Text - Preformatted

SELECT plla.po_header_id, plla.po_line_id, plla.line_location_id, NVL(plla.need_by_date, plla.promised_date) datetime_needdelv, plla.quantity ordered_quantity, Uom.uom_code ordered_uom, plla.shipment_num, TO_CHAR(plla.line_location_id) UA_schedlid, plla.attribute1 UA_sched_attr1, plla.attribute2 UA_sched_attr2, plla.attribute3 UA_sched_attr3, plla.attribute4 UA_sched_attr4, plla.attribute5 UA_sched_attr5, plla.attribute6 UA_sched_attr6, plla.attribute7 UA_sched_attr7, plla.attribute8 UA_sched_attr8, plla.attribute9 UA_sched_attr9, plla.attribute10 UA_sched_attr10, plla.attribute11 UA_sched_attr11, plla.attribute12 UA_sched_attr12, plla.attribute13 UA_sched_attr13, plla.attribute14 UA_sched_attr14, plla.attribute15 UA_sched_attr15, NULL to_po_internal, NULL to_misc, NULL to_approver, NULL to_buyer, NULL to_payables, NULL to_receiver, NULL to_supplier, plla.drop_ship_flag drop_ship_flag FROM mtl_units_of_measure uom, po_line_locations_all plla, po_lines_all pla WHERE uom.unit_of_measure = pla.unit_meas_lookup_code AND plla.po_line_id = pla.po_line_id AND NVL(plla.shipment_type,'xx') <> 'PREPAYMENT'

View Text - HTML Formatted

SELECT PLLA.PO_HEADER_ID
, PLLA.PO_LINE_ID
, PLLA.LINE_LOCATION_ID
, NVL(PLLA.NEED_BY_DATE
, PLLA.PROMISED_DATE) DATETIME_NEEDDELV
, PLLA.QUANTITY ORDERED_QUANTITY
, UOM.UOM_CODE ORDERED_UOM
, PLLA.SHIPMENT_NUM
, TO_CHAR(PLLA.LINE_LOCATION_ID) UA_SCHEDLID
, PLLA.ATTRIBUTE1 UA_SCHED_ATTR1
, PLLA.ATTRIBUTE2 UA_SCHED_ATTR2
, PLLA.ATTRIBUTE3 UA_SCHED_ATTR3
, PLLA.ATTRIBUTE4 UA_SCHED_ATTR4
, PLLA.ATTRIBUTE5 UA_SCHED_ATTR5
, PLLA.ATTRIBUTE6 UA_SCHED_ATTR6
, PLLA.ATTRIBUTE7 UA_SCHED_ATTR7
, PLLA.ATTRIBUTE8 UA_SCHED_ATTR8
, PLLA.ATTRIBUTE9 UA_SCHED_ATTR9
, PLLA.ATTRIBUTE10 UA_SCHED_ATTR10
, PLLA.ATTRIBUTE11 UA_SCHED_ATTR11
, PLLA.ATTRIBUTE12 UA_SCHED_ATTR12
, PLLA.ATTRIBUTE13 UA_SCHED_ATTR13
, PLLA.ATTRIBUTE14 UA_SCHED_ATTR14
, PLLA.ATTRIBUTE15 UA_SCHED_ATTR15
, NULL TO_PO_INTERNAL
, NULL TO_MISC
, NULL TO_APPROVER
, NULL TO_BUYER
, NULL TO_PAYABLES
, NULL TO_RECEIVER
, NULL TO_SUPPLIER
, PLLA.DROP_SHIP_FLAG DROP_SHIP_FLAG
FROM MTL_UNITS_OF_MEASURE UOM
, PO_LINE_LOCATIONS_ALL PLLA
, PO_LINES_ALL PLA
WHERE UOM.UNIT_OF_MEASURE = PLA.UNIT_MEAS_LOOKUP_CODE
AND PLLA.PO_LINE_ID = PLA.PO_LINE_ID
AND NVL(PLLA.SHIPMENT_TYPE
, 'XX') <> 'PREPAYMENT'