SELECT ROWID, RULE_INFORMATION_CATEGORY, (DECODE (RULE_INFORMATION_CATEGORY, 'AVE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'AVE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'AVE', RULE_INFORMATION3, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'STO', JTOT_OBJECT2_CODE, 'CAN', JTOT_OBJECT1_CODE, 'BTO', JTOT_OBJECT2_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'STO', JTOT_OBJECT1_CODE, 'BTO', JTOT_OBJECT1_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CC_REFUND', TO_DATE(RULE_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'CC_FORFAITURE', TO_DATE(RULE_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'CC_FISCAL_FUNDING', TO_DATE(RULE_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'CC_CANCELLATION', TO_DATE(RULE_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'CC_ACCEPTANCE', TO_DATE(RULE_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CC_REFUND', RULE_INFORMATION2, 'CC_FORFAITURE', RULE_INFORMATION2, 'CC_FISCAL_FUNDING', RULE_INFORMATION2, 'CC_CANCELLATION', RULE_INFORMATION2, 'CC_ACCEPTANCE', RULE_INFORMATION2, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CC_REFUND', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), 'CC_FORFAITURE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), 'CC_FISCAL_FUNDING', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), 'CC_CANCELLATION', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), 'CC_ACCEPTANCE', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CC_REFUND', RULE_INFORMATION4, 'CC_FORFAITURE', RULE_INFORMATION4, 'CC_FISCAL_FUNDING', RULE_INFORMATION4, 'CC_CANCELLATION', RULE_INFORMATION4, 'CC_ACCEPTANCE', RULE_INFORMATION4, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CVN', JTOT_OBJECT1_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CVN', TO_DATE(RULE_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CVN', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'CVN', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'DST', JTOT_OBJECT1_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'EXC', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'EXL_OPN', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'FOB', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'FRT', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'IRE', JTOT_OBJECT1_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'LRT', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'MDR', JTOT_OBJECT1_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'NTN', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'NTN', RULE_INFORMATION2, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'NTN', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'NTN', RULE_INFORMATION4, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'NTN', FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'NTN', RULE_INFORMATION6, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'NTN', RULE_INFORMATION7, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PRE', JTOT_OBJECT1_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PTO', JTOT_OBJECT1_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'PTR', JTOT_OBJECT1_CODE, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'REN', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'REN', RULE_INFORMATION2, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'REN', TO_DATE(RULE_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'SMD', RULE_INFORMATION1, NULL)), (DECODE (RULE_INFORMATION_CATEGORY, 'TER', RULE_INFORMATION1, NULL)),
(DECODE (RULE_INFORMATION_CATEGORY,
'AVE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3,
'BTO', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT2_CODE || '.' || JTOT_OBJECT1_CODE,
'CAN', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,
'CC_ACCEPTANCE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,
'CC_CANCELLATION', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,
'CC_FISCAL_FUNDING', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,
'CC_FORFAITURE', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,
'CC_REFUND', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4,
'CVN', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION3,
'DST', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,
'EXC', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,
'EXL_OPN', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,
'FOB', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,
'FRT', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,
'IRE', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,
'LRT', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,
'MDR', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,
'NTN', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7,
'PRE', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,
'PTO', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,
'PTR', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE,
'REN', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3,
'SMD', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1,
'STO', RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT2_CODE || '.' || JTOT_OBJECT1_CODE,
'TER', RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1, NULL))
FROM OKC_RULES_B
SELECT ROWID
, RULE_INFORMATION_CATEGORY
, (DECODE (RULE_INFORMATION_CATEGORY
, 'AVE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'AVE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION2)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'AVE'
, RULE_INFORMATION3
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'STO'
, JTOT_OBJECT2_CODE
, 'CAN'
, JTOT_OBJECT1_CODE
, 'BTO'
, JTOT_OBJECT2_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'STO'
, JTOT_OBJECT1_CODE
, 'BTO'
, JTOT_OBJECT1_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CC_REFUND'
, TO_DATE(RULE_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'CC_FORFAITURE'
, TO_DATE(RULE_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'CC_FISCAL_FUNDING'
, TO_DATE(RULE_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'CC_CANCELLATION'
, TO_DATE(RULE_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'CC_ACCEPTANCE'
, TO_DATE(RULE_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CC_REFUND'
, RULE_INFORMATION2
, 'CC_FORFAITURE'
, RULE_INFORMATION2
, 'CC_FISCAL_FUNDING'
, RULE_INFORMATION2
, 'CC_CANCELLATION'
, RULE_INFORMATION2
, 'CC_ACCEPTANCE'
, RULE_INFORMATION2
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CC_REFUND'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, 'CC_FORFAITURE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, 'CC_FISCAL_FUNDING'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, 'CC_CANCELLATION'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, 'CC_ACCEPTANCE'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CC_REFUND'
, RULE_INFORMATION4
, 'CC_FORFAITURE'
, RULE_INFORMATION4
, 'CC_FISCAL_FUNDING'
, RULE_INFORMATION4
, 'CC_CANCELLATION'
, RULE_INFORMATION4
, 'CC_ACCEPTANCE'
, RULE_INFORMATION4
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CVN'
, JTOT_OBJECT1_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CVN'
, TO_DATE(RULE_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CVN'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION1)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'CVN'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'DST'
, JTOT_OBJECT1_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'EXC'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'EXL_OPN'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'FOB'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'FRT'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'IRE'
, JTOT_OBJECT1_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'LRT'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'MDR'
, JTOT_OBJECT1_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'NTN'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'NTN'
, RULE_INFORMATION2
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'NTN'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION3)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'NTN'
, RULE_INFORMATION4
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'NTN'
, FND_NUMBER.CANONICAL_TO_NUMBER(RULE_INFORMATION5)
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'NTN'
, RULE_INFORMATION6
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'NTN'
, RULE_INFORMATION7
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PRE'
, JTOT_OBJECT1_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PTO'
, JTOT_OBJECT1_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'PTR'
, JTOT_OBJECT1_CODE
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'REN'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'REN'
, RULE_INFORMATION2
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'REN'
, TO_DATE(RULE_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'SMD'
, RULE_INFORMATION1
, NULL))
, (DECODE (RULE_INFORMATION_CATEGORY
, 'TER'
, RULE_INFORMATION1
, NULL))
,
(DECODE (RULE_INFORMATION_CATEGORY
,
'AVE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3
,
'BTO'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT2_CODE || '.' || JTOT_OBJECT1_CODE
,
'CAN'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
,
'CC_ACCEPTANCE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
,
'CC_CANCELLATION'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
,
'CC_FISCAL_FUNDING'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
,
'CC_FORFAITURE'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
,
'CC_REFUND'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4
,
'CVN'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION3
,
'DST'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
,
'EXC'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
,
'EXL_OPN'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
,
'FOB'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
,
'FRT'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
,
'IRE'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
,
'LRT'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
,
'MDR'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
,
'NTN'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3 || '.' || RULE_INFORMATION4 || '.' || RULE_INFORMATION5 || '.' || RULE_INFORMATION6 || '.' || RULE_INFORMATION7
,
'PRE'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
,
'PTO'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
,
'PTR'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT1_CODE
,
'REN'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1 || '.' || RULE_INFORMATION2 || '.' || RULE_INFORMATION3
,
'SMD'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
,
'STO'
, RULE_INFORMATION_CATEGORY || '.' || JTOT_OBJECT2_CODE || '.' || JTOT_OBJECT1_CODE
,
'TER'
, RULE_INFORMATION_CATEGORY || '.' || RULE_INFORMATION1
, NULL))
FROM OKC_RULES_B
|
|
|