SELECT ROWID, GLOBAL_ATTRIBUTE_CATEGORY, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.MX.FAXASSET.FA_BOOKS', GLOBAL_ATTRIBUTE1, 'JL.CO.FAXASSET.FA_BOOKS', GLOBAL_ATTRIBUTE1, 'JL.CL.FAXASSET.FA_BOOKS', GLOBAL_ATTRIBUTE1, 'JL.AR.FAXASSET.FA_BOOKS', GLOBAL_ATTRIBUTE1, NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.FAXASSET.FA_BOOKS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE2), NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.FAXASSET.FA_BOOKS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE3), NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.FAXASSET.FA_BOOKS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE4), NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.FAXASSET.FA_BOOKS', TO_DATE(GLOBAL_ATTRIBUTE5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.FAXASSET.FA_BOOKS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE6), NULL)), (DECODE (GLOBAL_ATTRIBUTE_CATEGORY, 'JL.CO.FAXASSET.FA_BOOKS', FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE7), NULL)),
(DECODE (GLOBAL_ATTRIBUTE_CATEGORY,
'JL.AR.FAXASSET.FA_BOOKS', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1,
'JL.CL.FAXASSET.FA_BOOKS', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1,
'JL.CO.FAXASSET.FA_BOOKS', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7,
'JL.MX.FAXASSET.FA_BOOKS', GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1, NULL))
FROM FA_BOOKS
SELECT ROWID
, GLOBAL_ATTRIBUTE_CATEGORY
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.MX.FAXASSET.FA_BOOKS'
, GLOBAL_ATTRIBUTE1
, 'JL.CO.FAXASSET.FA_BOOKS'
, GLOBAL_ATTRIBUTE1
, 'JL.CL.FAXASSET.FA_BOOKS'
, GLOBAL_ATTRIBUTE1
, 'JL.AR.FAXASSET.FA_BOOKS'
, GLOBAL_ATTRIBUTE1
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.FAXASSET.FA_BOOKS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE2)
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.FAXASSET.FA_BOOKS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE3)
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.FAXASSET.FA_BOOKS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE4)
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.FAXASSET.FA_BOOKS'
, TO_DATE(GLOBAL_ATTRIBUTE5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.FAXASSET.FA_BOOKS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE6)
, NULL))
, (DECODE (GLOBAL_ATTRIBUTE_CATEGORY
, 'JL.CO.FAXASSET.FA_BOOKS'
, FND_NUMBER.CANONICAL_TO_NUMBER(GLOBAL_ATTRIBUTE7)
, NULL))
,
(DECODE (GLOBAL_ATTRIBUTE_CATEGORY
,
'JL.AR.FAXASSET.FA_BOOKS'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1
,
'JL.CL.FAXASSET.FA_BOOKS'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1
,
'JL.CO.FAXASSET.FA_BOOKS'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1 || '.' || GLOBAL_ATTRIBUTE2 || '.' || GLOBAL_ATTRIBUTE3 || '.' || GLOBAL_ATTRIBUTE4 || '.' || GLOBAL_ATTRIBUTE5 || '.' || GLOBAL_ATTRIBUTE6 || '.' || GLOBAL_ATTRIBUTE7
,
'JL.MX.FAXASSET.FA_BOOKS'
, GLOBAL_ATTRIBUTE_CATEGORY || '.' || GLOBAL_ATTRIBUTE1
, NULL))
FROM FA_BOOKS
|
|
|