SELECT ROWID, PMETH_INFORMATION_CATEGORY, (DECODE (PMETH_INFORMATION_CATEGORY, 'KW Direct Deposit KWD', PMETH_INFORMATION4, 'AE Direct Deposit AED', PMETH_INFORMATION1, NULL)), (DECODE (PMETH_INFORMATION_CATEGORY, 'KW Direct Deposit KWD', PMETH_INFORMATION5, 'AE Direct Deposit AED', PMETH_INFORMATION2, NULL)), (DECODE (PMETH_INFORMATION_CATEGORY, 'SA Direct Deposit SAR', PMETH_INFORMATION1, 'KW Direct Deposit KWD', PMETH_INFORMATION1, 'AE Direct Deposit AED', PMETH_INFORMATION3, NULL)), (DECODE (PMETH_INFORMATION_CATEGORY, 'SA Direct Deposit SAR', PMETH_INFORMATION2, 'KW Direct Deposit KWD', PMETH_INFORMATION2, 'AE Direct Deposit AED', PMETH_INFORMATION4, NULL)), (DECODE (PMETH_INFORMATION_CATEGORY, 'SA Direct Deposit SAR', PMETH_INFORMATION3, 'KW Direct Deposit KWD', PMETH_INFORMATION3, 'AE Direct Deposit AED', PMETH_INFORMATION5, NULL)), PMETH_INFORMATION1, PMETH_INFORMATION2, PMETH_INFORMATION1, (DECODE (PMETH_INFORMATION_CATEGORY, 'BACS Tape', FND_NUMBER.CANONICAL_TO_NUMBER(PMETH_INFORMATION2), NULL)), PMETH_INFORMATION3, PMETH_INFORMATION4, PMETH_INFORMATION5, PMETH_INFORMATION6, (DECODE (PMETH_INFORMATION_CATEGORY, 'BACS Tape', FND_NUMBER.CANONICAL_TO_NUMBER(PMETH_INFORMATION7), NULL)), PMETH_INFORMATION8, PMETH_INFORMATION1, PMETH_INFORMATION2, PMETH_INFORMATION1, PMETH_INFORMATION2, PMETH_INFORMATION3, PMETH_INFORMATION4, PMETH_INFORMATION5, PMETH_INFORMATION6, PMETH_INFORMATION7, PMETH_INFORMATION9, PMETH_INFORMATION8, PMETH_INFORMATION1, PMETH_INFORMATION1, PMETH_INFORMATION1, PMETH_INFORMATION1, PMETH_INFORMATION2, PMETH_INFORMATION3, PMETH_INFORMATION4, PMETH_INFORMATION5, PMETH_INFORMATION6, PMETH_INFORMATION7, PMETH_INFORMATION8, PMETH_INFORMATION9, (DECODE (PMETH_INFORMATION_CATEGORY, 'SE Third Party Payment', PMETH_INFORMATION1, 'NO_THIRD_PARTY_PAYMENT', PMETH_INFORMATION1, 'FI Third Party Payment', PMETH_INFORMATION1, NULL)), PMETH_INFORMATION1, PMETH_INFORMATION2, PMETH_INFORMATION3, PMETH_INFORMATION1, PMETH_INFORMATION2, PMETH_INFORMATION3, PMETH_INFORMATION4, PMETH_INFORMATION1, PMETH_INFORMATION2, PMETH_INFORMATION1, PMETH_INFORMATION1, PMETH_INFORMATION2, PMETH_INFORMATION3, PMETH_INFORMATION4, PMETH_INFORMATION5, PMETH_INFORMATION6, PMETH_INFORMATION7, PMETH_INFORMATION8, PMETH_INFORMATION1, PMETH_INFORMATION2, PMETH_INFORMATION3, PMETH_INFORMATION4, PMETH_INFORMATION5, PMETH_INFORMATION6, PMETH_INFORMATION7, (DECODE (PMETH_INFORMATION_CATEGORY, 'NO Payment Process', FND_NUMBER.CANONICAL_TO_NUMBER(PMETH_INFORMATION1), NULL)), PMETH_INFORMATION2, (DECODE (PMETH_INFORMATION_CATEGORY, 'NO Payment Process', FND_NUMBER.CANONICAL_TO_NUMBER(PMETH_INFORMATION3), NULL)), (DECODE (PMETH_INFORMATION_CATEGORY, 'NO Payment Process', FND_NUMBER.CANONICAL_TO_NUMBER(PMETH_INFORMATION4), NULL)), PMETH_INFORMATION2, PMETH_INFORMATION3,
(DECODE (PMETH_INFORMATION_CATEGORY,
'AE Direct Deposit AED', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5,
'Autopay', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2,
'BACS Tape', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION6 || '.' || PMETH_INFORMATION7 || '.' || PMETH_INFORMATION8,
'BF_PAYMETH', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2,
'Canadian Direct Deposit', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION6 || '.' || PMETH_INFORMATION7 || '.' || PMETH_INFORMATION9 || '.' || PMETH_INFORMATION8,
'Cash', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1,
'Direct Credit - ASB CSV', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1,
'Direct Deposit', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1,
'Direct Entry', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION6 || '.' || PMETH_INFORMATION7 || '.' || PMETH_INFORMATION8 || '.' || PMETH_INFORMATION9,
'FI Third Party Payment', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1,
'JP_SALARY', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3,
'KR Court Order Payments', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4,
'KR Direct Deposit', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2,
'KW Direct Deposit KWD', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3,
'Mexican Direct Deposit', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1,
'NACHA', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION6 || '.' || PMETH_INFORMATION7 || '.' || PMETH_INFORMATION8,
'NL Direct Deposit EUR', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION6 || '.' || PMETH_INFORMATION7,
'NO Payment Process', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4,
'NO_THIRD_PARTY_PAYMENT', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3,
'SA Direct Deposit SAR', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3,
'SE Third Party Payment', PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1, NULL))
FROM PAY_ORG_PAYMENT_METHODS_F
SELECT ROWID
, PMETH_INFORMATION_CATEGORY
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'KW DIRECT DEPOSIT KWD'
, PMETH_INFORMATION4
, 'AE DIRECT DEPOSIT AED'
, PMETH_INFORMATION1
, NULL))
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'KW DIRECT DEPOSIT KWD'
, PMETH_INFORMATION5
, 'AE DIRECT DEPOSIT AED'
, PMETH_INFORMATION2
, NULL))
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'SA DIRECT DEPOSIT SAR'
, PMETH_INFORMATION1
, 'KW DIRECT DEPOSIT KWD'
, PMETH_INFORMATION1
, 'AE DIRECT DEPOSIT AED'
, PMETH_INFORMATION3
, NULL))
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'SA DIRECT DEPOSIT SAR'
, PMETH_INFORMATION2
, 'KW DIRECT DEPOSIT KWD'
, PMETH_INFORMATION2
, 'AE DIRECT DEPOSIT AED'
, PMETH_INFORMATION4
, NULL))
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'SA DIRECT DEPOSIT SAR'
, PMETH_INFORMATION3
, 'KW DIRECT DEPOSIT KWD'
, PMETH_INFORMATION3
, 'AE DIRECT DEPOSIT AED'
, PMETH_INFORMATION5
, NULL))
, PMETH_INFORMATION1
, PMETH_INFORMATION2
, PMETH_INFORMATION1
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'BACS TAPE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PMETH_INFORMATION2)
, NULL))
, PMETH_INFORMATION3
, PMETH_INFORMATION4
, PMETH_INFORMATION5
, PMETH_INFORMATION6
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'BACS TAPE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PMETH_INFORMATION7)
, NULL))
, PMETH_INFORMATION8
, PMETH_INFORMATION1
, PMETH_INFORMATION2
, PMETH_INFORMATION1
, PMETH_INFORMATION2
, PMETH_INFORMATION3
, PMETH_INFORMATION4
, PMETH_INFORMATION5
, PMETH_INFORMATION6
, PMETH_INFORMATION7
, PMETH_INFORMATION9
, PMETH_INFORMATION8
, PMETH_INFORMATION1
, PMETH_INFORMATION1
, PMETH_INFORMATION1
, PMETH_INFORMATION1
, PMETH_INFORMATION2
, PMETH_INFORMATION3
, PMETH_INFORMATION4
, PMETH_INFORMATION5
, PMETH_INFORMATION6
, PMETH_INFORMATION7
, PMETH_INFORMATION8
, PMETH_INFORMATION9
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'SE THIRD PARTY PAYMENT'
, PMETH_INFORMATION1
, 'NO_THIRD_PARTY_PAYMENT'
, PMETH_INFORMATION1
, 'FI THIRD PARTY PAYMENT'
, PMETH_INFORMATION1
, NULL))
, PMETH_INFORMATION1
, PMETH_INFORMATION2
, PMETH_INFORMATION3
, PMETH_INFORMATION1
, PMETH_INFORMATION2
, PMETH_INFORMATION3
, PMETH_INFORMATION4
, PMETH_INFORMATION1
, PMETH_INFORMATION2
, PMETH_INFORMATION1
, PMETH_INFORMATION1
, PMETH_INFORMATION2
, PMETH_INFORMATION3
, PMETH_INFORMATION4
, PMETH_INFORMATION5
, PMETH_INFORMATION6
, PMETH_INFORMATION7
, PMETH_INFORMATION8
, PMETH_INFORMATION1
, PMETH_INFORMATION2
, PMETH_INFORMATION3
, PMETH_INFORMATION4
, PMETH_INFORMATION5
, PMETH_INFORMATION6
, PMETH_INFORMATION7
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'NO PAYMENT PROCESS'
, FND_NUMBER.CANONICAL_TO_NUMBER(PMETH_INFORMATION1)
, NULL))
, PMETH_INFORMATION2
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'NO PAYMENT PROCESS'
, FND_NUMBER.CANONICAL_TO_NUMBER(PMETH_INFORMATION3)
, NULL))
, (DECODE (PMETH_INFORMATION_CATEGORY
, 'NO PAYMENT PROCESS'
, FND_NUMBER.CANONICAL_TO_NUMBER(PMETH_INFORMATION4)
, NULL))
, PMETH_INFORMATION2
, PMETH_INFORMATION3
,
(DECODE (PMETH_INFORMATION_CATEGORY
,
'AE DIRECT DEPOSIT AED'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5
,
'AUTOPAY'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2
,
'BACS TAPE'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION6 || '.' || PMETH_INFORMATION7 || '.' || PMETH_INFORMATION8
,
'BF_PAYMETH'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2
,
'CANADIAN DIRECT DEPOSIT'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION6 || '.' || PMETH_INFORMATION7 || '.' || PMETH_INFORMATION9 || '.' || PMETH_INFORMATION8
,
'CASH'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1
,
'DIRECT CREDIT - ASB CSV'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1
,
'DIRECT DEPOSIT'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1
,
'DIRECT ENTRY'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION6 || '.' || PMETH_INFORMATION7 || '.' || PMETH_INFORMATION8 || '.' || PMETH_INFORMATION9
,
'FI THIRD PARTY PAYMENT'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1
,
'JP_SALARY'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3
,
'KR COURT ORDER PAYMENTS'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4
,
'KR DIRECT DEPOSIT'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2
,
'KW DIRECT DEPOSIT KWD'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3
,
'MEXICAN DIRECT DEPOSIT'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1
,
'NACHA'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION6 || '.' || PMETH_INFORMATION7 || '.' || PMETH_INFORMATION8
,
'NL DIRECT DEPOSIT EUR'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4 || '.' || PMETH_INFORMATION5 || '.' || PMETH_INFORMATION6 || '.' || PMETH_INFORMATION7
,
'NO PAYMENT PROCESS'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3 || '.' || PMETH_INFORMATION4
,
'NO_THIRD_PARTY_PAYMENT'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3
,
'SA DIRECT DEPOSIT SAR'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1 || '.' || PMETH_INFORMATION2 || '.' || PMETH_INFORMATION3
,
'SE THIRD PARTY PAYMENT'
, PMETH_INFORMATION_CATEGORY || '.' || PMETH_INFORMATION1
, NULL))
FROM PAY_ORG_PAYMENT_METHODS_F
|
|
|