DBA Data[Home] [Help]

VIEW: APPS.PQH_ROLES_DFV

Source

View Text - Preformatted

SELECT ROWID, INFORMATION_CATEGORY, INFORMATION1, INFORMATION2, INFORMATION3,  
 (DECODE (INFORMATION_CATEGORY,  
      'FR_PQH', INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3, NULL)) 
 FROM PQH_ROLES
View Text - HTML Formatted

SELECT ROWID
, INFORMATION_CATEGORY
, INFORMATION1
, INFORMATION2
, INFORMATION3
, (DECODE (INFORMATION_CATEGORY
, 'FR_PQH'
, INFORMATION_CATEGORY || '.' || INFORMATION1 || '.' || INFORMATION2 || '.' || INFORMATION3
, NULL))
FROM PQH_ROLES