View: PO_SHIPMENTS_ALL_V

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

View Text

SELECT PLL.SHIPMENT_NUM
, HRTL.LOCATION_CODE
, PLL.LINE_LOCATION_ID
, PLL.PO_HEADER_ID
, PLL.PO_LINE_ID
, PLL.SHIPMENT_TYPE
, PLL.NEED_BY_DATE
, OOD.ORGANIZATION_CODE
, PO_RELEASE_ID
, PLL.ORG_ID
FROM PO_LINE_LOCATIONS PLL
, HR_LOCATIONS_ALL_TL HRTL
, HR_LOCATIONS_ALL HRL
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE HRTL.LOCATION_ID(+) = PLL.SHIP_TO_LOCATION_ID
AND PLL.SHIP_TO_LOCATION_ID IS NOT NULL
AND HRL.LOCATION_ID(+) = HRTL.LOCATION_ID
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 PLL.SHIP_TO_ORGANIZATION_ID = OOD.ORGANIZATION_ID

Columns