View: ITG_SP_PO_LINE_SCHED_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This view is used to generate XML for Sync PO at line schedule level
Implementation/DBA Data:	APPS.ITG_SP_PO_LINE_SCHED_V

View Text

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
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'PO INTERNAL'
, PLLA.LINE_LOCATION_ID) TO_PO_INTERNAL
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'MISC'
, PLLA.LINE_LOCATION_ID) TO_MISC
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'APPROVER'
, PLLA.LINE_LOCATION_ID) TO_APPROVER
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'BUYER'
, PLLA.LINE_LOCATION_ID) TO_BUYER
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'PAYABLES'
, PLLA.LINE_LOCATION_ID) TO_PAYABLES
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'RECEIVER'
, PLLA.LINE_LOCATION_ID) TO_RECEIVER
, ITG_X_UTILS.GETATTACHMENTS('PO_LINE_LOCATIONS'
, 'VENDOR'
, PLLA.LINE_LOCATION_ID) TO_SUPPLIER
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

Columns