VIEW: APPS.PER_DISABILITIES_F_DFV

Source

View Text - Preformatted

SELECT ROWID, DIS_INFORMATION_CATEGORY, DIS_INFORMATION1, DIS_INFORMATION1, (DECODE (DIS_INFORMATION_CATEGORY, 'DE', TO_DATE(DIS_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (DIS_INFORMATION_CATEGORY, 'DE', TO_DATE(DIS_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), DIS_INFORMATION1, DIS_INFORMATION1, DIS_INFORMATION2, DIS_INFORMATION1, DIS_INFORMATION1, DIS_INFORMATION1, (DECODE (DIS_INFORMATION_CATEGORY, 'KR', TO_DATE(DIS_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), DIS_INFORMATION3, DIS_INFORMATION1, DIS_INFORMATION2, DIS_INFORMATION1, DIS_INFORMATION2, DIS_INFORMATION3, DIS_INFORMATION4, DIS_INFORMATION5, DIS_INFORMATION3, DIS_INFORMATION1, (DECODE (DIS_INFORMATION_CATEGORY, 'NL', FND_NUMBER.CANONICAL_TO_NUMBER(DIS_INFORMATION4), NULL)), DIS_INFORMATION5, DIS_INFORMATION2, DIS_INFORMATION1,  
 (DECODE (DIS_INFORMATION_CATEGORY,  
      'AE', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1,  
      'DE', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION2 || '.' || DIS_INFORMATION3,  
      'ES', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1,  
      'FR', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION2,  
      'HU', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1,  
      'IN', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1,  
      'KR', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION2 || '.' || DIS_INFORMATION3,  
      'KW', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION2,  
      'MX', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION2 || '.' || DIS_INFORMATION3 || '.' || DIS_INFORMATION4 || '.' || DIS_INFORMATION5,  
      'NL', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION3 || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION4 || '.' || DIS_INFORMATION5 || '.' || DIS_INFORMATION2,  
      'SA', DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1, NULL)) 
 FROM PER_DISABILITIES_F

View Text - HTML Formatted

SELECT ROWID
, DIS_INFORMATION_CATEGORY
, DIS_INFORMATION1
, DIS_INFORMATION1
, (DECODE (DIS_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(DIS_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (DIS_INFORMATION_CATEGORY
, 'DE'
, TO_DATE(DIS_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, DIS_INFORMATION1
, DIS_INFORMATION1
, DIS_INFORMATION2
, DIS_INFORMATION1
, DIS_INFORMATION1
, DIS_INFORMATION1
, (DECODE (DIS_INFORMATION_CATEGORY
, 'KR'
, TO_DATE(DIS_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, DIS_INFORMATION3
, DIS_INFORMATION1
, DIS_INFORMATION2
, DIS_INFORMATION1
, DIS_INFORMATION2
, DIS_INFORMATION3
, DIS_INFORMATION4
, DIS_INFORMATION5
, DIS_INFORMATION3
, DIS_INFORMATION1
, (DECODE (DIS_INFORMATION_CATEGORY
, 'NL'
, FND_NUMBER.CANONICAL_TO_NUMBER(DIS_INFORMATION4)
, NULL))
, DIS_INFORMATION5
, DIS_INFORMATION2
, DIS_INFORMATION1
, (DECODE (DIS_INFORMATION_CATEGORY
, 'AE'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1
, 'DE'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION2 || '.' || DIS_INFORMATION3
, 'ES'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1
, 'FR'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION2
, 'HU'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1
, 'IN'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1
, 'KR'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION2 || '.' || DIS_INFORMATION3
, 'KW'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION2
, 'MX'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION2 || '.' || DIS_INFORMATION3 || '.' || DIS_INFORMATION4 || '.' || DIS_INFORMATION5
, 'NL'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION3 || '.' || DIS_INFORMATION1 || '.' || DIS_INFORMATION4 || '.' || DIS_INFORMATION5 || '.' || DIS_INFORMATION2
, 'SA'
, DIS_INFORMATION_CATEGORY || '.' || DIS_INFORMATION1
, NULL))
FROM PER_DISABILITIES_F