SELECT ROWID, ATTRIBUTE_CATEGORY, (DECODE (ATTRIBUTE_CATEGORY, 'CUST_PREFERENCE', FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE1), NULL)),
(DECODE (ATTRIBUTE_CATEGORY,
'CUST_PREFERENCE', ATTRIBUTE_CATEGORY || '.' || ATTRIBUTE1, NULL))
FROM ASF_USER_PREFERENCE
SELECT ROWID
, ATTRIBUTE_CATEGORY
, (DECODE (ATTRIBUTE_CATEGORY
, 'CUST_PREFERENCE'
, FND_NUMBER.CANONICAL_TO_NUMBER(ATTRIBUTE1)
, NULL))
,
(DECODE (ATTRIBUTE_CATEGORY
,
'CUST_PREFERENCE'
, ATTRIBUTE_CATEGORY || '.' || ATTRIBUTE1
, NULL))
FROM ASF_USER_PREFERENCE
|
|
|