VIEW: APPS.XLE_ETB_PROFILES1_DFV

Source

View Text - Preformatted

SELECT ROWID, ETB_INFORMATION_CONTEXT, (DECODE (ETB_INFORMATION_CONTEXT, 'RU', ACTIVITY_CODE, 'KR', ACTIVITY_CODE, 'FR', ACTIVITY_CODE, 'BR', ACTIVITY_CODE, NULL)), (DECODE (ETB_INFORMATION_CONTEXT, 'BR', TYPE_OF_COMPANY, NULL)), (DECODE (ETB_INFORMATION_CONTEXT, 'BR', ETB_INFORMATION1, NULL)), (DECODE (ETB_INFORMATION_CONTEXT, 'BR', ETB_INFORMATION2, NULL)), (DECODE (ETB_INFORMATION_CONTEXT, 'KR', SUB_ACTIVITY_CODE, NULL)),  
 (DECODE (ETB_INFORMATION_CONTEXT,  
      'BR', ETB_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || ETB_INFORMATION1 || '.' || ETB_INFORMATION2,  
      'FR', ETB_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE,  
      'KR', ETB_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE,  
      'RU', ETB_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE, NULL)) 
 FROM XLE_ETB_PROFILES

View Text - HTML Formatted

SELECT ROWID
, ETB_INFORMATION_CONTEXT
, (DECODE (ETB_INFORMATION_CONTEXT
, 'RU'
, ACTIVITY_CODE
, 'KR'
, ACTIVITY_CODE
, 'FR'
, ACTIVITY_CODE
, 'BR'
, ACTIVITY_CODE
, NULL))
, (DECODE (ETB_INFORMATION_CONTEXT
, 'BR'
, TYPE_OF_COMPANY
, NULL))
, (DECODE (ETB_INFORMATION_CONTEXT
, 'BR'
, ETB_INFORMATION1
, NULL))
, (DECODE (ETB_INFORMATION_CONTEXT
, 'BR'
, ETB_INFORMATION2
, NULL))
, (DECODE (ETB_INFORMATION_CONTEXT
, 'KR'
, SUB_ACTIVITY_CODE
, NULL))
, (DECODE (ETB_INFORMATION_CONTEXT
, 'BR'
, ETB_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || ETB_INFORMATION1 || '.' || ETB_INFORMATION2
, 'FR'
, ETB_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE
, 'KR'
, ETB_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE
, 'RU'
, ETB_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE
, NULL))
FROM XLE_ETB_PROFILES