VIEW: APPS.EDW_GEOG_COUNTRY_LCV

Source

View Text - Preformatted

SELECT /* Supplier Site Location */ country country_pk, 'ALL' || '-' || 'ARE2' area2_fk, ftl.DESCRIPTION country_dp, ftl.TERRITORY_SHORT_NAME 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, fnd_territories_tl ftl, edw_local_instance eli WHERE country IS NOT NULL and ftl.TERRITORY_CODE = country and ftl.LANGUAGE = userenv('LANG') union all /* HR_LOCATIONS EXTRACT */ select country country_pk, 'ALL' || '-' || 'ARE2' area2_fk, ftl.DESCRIPTION country_dp, ftl.TERRITORY_SHORT_NAME 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, fnd_territories_tl ftl, edw_local_instance eli where country IS NOT NULL and ftl.TERRITORY_CODE = country and ftl.LANGUAGE = userenv('LANG') union all /* RA_ADDRESSES (customers, HZ_LOCATIONS) EXTRACT */ select country country_pk, 'ALL' || '-' || 'ARE2' area2_fk, ftl.DESCRIPTION country_dp, ftl.TERRITORY_SHORT_NAME 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, fnd_territories_tl ftl, edw_local_instance eli where country IS NOT NULL and ftl.TERRITORY_CODE = country and ftl.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT /* SUPPLIER SITE LOCATION */ COUNTRY COUNTRY_PK
, 'ALL' || '-' || 'ARE2' AREA2_FK
, FTL.DESCRIPTION COUNTRY_DP
, FTL.TERRITORY_SHORT_NAME 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
, FND_TERRITORIES_TL FTL
, EDW_LOCAL_INSTANCE ELI
WHERE COUNTRY IS NOT NULL
AND FTL.TERRITORY_CODE = COUNTRY
AND FTL.LANGUAGE = USERENV('LANG') UNION ALL /* HR_LOCATIONS EXTRACT */ SELECT COUNTRY COUNTRY_PK
, 'ALL' || '-' || 'ARE2' AREA2_FK
, FTL.DESCRIPTION COUNTRY_DP
, FTL.TERRITORY_SHORT_NAME 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
, FND_TERRITORIES_TL FTL
, EDW_LOCAL_INSTANCE ELI
WHERE COUNTRY IS NOT NULL
AND FTL.TERRITORY_CODE = COUNTRY
AND FTL.LANGUAGE = USERENV('LANG') UNION ALL /* RA_ADDRESSES (CUSTOMERS
, HZ_LOCATIONS) EXTRACT */ SELECT COUNTRY COUNTRY_PK
, 'ALL' || '-' || 'ARE2' AREA2_FK
, FTL.DESCRIPTION COUNTRY_DP
, FTL.TERRITORY_SHORT_NAME 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
, FND_TERRITORIES_TL FTL
, EDW_LOCAL_INSTANCE ELI
WHERE COUNTRY IS NOT NULL
AND FTL.TERRITORY_CODE = COUNTRY
AND FTL.LANGUAGE = USERENV('LANG')