Product: | CUN - Network Logistics - NATS (obsolete) |
---|---|
Description: | CUN_LOCATIONS_V is created based on CUN_LOCATIONS table, HR_LOCATIONS view and FA_LOCATIONS_KFV view. |
Implementation/DBA Data: | Not implemented in this database |
SELECT CL.CUN_LOCATION_ID
, CL.FA_LOCATION_ID
, FA.CONCATENATED_SEGMENTS
, CL.NETWORK_LOCATION_CODE
, CL.LOCATION_ID
, HR.LOCATION_CODE
, DECODE(CL.LOCATION_ID
, NULL
, CL.DESCRIPTION
, HR.DESCRIPTION) DESCRIPTION
, HR.ADDRESS_LINE_1
, HR.ADDRESS_LINE_2
, HR.ADDRESS_LINE_3
, HR.TOWN_OR_CITY
, HR.COUNTRY
, HR.POSTAL_CODE
, HR.REGION_1
, HR.REGION_2
FROM CUN_LOCATIONS CL
, HR_LOCATIONS HR
, FA_LOCATIONS_KFV FA
WHERE CL.LOCATION_ID = HR.LOCATION_ID(+)
AND CL.FA_LOCATION_ID = FA.LOCATION_ID
AND CL.ENABLED_FLAG = 'Y'