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.

VIEW: APPS.MSD_SR_CLASS_ALL_V

Source

View Text - Preformatted


SELECT nvl(rac.CUSTOMER_CLASS_CODE, to_char(msd_sr_util.get_null_pk)) LEVEL_VALUE_PK, nvl(rac.CUSTOMER_CLASS_CODE, msd_sr_util.get_null_desc) LEVEL_VALUE, null LEVEL_VALUE_DESC, to_char(MSD_SR_UTIL.get_all_geo_pk) PARENT_VALUE_PK, MSD_SR_UTIL.get_all_geo_desc PARENT_VALUE, MSD_SR_UTIL.get_all_geo_desc PARENT_VALUE_DESC, null, null, null, null, null , flv.meaning SYSTEM_ATTRIBUTE1 , to_char(null) SYSTEM_ATTRIBUTE2 , 1 DP_ENABLED_FLAG FROM fnd_lookup_values_vl flv, HZ_CUST_ACCOUNTS rac, (select parameter_value from msd_setup_parameters WHERE parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust WHERE FLV.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC' AND FLV.LOOKUP_CODE='C' 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' and nvl(rac.customer_type,'C') <> 'I' union SELECT to_char(msd_sr_util.get_null_pk) LEVEL_VALUE_PK, msd_sr_util.get_null_desc LEVEL_VALUE, null LEVEL_VALUE_DESC, to_char(MSD_SR_UTIL.get_all_geo_pk) PARENT_VALUE_PK, MSD_SR_UTIL.get_all_geo_desc PARENT_VALUE, MSD_SR_UTIL.get_all_geo_desc PARENT_VALUE_DESC, null, null, null, null, null , to_char(null) SYSTEM_ATTRIBUTE1 , to_char(null) SYSTEM_ATTRIBUTE2 , 1 DP_ENABLED_FLAG FROM dual UNION ALL SELECT msd_sr_util.get_internal_customers_desc LEVEL_VALUE_PK, msd_sr_util.get_internal_customers_desc LEVEL_VALUE, null LEVEL_VALUE_DESC, to_char(MSD_SR_UTIL.get_all_geo_pk) PARENT_VALUE_PK, MSD_SR_UTIL.get_all_geo_desc PARENT_VALUE, MSD_SR_UTIL.get_all_geo_desc PARENT_VALUE_DESC, null, null, null, null, null , flv.meaning SYSTEM_ATTRIBUTE1 , to_char(null) SYSTEM_ATTRIBUTE2 , 1 DP_ENABLED_FLAG FROM dual, fnd_lookup_values_vl flv where FLV.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC' AND FLV.LOOKUP_CODE='I'

View Text - HTML Formatted

SELECT NVL(RAC.CUSTOMER_CLASS_CODE
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)) LEVEL_VALUE_PK
, NVL(RAC.CUSTOMER_CLASS_CODE
, MSD_SR_UTIL.GET_NULL_DESC) LEVEL_VALUE
, NULL LEVEL_VALUE_DESC
, TO_CHAR(MSD_SR_UTIL.GET_ALL_GEO_PK) PARENT_VALUE_PK
, MSD_SR_UTIL.GET_ALL_GEO_DESC PARENT_VALUE
, MSD_SR_UTIL.GET_ALL_GEO_DESC PARENT_VALUE_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, FLV.MEANING SYSTEM_ATTRIBUTE1
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE2
, 1 DP_ENABLED_FLAG
FROM FND_LOOKUP_VALUES_VL FLV
, HZ_CUST_ACCOUNTS RAC
, (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CUSTOMER_ATTRIBUTE') FILTERCUST
WHERE FLV.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC'
AND FLV.LOOKUP_CODE='C'
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'
AND NVL(RAC.CUSTOMER_TYPE
, 'C') <> 'I' UNION SELECT TO_CHAR(MSD_SR_UTIL.GET_NULL_PK) LEVEL_VALUE_PK
, MSD_SR_UTIL.GET_NULL_DESC LEVEL_VALUE
, NULL LEVEL_VALUE_DESC
, TO_CHAR(MSD_SR_UTIL.GET_ALL_GEO_PK) PARENT_VALUE_PK
, MSD_SR_UTIL.GET_ALL_GEO_DESC PARENT_VALUE
, MSD_SR_UTIL.GET_ALL_GEO_DESC PARENT_VALUE_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE1
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE2
, 1 DP_ENABLED_FLAG
FROM DUAL UNION ALL SELECT MSD_SR_UTIL.GET_INTERNAL_CUSTOMERS_DESC LEVEL_VALUE_PK
, MSD_SR_UTIL.GET_INTERNAL_CUSTOMERS_DESC LEVEL_VALUE
, NULL LEVEL_VALUE_DESC
, TO_CHAR(MSD_SR_UTIL.GET_ALL_GEO_PK) PARENT_VALUE_PK
, MSD_SR_UTIL.GET_ALL_GEO_DESC PARENT_VALUE
, MSD_SR_UTIL.GET_ALL_GEO_DESC PARENT_VALUE_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, FLV.MEANING SYSTEM_ATTRIBUTE1
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE2
, 1 DP_ENABLED_FLAG
FROM DUAL
, FND_LOOKUP_VALUES_VL FLV
WHERE FLV.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC'
AND FLV.LOOKUP_CODE='I'