[Home] [Help]
View: AP_SHIPPING_NETWORK_LOCATIONS
View Text
SELECT HRL.LOCATION_ID
, HRTL.LOCATION_CODE
, HRTL.DESCRIPTION
, HRL.INVENTORY_ORGANIZATION_ID
, OOD.ORGANIZATION_NAME
, OOD.ORGANIZATION_CODE
, HRL.ADDRESS_LINE_1||' '||HRL.TOWN_OR_CITY||' '||HRL.REGION_1 ADDRESS
FROM ORG_ORGANIZATION_DEFINITIONS OOD
, HR_LOCATIONS_ALL HRL
, HR_LOCATIONS_ALL_TL HRTL
WHERE OOD.ORGANIZATION_ID(+) = HRL.INVENTORY_ORGANIZATION_ID
AND NVL(HRL.INACTIVE_DATE
, SYSDATE + 1) > SYSDATE
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))
Columns
Name |
LOCATION_ID |
LOCATION_CODE |
DESCRIPTION |
INVENTORY_ORGANIZATION_ID |
ORGANIZATION_NAME |
ORGANIZATION_CODE |
ADDRESS |