VIEW: APPS.BEN_PL_EXTRA_INFO_DFV

Source

View Text - Preformatted

SELECT ROWID, PLI_INFORMATION_CATEGORY, (DECODE (PLI_INFORMATION_CATEGORY, 'CWB_CUSTOM_DOWNLOAD', PLI_INFORMATION1, NULL)), (DECODE (PLI_INFORMATION_CATEGORY, 'CWB_CUSTOM_DOWNLOAD', PLI_INFORMATION2, NULL)), (DECODE (PLI_INFORMATION_CATEGORY, 'CWB_CUSTOM_DOWNLOAD', PLI_INFORMATION3, NULL)), (DECODE (PLI_INFORMATION_CATEGORY, 'CWB_CUSTOM_DOWNLOAD', FND_NUMBER.CANONICAL_TO_NUMBER(PLI_INFORMATION4), NULL)),  
 (DECODE (PLI_INFORMATION_CATEGORY,  
      'CWB_CUSTOM_DOWNLOAD', PLI_INFORMATION_CATEGORY || '.' || PLI_INFORMATION1 || '.' || PLI_INFORMATION2 || '.' || PLI_INFORMATION3 || '.' || PLI_INFORMATION4, NULL)) 
 FROM BEN_PL_EXTRA_INFO

View Text - HTML Formatted

SELECT ROWID
, PLI_INFORMATION_CATEGORY
, (DECODE (PLI_INFORMATION_CATEGORY
, 'CWB_CUSTOM_DOWNLOAD'
, PLI_INFORMATION1
, NULL))
, (DECODE (PLI_INFORMATION_CATEGORY
, 'CWB_CUSTOM_DOWNLOAD'
, PLI_INFORMATION2
, NULL))
, (DECODE (PLI_INFORMATION_CATEGORY
, 'CWB_CUSTOM_DOWNLOAD'
, PLI_INFORMATION3
, NULL))
, (DECODE (PLI_INFORMATION_CATEGORY
, 'CWB_CUSTOM_DOWNLOAD'
, FND_NUMBER.CANONICAL_TO_NUMBER(PLI_INFORMATION4)
, NULL))
, (DECODE (PLI_INFORMATION_CATEGORY
, 'CWB_CUSTOM_DOWNLOAD'
, PLI_INFORMATION_CATEGORY || '.' || PLI_INFORMATION1 || '.' || PLI_INFORMATION2 || '.' || PLI_INFORMATION3 || '.' || PLI_INFORMATION4
, NULL))
FROM BEN_PL_EXTRA_INFO