View: AP_SHIPPING_NETWORK_LOCATIONS

Product:	AP - Payables
Description:	No Longer Used - MOAC
Implementation/DBA Data:	APPS.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