[Home] [Help]
View: 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
Name |
SHIPMENT_NUM |
LOCATION_CODE |
LINE_LOCATION_ID |
PO_HEADER_ID |
PO_LINE_ID |
SHIPMENT_TYPE |
NEED_BY_DATE |
ORGANIZATION_CODE |
PO_RELEASE_ID |
ORG_ID |