View: MSD_SR_COUNTRY_AREA_V

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

View Text

SELECT DISTINCT PRA.COUNTRY
, NVL(BIS.TERRITORY_SHORT_NAME
, 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