View: MSD_SR_CUS_CLASS_V

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

View Text

SELECT DISTINCT RAC. CUSTOMER_ID
, NVL(RAC.CUSTOMER_NAME
, MSD_SR_UTIL.GET_NULL_DESC) || ':' || RAC.CUSTOMER_NUMBER
, NVL(RAC.CUSTOMER_CLASS_CODE
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK))
, NVL(RAC.CUSTOMER_CLASS_CODE
, MSD_SR_UTIL.GET_NULL_DESC)
, NULL
, NULL
, NULL
, NULL
, NULL
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 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