VIEW: APPS.PAY_PERSONAL_PAYMENT_METH1_DFV

Source

View Text - Preformatted

SELECT ROWID, PPM_INFORMATION_CATEGORY, (DECODE (PPM_INFORMATION_CATEGORY, 'AE_AE DIRECT DEPOSIT AED', PPM_INFORMATION1, NULL)), (DECODE (PPM_INFORMATION_CATEGORY, 'IN_PAY ORDER', PPM_INFORMATION1, 'IN_DEMAND DRAFT', PPM_INFORMATION1, NULL)), (DECODE (PPM_INFORMATION_CATEGORY, 'US_NACHA', PPM_INFORMATION4, NULL)), (DECODE (PPM_INFORMATION_CATEGORY, 'US_NACHA', PPM_INFORMATION1, NULL)), (DECODE (PPM_INFORMATION_CATEGORY, 'US_NACHA', PPM_INFORMATION2, NULL)), (DECODE (PPM_INFORMATION_CATEGORY, 'US_NACHA', PPM_INFORMATION3, NULL)), (DECODE (PPM_INFORMATION_CATEGORY, 'ZA_CREDIT TRANSFER', PPM_INFORMATION1, 'ZA_ACB', PPM_INFORMATION1, NULL)), (DECODE (PPM_INFORMATION_CATEGORY, 'ZA_MANUAL PAYMENT', PPM_INFORMATION1, 'ZA_CHEQUE', PPM_INFORMATION1, NULL)),  
 (DECODE (PPM_INFORMATION_CATEGORY,  
      'AE_AE DIRECT DEPOSIT AED', PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1,  
      'IN_DEMAND DRAFT', PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1,  
      'IN_PAY ORDER', PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1,  
      'US_NACHA', PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION4 || '.' || PPM_INFORMATION1 || '.' || PPM_INFORMATION2 || '.' || PPM_INFORMATION3,  
      'ZA_ACB', PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1,  
      'ZA_CHEQUE', PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1,  
      'ZA_CREDIT TRANSFER', PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1,  
      'ZA_MANUAL PAYMENT', PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1, NULL)) 
 FROM PAY_PERSONAL_PAYMENT_METHODS_F

View Text - HTML Formatted

SELECT ROWID
, PPM_INFORMATION_CATEGORY
, (DECODE (PPM_INFORMATION_CATEGORY
, 'AE_AE DIRECT DEPOSIT AED'
, PPM_INFORMATION1
, NULL))
, (DECODE (PPM_INFORMATION_CATEGORY
, 'IN_PAY ORDER'
, PPM_INFORMATION1
, 'IN_DEMAND DRAFT'
, PPM_INFORMATION1
, NULL))
, (DECODE (PPM_INFORMATION_CATEGORY
, 'US_NACHA'
, PPM_INFORMATION4
, NULL))
, (DECODE (PPM_INFORMATION_CATEGORY
, 'US_NACHA'
, PPM_INFORMATION1
, NULL))
, (DECODE (PPM_INFORMATION_CATEGORY
, 'US_NACHA'
, PPM_INFORMATION2
, NULL))
, (DECODE (PPM_INFORMATION_CATEGORY
, 'US_NACHA'
, PPM_INFORMATION3
, NULL))
, (DECODE (PPM_INFORMATION_CATEGORY
, 'ZA_CREDIT TRANSFER'
, PPM_INFORMATION1
, 'ZA_ACB'
, PPM_INFORMATION1
, NULL))
, (DECODE (PPM_INFORMATION_CATEGORY
, 'ZA_MANUAL PAYMENT'
, PPM_INFORMATION1
, 'ZA_CHEQUE'
, PPM_INFORMATION1
, NULL))
, (DECODE (PPM_INFORMATION_CATEGORY
, 'AE_AE DIRECT DEPOSIT AED'
, PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1
, 'IN_DEMAND DRAFT'
, PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1
, 'IN_PAY ORDER'
, PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1
, 'US_NACHA'
, PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION4 || '.' || PPM_INFORMATION1 || '.' || PPM_INFORMATION2 || '.' || PPM_INFORMATION3
, 'ZA_ACB'
, PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1
, 'ZA_CHEQUE'
, PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1
, 'ZA_CREDIT TRANSFER'
, PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1
, 'ZA_MANUAL PAYMENT'
, PPM_INFORMATION_CATEGORY || '.' || PPM_INFORMATION1
, NULL))
FROM PAY_PERSONAL_PAYMENT_METHODS_F