VIEW: APPS.PER_PREV_JOB_EXTRA_INFO1_DFV

Source

View Text - Preformatted

SELECT ROWID, PJI_INFORMATION_CATEGORY, (DECODE (PJI_INFORMATION_CATEGORY, 'FR_PQH_STATUTORY_POSITIONS', TO_DATE(PJI_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), 'FR_PQH_ABSENCES_INFO', TO_DATE(PJI_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (PJI_INFORMATION_CATEGORY, 'FR_PQH_STATUTORY_POSITIONS', TO_DATE(PJI_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), 'FR_PQH_ABSENCES_INFO', TO_DATE(PJI_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), PJI_INFORMATION4, PJI_INFORMATION5, (DECODE (PJI_INFORMATION_CATEGORY, 'FR_PQH_ABSENCES_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(PJI_INFORMATION6), NULL)), (DECODE (PJI_INFORMATION_CATEGORY, 'FR_PQH_GRIEVANCE_INFO', TO_DATE(PJI_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), PJI_INFORMATION3, PJI_INFORMATION4, (DECODE (PJI_INFORMATION_CATEGORY, 'FR_PQH_GRIEVANCE_INFO', TO_DATE(PJI_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), PJI_INFORMATION4, PJI_INFORMATION1,  
 (DECODE (PJI_INFORMATION_CATEGORY,  
      'FR_PQH_ABSENCES_INFO', PJI_INFORMATION_CATEGORY || '.' || PJI_INFORMATION2 || '.' || PJI_INFORMATION3 || '.' || PJI_INFORMATION4 || '.' || PJI_INFORMATION5 || '.' || PJI_INFORMATION6,  
      'FR_PQH_GRIEVANCE_INFO', PJI_INFORMATION_CATEGORY || '.' || PJI_INFORMATION2 || '.' || PJI_INFORMATION3 || '.' || PJI_INFORMATION4 || '.' || PJI_INFORMATION5,  
      'FR_PQH_STATUTORY_POSITIONS', PJI_INFORMATION_CATEGORY || '.' || PJI_INFORMATION2 || '.' || PJI_INFORMATION3 || '.' || PJI_INFORMATION4,  
      'SA_PREV_EMP_JOB_RESP', PJI_INFORMATION_CATEGORY || '.' || PJI_INFORMATION1, NULL)) 
 FROM PER_PREV_JOB_EXTRA_INFO

View Text - HTML Formatted

SELECT ROWID
, PJI_INFORMATION_CATEGORY
, (DECODE (PJI_INFORMATION_CATEGORY
, 'FR_PQH_STATUTORY_POSITIONS'
, TO_DATE(PJI_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, 'FR_PQH_ABSENCES_INFO'
, TO_DATE(PJI_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (PJI_INFORMATION_CATEGORY
, 'FR_PQH_STATUTORY_POSITIONS'
, TO_DATE(PJI_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, 'FR_PQH_ABSENCES_INFO'
, TO_DATE(PJI_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, PJI_INFORMATION4
, PJI_INFORMATION5
, (DECODE (PJI_INFORMATION_CATEGORY
, 'FR_PQH_ABSENCES_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(PJI_INFORMATION6)
, NULL))
, (DECODE (PJI_INFORMATION_CATEGORY
, 'FR_PQH_GRIEVANCE_INFO'
, TO_DATE(PJI_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, PJI_INFORMATION3
, PJI_INFORMATION4
, (DECODE (PJI_INFORMATION_CATEGORY
, 'FR_PQH_GRIEVANCE_INFO'
, TO_DATE(PJI_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, PJI_INFORMATION4
, PJI_INFORMATION1
, (DECODE (PJI_INFORMATION_CATEGORY
, 'FR_PQH_ABSENCES_INFO'
, PJI_INFORMATION_CATEGORY || '.' || PJI_INFORMATION2 || '.' || PJI_INFORMATION3 || '.' || PJI_INFORMATION4 || '.' || PJI_INFORMATION5 || '.' || PJI_INFORMATION6
, 'FR_PQH_GRIEVANCE_INFO'
, PJI_INFORMATION_CATEGORY || '.' || PJI_INFORMATION2 || '.' || PJI_INFORMATION3 || '.' || PJI_INFORMATION4 || '.' || PJI_INFORMATION5
, 'FR_PQH_STATUTORY_POSITIONS'
, PJI_INFORMATION_CATEGORY || '.' || PJI_INFORMATION2 || '.' || PJI_INFORMATION3 || '.' || PJI_INFORMATION4
, 'SA_PREV_EMP_JOB_RESP'
, PJI_INFORMATION_CATEGORY || '.' || PJI_INFORMATION1
, NULL))
FROM PER_PREV_JOB_EXTRA_INFO