View: MSD_SR_LOC_CUS_V

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

View Text

SELECT PRS.SITE_USE_ID LEVEL_VALUE_PK
, RAC.CUSTOMER_NAME || ':' || RAC.CUSTOMER_NUMBER || ':' || PRS.LOCATION LEVEL_VALUE
, RAC.CUSTOMER_ID PARENT_VALUE_PK
, NVL(RAC.CUSTOMER_NAME
, MSD_SR_UTIL.GET_NULL_DESC) || ':' || RAC.CUSTOMER_NUMBER PARENT_VALUE
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
FROM RA_SITE_USES_ALL PRS
, RA_CUSTOMERS RAC
, RA_ADDRESSES_ALL PRA
, (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 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 LEVEL_VALUE_PK
, MSD_SR_UTIL.GET_NULL_DESC LEVEL_VALUE
, MSD_SR_UTIL.GET_NULL_PK PARENT_VALUE_PK
, MSD_SR_UTIL.GET_NULL_DESC PARENT_VALUE
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
FROM DUAL

Columns