VIEW: APPS.MSD_SR_CUS_CLASS_V

Source

View Text - Preformatted

SELECT distinct to_char(CUST_ACCT.CUST_ACCOUNT_ID), nvl(substrb(PARTY.PARTY_NAME, 1, 50), msd_sr_util.get_null_desc) || ':' || CUST_ACCT.ACCOUNT_NUMBER, null, decode( nvl(CUST_ACCT.customer_type,'C'), 'I' , msd_sr_util.get_internal_customers_desc, nvl(CUST_ACCT.CUSTOMER_CLASS_CODE, to_char(msd_sr_util.get_null_pk))), decode( nvl(CUST_ACCT.customer_type,'C'), 'I' , msd_sr_util.get_internal_customers_desc, nvl(CUST_ACCT.CUSTOMER_CLASS_CODE, msd_sr_util.get_null_desc)), null, null, null, null, null, null , decode( nvl(CUST_ACCT.customer_type, 'C'), 'I' , FLV1.MEANING, FLV2.MEANING) SYSTEM_ATTRIBUTE1 , to_char(null) SYSTEM_ATTRIBUTE2 , 1 DP_ENABLED_FLAG FROM FND_LOOKUP_VALUES_VL FLV1, FND_LOOKUP_VALUES_VL FLV2, HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT, (select parameter_value from msd_setup_parameters WHERE parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust WHERE FLV1.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC' AND FLV1.LOOKUP_CODE='I' AND FLV2.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC' AND FLV2.LOOKUP_CODE='C' AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID AND decode(nvl(lower(filtercust.parameter_value), '1'), '1', '1', 'attribute1', CUST_ACCT.ATTRIBUTE1, 'attribute2', CUST_ACCT.ATTRIBUTE2, 'attribute3', CUST_ACCT.ATTRIBUTE3, 'attribute4', CUST_ACCT.ATTRIBUTE4, 'attribute5', CUST_ACCT.ATTRIBUTE5, 'attribute6', CUST_ACCT.ATTRIBUTE6, 'attribute7', CUST_ACCT.ATTRIBUTE7, 'attribute8', CUST_ACCT.ATTRIBUTE8, 'attribute9', CUST_ACCT.ATTRIBUTE9, 'attribute10', CUST_ACCT.ATTRIBUTE10, 'attribute11', CUST_ACCT.ATTRIBUTE11, 'attribute12', CUST_ACCT.ATTRIBUTE12, 'attribute13', CUST_ACCT.ATTRIBUTE13, 'attribute14', CUST_ACCT.ATTRIBUTE14, 'attribute15', CUST_ACCT.ATTRIBUTE15, '2') = '1' union SELECT to_char(msd_sr_util.get_null_pk), msd_sr_util.get_null_desc, null, to_char(msd_sr_util.get_null_pk), msd_sr_util.get_null_desc, null, null, null, null, null, null , to_char(null) SYSTEM_ATTRIBUTE1 , to_char(null) SYSTEM_ATTRIBUTE2 , 1 DP_ENABLED_FLAG FROM Dual

View Text - HTML Formatted

SELECT DISTINCT TO_CHAR(CUST_ACCT.CUST_ACCOUNT_ID)
, NVL(SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, MSD_SR_UTIL.GET_NULL_DESC) || ':' || CUST_ACCT.ACCOUNT_NUMBER
, NULL
, DECODE( NVL(CUST_ACCT.CUSTOMER_TYPE
, 'C')
, 'I'
, MSD_SR_UTIL.GET_INTERNAL_CUSTOMERS_DESC
, NVL(CUST_ACCT.CUSTOMER_CLASS_CODE
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)))
, DECODE( NVL(CUST_ACCT.CUSTOMER_TYPE
, 'C')
, 'I'
, MSD_SR_UTIL.GET_INTERNAL_CUSTOMERS_DESC
, NVL(CUST_ACCT.CUSTOMER_CLASS_CODE
, MSD_SR_UTIL.GET_NULL_DESC))
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, DECODE( NVL(CUST_ACCT.CUSTOMER_TYPE
, 'C')
, 'I'
, FLV1.MEANING
, FLV2.MEANING) SYSTEM_ATTRIBUTE1
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE2
, 1 DP_ENABLED_FLAG
FROM FND_LOOKUP_VALUES_VL FLV1
, FND_LOOKUP_VALUES_VL FLV2
, HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CUSTOMER_ATTRIBUTE') FILTERCUST
WHERE FLV1.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC'
AND FLV1.LOOKUP_CODE='I'
AND FLV2.LOOKUP_TYPE='MSD_LEVEL_VALUE_DESC'
AND FLV2.LOOKUP_CODE='C'
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND DECODE(NVL(LOWER(FILTERCUST.PARAMETER_VALUE)
, '1')
, '1'
, '1'
, 'ATTRIBUTE1'
, CUST_ACCT.ATTRIBUTE1
, 'ATTRIBUTE2'
, CUST_ACCT.ATTRIBUTE2
, 'ATTRIBUTE3'
, CUST_ACCT.ATTRIBUTE3
, 'ATTRIBUTE4'
, CUST_ACCT.ATTRIBUTE4
, 'ATTRIBUTE5'
, CUST_ACCT.ATTRIBUTE5
, 'ATTRIBUTE6'
, CUST_ACCT.ATTRIBUTE6
, 'ATTRIBUTE7'
, CUST_ACCT.ATTRIBUTE7
, 'ATTRIBUTE8'
, CUST_ACCT.ATTRIBUTE8
, 'ATTRIBUTE9'
, CUST_ACCT.ATTRIBUTE9
, 'ATTRIBUTE10'
, CUST_ACCT.ATTRIBUTE10
, 'ATTRIBUTE11'
, CUST_ACCT.ATTRIBUTE11
, 'ATTRIBUTE12'
, CUST_ACCT.ATTRIBUTE12
, 'ATTRIBUTE13'
, CUST_ACCT.ATTRIBUTE13
, 'ATTRIBUTE14'
, CUST_ACCT.ATTRIBUTE14
, 'ATTRIBUTE15'
, CUST_ACCT.ATTRIBUTE15
, '2') = '1' UNION SELECT TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_DESC
, NULL
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE1
, TO_CHAR(NULL) SYSTEM_ATTRIBUTE2
, 1 DP_ENABLED_FLAG
FROM DUAL