VIEW: APPS.HR_FORM_PROPERTIES_DFV

Source

View Text - Preformatted

SELECT ROWID, INFORMATION_CATEGORY, (DECODE (INFORMATION_CATEGORY, 'QUICK_HIRE', INFORMATION1, 'PERWSQHM', INFORMATION1, NULL)), (DECODE (INFORMATION_CATEGORY, 'QUICK_HIRE', INFORMATION2, 'PERWSQHM', INFORMATION2, NULL)), INFORMATION6, (DECODE (INFORMATION_CATEGORY, 'QUICK_HIRE', INFORMATION3, 'PERWSQHM', INFORMATION3, NULL)), (DECODE (INFORMATION_CATEGORY, 'QUICK_HIRE', INFORMATION4, 'PERWSQHM', INFORMATION4, NULL)), (DECODE (INFORMATION_CATEGORY, 'QUICK_HIRE', INFORMATION5, 'PERWSQHM', INFORMATION5, NULL)),  
 (DECODE (INFORMATION_CATEGORY,  
      'PERWSQHM', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION6 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5,  
      'QUICK_HIRE', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5, NULL)) 
 FROM HR_FORM_PROPERTIES

View Text - HTML Formatted

SELECT ROWID
, INFORMATION_CATEGORY
, (DECODE (INFORMATION_CATEGORY
, 'QUICK_HIRE'
, INFORMATION1
, 'PERWSQHM'
, INFORMATION1
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'QUICK_HIRE'
, INFORMATION2
, 'PERWSQHM'
, INFORMATION2
, NULL))
, INFORMATION6
, (DECODE (INFORMATION_CATEGORY
, 'QUICK_HIRE'
, INFORMATION3
, 'PERWSQHM'
, INFORMATION3
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'QUICK_HIRE'
, INFORMATION4
, 'PERWSQHM'
, INFORMATION4
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'QUICK_HIRE'
, INFORMATION5
, 'PERWSQHM'
, INFORMATION5
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'PERWSQHM'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION6 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5
, 'QUICK_HIRE'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3 || '.' || INFORMATION4 || '.' || INFORMATION5
, NULL))
FROM HR_FORM_PROPERTIES