VIEW: APPS.PAY_US_COUNTY_TAX_INFO_F_DFV

Source

View Text - Preformatted

SELECT ROWID, CNTY_INFORMATION_CATEGORY, (DECODE (CNTY_INFORMATION_CATEGORY, 'County tax status info', CNTY_INFORMATION1, NULL)), (DECODE (CNTY_INFORMATION_CATEGORY, 'County tax status info', FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION2), NULL)), (DECODE (CNTY_INFORMATION_CATEGORY, 'County tax status info', FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION3), NULL)), (DECODE (CNTY_INFORMATION_CATEGORY, 'County tax status info', FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION4), NULL)), (DECODE (CNTY_INFORMATION_CATEGORY, 'County tax status info', FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION5), NULL)), (DECODE (CNTY_INFORMATION_CATEGORY, 'County tax status info', FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION6), NULL)), (DECODE (CNTY_INFORMATION_CATEGORY, 'County tax status info', FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION7), NULL)), (DECODE (CNTY_INFORMATION_CATEGORY, 'County tax status info', FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION8), NULL)),  
 (DECODE (CNTY_INFORMATION_CATEGORY,  
      'County tax status info', CNTY_INFORMATION_CATEGORY || '.' || CNTY_INFORMATION1 || '.' || CNTY_INFORMATION2 || '.' || CNTY_INFORMATION3 || '.' || CNTY_INFORMATION4 || '.' || CNTY_INFORMATION5 || '.' || CNTY_INFORMATION6 || '.' || CNTY_INFORMATION7 || '.' || CNTY_INFORMATION8, NULL)) 
 FROM PAY_US_COUNTY_TAX_INFO_F

View Text - HTML Formatted

SELECT ROWID
, CNTY_INFORMATION_CATEGORY
, (DECODE (CNTY_INFORMATION_CATEGORY
, 'COUNTY TAX STATUS INFO'
, CNTY_INFORMATION1
, NULL))
, (DECODE (CNTY_INFORMATION_CATEGORY
, 'COUNTY TAX STATUS INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION2)
, NULL))
, (DECODE (CNTY_INFORMATION_CATEGORY
, 'COUNTY TAX STATUS INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION3)
, NULL))
, (DECODE (CNTY_INFORMATION_CATEGORY
, 'COUNTY TAX STATUS INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION4)
, NULL))
, (DECODE (CNTY_INFORMATION_CATEGORY
, 'COUNTY TAX STATUS INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION5)
, NULL))
, (DECODE (CNTY_INFORMATION_CATEGORY
, 'COUNTY TAX STATUS INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION6)
, NULL))
, (DECODE (CNTY_INFORMATION_CATEGORY
, 'COUNTY TAX STATUS INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION7)
, NULL))
, (DECODE (CNTY_INFORMATION_CATEGORY
, 'COUNTY TAX STATUS INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(CNTY_INFORMATION8)
, NULL))
, (DECODE (CNTY_INFORMATION_CATEGORY
, 'COUNTY TAX STATUS INFO'
, CNTY_INFORMATION_CATEGORY || '.' || CNTY_INFORMATION1 || '.' || CNTY_INFORMATION2 || '.' || CNTY_INFORMATION3 || '.' || CNTY_INFORMATION4 || '.' || CNTY_INFORMATION5 || '.' || CNTY_INFORMATION6 || '.' || CNTY_INFORMATION7 || '.' || CNTY_INFORMATION8
, NULL))
FROM PAY_US_COUNTY_TAX_INFO_F