View: MSD_SR_AREA_ALL_V

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

View Text

SELECT DISTINCT PRA.COUNTRY
, NVL(BIS.TERRITORY_SHORT_NAME
, PRA.COUNTRY)
, MSD_SR_UTIL.GET_ALL_GEO_PK
, MSD_SR_UTIL.GET_ALL_GEO_DESC
, 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) AREA_CODE
, MSD_SR_UTIL.GET_NULL_DESC NAME
, MSD_SR_UTIL.GET_ALL_GEO_PK
, MSD_SR_UTIL.GET_ALL_GEO_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL

Columns