View: ITG_SP_REL_LINE_SCHED_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	This view is used to generate XML at po release line schedules level
Implementation/DBA Data:	APPS.ITG_SP_REL_LINE_SCHED_V

View Text

SELECT PLLA.PO_HEADER_ID
, PLLA.PO_RELEASE_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
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 PLA.PO_LINE_ID = PLLA.PO_LINE_ID

Columns