View: EDW_GEOG_CITY_LCV

View Text

SELECT /* SUPPLIER SITE LOCATION */ CITY || '-' || DECODE(STATE
, NULL
, PROVINCE
, STATE) || '-' || COUNTRY CITY_PK
, DECODE(STATE
, NULL
, PROVINCE
, STATE) || '-' || COUNTRY || '-' || 'STAT' STATE_REGION_FK
, CITY || '(' || DECODE(STATE
, NULL
, PROVINCE
, STATE) || ')' CITY_DP
, CITY || '(' || DECODE(STATE
, NULL
, PROVINCE
, STATE) || ')' NAME
, ELI.INSTANCE_CODE INSTANCE
, PVS.CREATION_DATE CREATION_DATE
, PVS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM PO_VENDOR_SITES_ALL PVS
, EDW_LOCAL_INSTANCE ELI UNION ALL /* HR_LOCATIONS EXTRACT */ SELECT TOWN_OR_CITY || '-' || REGION_2 || '-' || COUNTRY CITY_PK
, REGION_2 || '-' || COUNTRY || '-' || 'STAT' STATE_REGION_FK
, TOWN_OR_CITY || '(' || REGION_2 || ')' CITY_DP
, TOWN_OR_CITY || '(' || REGION_2 || ')' NAME
, ELI.INSTANCE_CODE INSTANCE
, HRL.CREATION_DATE CREATION_DATE
, HRL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM HR_LOCATIONS_ALL HRL
, EDW_LOCAL_INSTANCE ELI UNION ALL /* RA_ADDRESSES (CUSTOMERS
, HZ_LOCATIONS) EXTRACT */ SELECT CITY || '-' || DECODE(STATE
, NULL
, PROVINCE
, STATE) || '-' || COUNTRY CITY_PK
, DECODE(STATE
, NULL
, PROVINCE
, STATE) || '-' || COUNTRY || '-' || 'STAT' STATE_REGION_FK
, CITY || '(' || DECODE(STATE
, NULL
, PROVINCE
, STATE) || ')' CITY_DP
, CITY || '(' || DECODE(STATE
, NULL
, PROVINCE
, STATE) || ')' NAME
, ELI.INSTANCE_CODE INSTANCE
, HZL.CREATION_DATE CREATION_DATE
, HZL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
FROM HZ_LOCATIONS HZL
, EDW_LOCAL_INSTANCE ELI

Columns