View: PO_SHIPMENTS_AP_V

Product:	PO - Purchasing
Description:	10SC ONLY
Implementation/DBA Data:	APPS.PO_SHIPMENTS_AP_V

View Text

SELECT POLL.SHIPMENT_NUM SHIPMENT_NUM
, HRTL.LOCATION_CODE LOCATION_CODE
, POR.RELEASE_NUM RELEASE_NUM
, POL.LINE_NUM LINE_NUM
, POR.PO_RELEASE_ID PO_RELEASE_ID
, POLL.LINE_LOCATION_ID LINE_LOCATION_ID
, POL.PO_LINE_ID LINE_ID
, POLL.PO_HEADER_ID PO_HEADER_ID
, POLL.ORG_ID
FROM PO_LINE_LOCATIONS POLL
, PO_RELEASES_ALL POR
, PO_LINES_ALL POL
, HR_LOCATIONS_ALL_TL HRTL
, HR_LOCATIONS_ALL HRL
WHERE POLL.SHIP_TO_LOCATION_ID = HRTL.LOCATION_ID(+)
AND POLL.SHIP_TO_LOCATION_ID IS NOT NULL
AND HRTL.LANGUAGE(+)=USERENV('LANG')
AND NVL(HRL.BUSINESS_GROUP_ID(+)
, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99) ) =NVL (HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)
AND HRL.LOCATION_ID(+) =HRTL.LOCATION_ID
AND POLL.PO_RELEASE_ID = POR.PO_RELEASE_ID (+)
AND POLL.PO_LINE_ID = POL.PO_LINE_ID

Columns