VIEW: APPS.MSD_SR_CUS_GROUP_V

Source

View Text - Preformatted

SELECT distinct CUST_ACCT.CUST_ACCOUNT_ID, nvl(substrb(PARTY.PARTY_NAME, 1, 50), msd_sr_util.get_null_desc) || ':' || CUST_ACCT.ACCOUNT_NUMBER, null, to_char(msd_sr_util.get_null_pk), msd_sr_util.get_null_desc, null, null, null, null, null, null FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT, (select parameter_value from msd_setup_parameters WHERE parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust WHERE 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 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 from dual

View Text - HTML Formatted

SELECT DISTINCT CUST_ACCT.CUST_ACCOUNT_ID
, NVL(SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, MSD_SR_UTIL.GET_NULL_DESC) || ':' || CUST_ACCT.ACCOUNT_NUMBER
, NULL
, TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
, (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CUSTOMER_ATTRIBUTE') FILTERCUST
WHERE 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 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
FROM DUAL