eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
[Home] [Help]
View: MSD_SR_GROUP_ALL_V
Product: MSD - Demand Planning
Description: This is the Source View that associates the Customer Group level to Top level in the Geography Dimension. This view would be applied to an Oracle Applications 11i instance from which the Customer Group to Top level association information
Implementation/DBA Data:
APPS.MSD_SR_GROUP_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_GROUP_CODE , TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)) PK , NVL(RAC.CUSTOMER_GROUP_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
Name
LEVEL_VALUE_PK
LEVEL_VALUE
PARENT_VALUE_PK
PARENT_VALUE
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5