VIEW: APPS.BEN_PGM_EXTRA_INFO_DFV

Source

View Text - Preformatted

SELECT ROWID, PGI_INFORMATION_CATEGORY, (DECODE (PGI_INFORMATION_CATEGORY, 'ADJ_CVG_PREV_LF_EVT', PGI_INFORMATION1, NULL)), (DECODE (PGI_INFORMATION_CATEGORY, 'ADJ_RATE_PREV_LF_EVT', PGI_INFORMATION1, NULL)), (DECODE (PGI_INFORMATION_CATEGORY, 'PQH_FR_CORP_INFO', PGI_INFORMATION1, NULL)), (DECODE (PGI_INFORMATION_CATEGORY, 'PQH_FR_CORP_INFO', PGI_INFORMATION2, NULL)), (DECODE (PGI_INFORMATION_CATEGORY, 'PQH_FR_CORP_INFO', PGI_INFORMATION3, NULL)), (DECODE (PGI_INFORMATION_CATEGORY, 'PQH_GSP_EXTRA_INFO', PGI_INFORMATION1, NULL)), (DECODE (PGI_INFORMATION_CATEGORY, 'PQH_GSP_EXTRA_INFO', PGI_INFORMATION2, NULL)), (DECODE (PGI_INFORMATION_CATEGORY, 'PQH_GSP_EXTRA_INFO', PGI_INFORMATION3, NULL)), (DECODE (PGI_INFORMATION_CATEGORY, 'PQH_GSP_EXTRA_INFO', PGI_INFORMATION4, NULL)), (DECODE (PGI_INFORMATION_CATEGORY, 'PQH_GSP_EXTRA_INFO', PGI_INFORMATION5, NULL)),  
 (DECODE (PGI_INFORMATION_CATEGORY,  
      'ADJ_CVG_PREV_LF_EVT', PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1,  
      'ADJ_RATE_PREV_LF_EVT', PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1,  
      'PQH_FR_CORP_INFO', PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1 || '.' || PGI_INFORMATION2 || '.' || PGI_INFORMATION3,  
      'PQH_GSP_EXTRA_INFO', PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1 || '.' || PGI_INFORMATION2 || '.' || PGI_INFORMATION3 || '.' || PGI_INFORMATION4 || '.' || PGI_INFORMATION5, NULL)) 
 FROM BEN_PGM_EXTRA_INFO

View Text - HTML Formatted

SELECT ROWID
, PGI_INFORMATION_CATEGORY
, (DECODE (PGI_INFORMATION_CATEGORY
, 'ADJ_CVG_PREV_LF_EVT'
, PGI_INFORMATION1
, NULL))
, (DECODE (PGI_INFORMATION_CATEGORY
, 'ADJ_RATE_PREV_LF_EVT'
, PGI_INFORMATION1
, NULL))
, (DECODE (PGI_INFORMATION_CATEGORY
, 'PQH_FR_CORP_INFO'
, PGI_INFORMATION1
, NULL))
, (DECODE (PGI_INFORMATION_CATEGORY
, 'PQH_FR_CORP_INFO'
, PGI_INFORMATION2
, NULL))
, (DECODE (PGI_INFORMATION_CATEGORY
, 'PQH_FR_CORP_INFO'
, PGI_INFORMATION3
, NULL))
, (DECODE (PGI_INFORMATION_CATEGORY
, 'PQH_GSP_EXTRA_INFO'
, PGI_INFORMATION1
, NULL))
, (DECODE (PGI_INFORMATION_CATEGORY
, 'PQH_GSP_EXTRA_INFO'
, PGI_INFORMATION2
, NULL))
, (DECODE (PGI_INFORMATION_CATEGORY
, 'PQH_GSP_EXTRA_INFO'
, PGI_INFORMATION3
, NULL))
, (DECODE (PGI_INFORMATION_CATEGORY
, 'PQH_GSP_EXTRA_INFO'
, PGI_INFORMATION4
, NULL))
, (DECODE (PGI_INFORMATION_CATEGORY
, 'PQH_GSP_EXTRA_INFO'
, PGI_INFORMATION5
, NULL))
, (DECODE (PGI_INFORMATION_CATEGORY
, 'ADJ_CVG_PREV_LF_EVT'
, PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1
, 'ADJ_RATE_PREV_LF_EVT'
, PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1
, 'PQH_FR_CORP_INFO'
, PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1 || '.' || PGI_INFORMATION2 || '.' || PGI_INFORMATION3
, 'PQH_GSP_EXTRA_INFO'
, PGI_INFORMATION_CATEGORY || '.' || PGI_INFORMATION1 || '.' || PGI_INFORMATION2 || '.' || PGI_INFORMATION3 || '.' || PGI_INFORMATION4 || '.' || PGI_INFORMATION5
, NULL))
FROM BEN_PGM_EXTRA_INFO