VIEW: APPS.PAY_US_EMP_STATE_TAX_RULE1_DFV

Source

View Text - Preformatted

SELECT ROWID, STA_INFORMATION_CATEGORY, STA_INFORMATION2, (DECODE (STA_INFORMATION_CATEGORY, 'AZ', STA_INFORMATION3, NULL)), (DECODE (STA_INFORMATION_CATEGORY, 'CA', STA_INFORMATION9, NULL)), (DECODE (STA_INFORMATION_CATEGORY, 'CT', TO_DATE(STA_INFORMATION8, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (STA_INFORMATION_CATEGORY, 'WI', STA_INFORMATION1, 'IN', STA_INFORMATION1, NULL)), (DECODE (STA_INFORMATION_CATEGORY, 'NJ', STA_INFORMATION5, NULL)), (DECODE (STA_INFORMATION_CATEGORY, 'NY', STA_INFORMATION10, NULL)), (DECODE (STA_INFORMATION_CATEGORY, 'WI', FND_NUMBER.CANONICAL_TO_NUMBER(STA_INFORMATION6), NULL)),  
 STA_INFORMATION2 || '.' || (DECODE (STA_INFORMATION_CATEGORY,  
      'AK', STA_INFORMATION_CATEGORY,  
      'AL', STA_INFORMATION_CATEGORY,  
      'AR', STA_INFORMATION_CATEGORY,  
      'AZ', STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION3,  
      'CA', STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION9,  
      'CO', STA_INFORMATION_CATEGORY,  
      'CT', STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION8,  
      'DC', STA_INFORMATION_CATEGORY,  
      'DE', STA_INFORMATION_CATEGORY,  
      'FL', STA_INFORMATION_CATEGORY,  
      'GA', STA_INFORMATION_CATEGORY,  
      'HI', STA_INFORMATION_CATEGORY,  
      'IA', STA_INFORMATION_CATEGORY,  
      'ID', STA_INFORMATION_CATEGORY,  
      'IL', STA_INFORMATION_CATEGORY,  
      'IN', STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION1,  
      'KS', STA_INFORMATION_CATEGORY,  
      'KY', STA_INFORMATION_CATEGORY,  
      'LA', STA_INFORMATION_CATEGORY,  
      'MA', STA_INFORMATION_CATEGORY,  
      'MD', STA_INFORMATION_CATEGORY,  
      'ME', STA_INFORMATION_CATEGORY,  
      'MI', STA_INFORMATION_CATEGORY,  
      'MN', STA_INFORMATION_CATEGORY,  
      'MO', STA_INFORMATION_CATEGORY,  
      'MS', STA_INFORMATION_CATEGORY,  
      'MT', STA_INFORMATION_CATEGORY,  
      'NC', STA_INFORMATION_CATEGORY,  
      'ND', STA_INFORMATION_CATEGORY,  
      'NE', STA_INFORMATION_CATEGORY,  
      'NH', STA_INFORMATION_CATEGORY,  
      'NJ', STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION5,  
      'NM', STA_INFORMATION_CATEGORY,  
      'NV', STA_INFORMATION_CATEGORY,  
      'NY', STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION10,  
      'OH', STA_INFORMATION_CATEGORY,  
      'OK', STA_INFORMATION_CATEGORY,  
      'OR', STA_INFORMATION_CATEGORY,  
      'PA', STA_INFORMATION_CATEGORY,  
      'RI', STA_INFORMATION_CATEGORY,  
      'SC', STA_INFORMATION_CATEGORY,  
      'SD', STA_INFORMATION_CATEGORY,  
      'TN', STA_INFORMATION_CATEGORY,  
      'TX', STA_INFORMATION_CATEGORY,  
      'UT', STA_INFORMATION_CATEGORY,  
      'VA', STA_INFORMATION_CATEGORY,  
      'VT', STA_INFORMATION_CATEGORY,  
      'WA', STA_INFORMATION_CATEGORY,  
      'WI', STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION1 || '.' || STA_INFORMATION6,  
      'WV', STA_INFORMATION_CATEGORY, (DECODE (STA_INFORMATION_CATEGORY,  
      'WY', STA_INFORMATION_CATEGORY, NULL)))) 
 FROM PAY_US_EMP_STATE_TAX_RULES_F

View Text - HTML Formatted

SELECT ROWID
, STA_INFORMATION_CATEGORY
, STA_INFORMATION2
, (DECODE (STA_INFORMATION_CATEGORY
, 'AZ'
, STA_INFORMATION3
, NULL))
, (DECODE (STA_INFORMATION_CATEGORY
, 'CA'
, STA_INFORMATION9
, NULL))
, (DECODE (STA_INFORMATION_CATEGORY
, 'CT'
, TO_DATE(STA_INFORMATION8
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (STA_INFORMATION_CATEGORY
, 'WI'
, STA_INFORMATION1
, 'IN'
, STA_INFORMATION1
, NULL))
, (DECODE (STA_INFORMATION_CATEGORY
, 'NJ'
, STA_INFORMATION5
, NULL))
, (DECODE (STA_INFORMATION_CATEGORY
, 'NY'
, STA_INFORMATION10
, NULL))
, (DECODE (STA_INFORMATION_CATEGORY
, 'WI'
, FND_NUMBER.CANONICAL_TO_NUMBER(STA_INFORMATION6)
, NULL))
, STA_INFORMATION2 || '.' || (DECODE (STA_INFORMATION_CATEGORY
, 'AK'
, STA_INFORMATION_CATEGORY
, 'AL'
, STA_INFORMATION_CATEGORY
, 'AR'
, STA_INFORMATION_CATEGORY
, 'AZ'
, STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION3
, 'CA'
, STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION9
, 'CO'
, STA_INFORMATION_CATEGORY
, 'CT'
, STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION8
, 'DC'
, STA_INFORMATION_CATEGORY
, 'DE'
, STA_INFORMATION_CATEGORY
, 'FL'
, STA_INFORMATION_CATEGORY
, 'GA'
, STA_INFORMATION_CATEGORY
, 'HI'
, STA_INFORMATION_CATEGORY
, 'IA'
, STA_INFORMATION_CATEGORY
, 'ID'
, STA_INFORMATION_CATEGORY
, 'IL'
, STA_INFORMATION_CATEGORY
, 'IN'
, STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION1
, 'KS'
, STA_INFORMATION_CATEGORY
, 'KY'
, STA_INFORMATION_CATEGORY
, 'LA'
, STA_INFORMATION_CATEGORY
, 'MA'
, STA_INFORMATION_CATEGORY
, 'MD'
, STA_INFORMATION_CATEGORY
, 'ME'
, STA_INFORMATION_CATEGORY
, 'MI'
, STA_INFORMATION_CATEGORY
, 'MN'
, STA_INFORMATION_CATEGORY
, 'MO'
, STA_INFORMATION_CATEGORY
, 'MS'
, STA_INFORMATION_CATEGORY
, 'MT'
, STA_INFORMATION_CATEGORY
, 'NC'
, STA_INFORMATION_CATEGORY
, 'ND'
, STA_INFORMATION_CATEGORY
, 'NE'
, STA_INFORMATION_CATEGORY
, 'NH'
, STA_INFORMATION_CATEGORY
, 'NJ'
, STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION5
, 'NM'
, STA_INFORMATION_CATEGORY
, 'NV'
, STA_INFORMATION_CATEGORY
, 'NY'
, STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION10
, 'OH'
, STA_INFORMATION_CATEGORY
, 'OK'
, STA_INFORMATION_CATEGORY
, 'OR'
, STA_INFORMATION_CATEGORY
, 'PA'
, STA_INFORMATION_CATEGORY
, 'RI'
, STA_INFORMATION_CATEGORY
, 'SC'
, STA_INFORMATION_CATEGORY
, 'SD'
, STA_INFORMATION_CATEGORY
, 'TN'
, STA_INFORMATION_CATEGORY
, 'TX'
, STA_INFORMATION_CATEGORY
, 'UT'
, STA_INFORMATION_CATEGORY
, 'VA'
, STA_INFORMATION_CATEGORY
, 'VT'
, STA_INFORMATION_CATEGORY
, 'WA'
, STA_INFORMATION_CATEGORY
, 'WI'
, STA_INFORMATION_CATEGORY || '.' || STA_INFORMATION1 || '.' || STA_INFORMATION6
, 'WV'
, STA_INFORMATION_CATEGORY
, (DECODE (STA_INFORMATION_CATEGORY
, 'WY'
, STA_INFORMATION_CATEGORY
, NULL))))
FROM PAY_US_EMP_STATE_TAX_RULES_F