DBA Data[Home] [Help]

VIEW: APPS.PO_SHIPMENTS_ALL_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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