[Home] [Help]
View: EDW_GEOG_REGION_LCV
Product: | PO - Purchasing |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* SUPPLIER SITE */ COUNTRY || '-' || 'CUTY' REGION_PK
, COUNTRY COUNTRY_FK
, COUNTRY REGION_DP
, COUNTRY 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 COUNTRY || '-' || 'CUTY' REGION_PK
, COUNTRY COUNTRY_FK
, COUNTRY REGION_DP
, COUNTRY 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 COUNTRY || '-' || 'CUTY' REGION_PK
, COUNTRY COUNTRY_FK
, COUNTRY REGION_DP
, COUNTRY 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
Name |
REGION_PK |
COUNTRY_FK |
REGION_DP |
NAME |
INSTANCE |
CREATION_DATE |
LAST_UPDATE_DATE |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |