View: ITG_CPO_REL_SCHED_V

Product:	ITG - Internet Procurement Enterprise Connector
Description:	PO RELEASE schedule view for CANCEL PO 006
Implementation/DBA Data:	APPS.ITG_CPO_REL_SCHED_V

View Text

SELECT PLLA.PO_HEADER_ID
, PLLA.PO_LINE_ID
, PLLA.LINE_LOCATION_ID
, PRA.PO_RELEASE_ID
, PLLA.SHIPMENT_NUM PSCLINENUM
FROM PO_LINE_LOCATIONS_ALL PLLA
, PO_RELEASES_ALL PRA
WHERE PRA.PO_HEADER_ID = PLLA.PO_HEADER_ID
AND PRA.PO_RELEASE_ID = PLLA.PO_RELEASE_ID

Columns