View: MSD_SR_REG_COUNTRY_V

Product:	MSD - Demand Planning
Description:	This is the Source View that associates the Region level to Country level in the Geography Dimension. This view would be applied to an Oracle Applications 11i instance from which the Region to Country level association information is to be
Implementation/DBA Data:	APPS.MSD_SR_REG_COUNTRY_V

View Text

SELECT DISTINCT NVL(PRA.STATE
, NVL(PRA.PROVINCE
, NVL(PRA.COUNTY
, NVL(PRA.CITY
, PRA.COUNTRY)))) || '-' || PRA.COUNTRY
, NVL(PRA.STATE
, NVL(PRA.PROVINCE
, NVL(PRA.COUNTY
, NVL(PRA.CITY
, PRA.COUNTRY))))
, PRA.COUNTRY
, NVL(BIS.TERRITORY_SHORT_NAME
, PRA.COUNTRY)
, NULL
, NULL
, NULL
, NULL
, NULL
FROM RA_SITE_USES_ALL PRS
, RA_CUSTOMERS RAC
, RA_ADDRESSES_ALL PRA
, FND_TERRITORIES_VL BIS
, (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CUSTOMER_ATTRIBUTE') FILTERCUST
WHERE PRA.ADDRESS_ID = PRS.ADDRESS_ID
AND PRA.CUSTOMER_ID = RAC.CUSTOMER_ID
AND PRS.SITE_USE_CODE = 'SHIP_TO'
AND BIS.TERRITORY_CODE = PRA.COUNTRY
AND DECODE(NVL(LOWER(FILTERCUST.PARAMETER_VALUE)
, '1')
, '1'
, '1'
, 'ATTRIBUTE1'
, RAC.ATTRIBUTE1
, 'ATTRIBUTE2'
, RAC.ATTRIBUTE2
, 'ATTRIBUTE3'
, RAC.ATTRIBUTE3
, 'ATTRIBUTE4'
, RAC.ATTRIBUTE4
, 'ATTRIBUTE5'
, RAC.ATTRIBUTE5
, 'ATTRIBUTE6'
, RAC.ATTRIBUTE6
, 'ATTRIBUTE7'
, RAC.ATTRIBUTE7
, 'ATTRIBUTE8'
, RAC.ATTRIBUTE8
, 'ATTRIBUTE9'
, RAC.ATTRIBUTE9
, 'ATTRIBUTE10'
, RAC.ATTRIBUTE10
, 'ATTRIBUTE11'
, RAC.ATTRIBUTE11
, 'ATTRIBUTE12'
, RAC.ATTRIBUTE12
, 'ATTRIBUTE13'
, RAC.ATTRIBUTE13
, 'ATTRIBUTE14'
, RAC.ATTRIBUTE14
, 'ATTRIBUTE15'
, RAC.ATTRIBUTE15
, '2') = '1' UNION SELECT TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_DESC
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL

Columns