View: MSD_SR_CLASS_ALL_V

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

View Text

SELECT DISTINCT PK
, VALUE
, MSD_SR_UTIL.GET_ALL_GEO_PK
, MSD_SR_UTIL.GET_ALL_GEO_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM (SELECT NVL(RAC.CUSTOMER_CLASS_CODE
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)) PK
, NVL(RAC.CUSTOMER_CLASS_CODE
, MSD_SR_UTIL.GET_NULL_DESC) VALUE
FROM RA_CUSTOMERS RAC
, (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CUSTOMER_ATTRIBUTE') FILTERCUST
WHERE 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) PK
, MSD_SR_UTIL.GET_NULL_DESC VALUE
FROM DUAL)

Columns