VIEW: APPS.XLE_ENTITY_PROFILES1_DFV

Source

View Text - Preformatted

SELECT ROWID, LE_INFORMATION_CONTEXT, (DECODE (LE_INFORMATION_CONTEXT, 'AR', ACTIVITY_CODE, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'VE', TYPE_OF_COMPANY, 'US', TYPE_OF_COMPANY, 'TW', TYPE_OF_COMPANY, 'SG', TYPE_OF_COMPANY, 'RU', TYPE_OF_COMPANY, 'PT', TYPE_OF_COMPANY, 'PL', TYPE_OF_COMPANY, 'PE', TYPE_OF_COMPANY, 'NO', TYPE_OF_COMPANY, 'MX', TYPE_OF_COMPANY, 'LU', TYPE_OF_COMPANY, 'JP', TYPE_OF_COMPANY, 'IT', TYPE_OF_COMPANY, 'IN', TYPE_OF_COMPANY, 'IL', TYPE_OF_COMPANY, 'HU', TYPE_OF_COMPANY, 'GB', TYPE_OF_COMPANY, 'FR', TYPE_OF_COMPANY, 'ES', TYPE_OF_COMPANY, 'EG', TYPE_OF_COMPANY, 'DE', TYPE_OF_COMPANY, 'CO', TYPE_OF_COMPANY, 'CL', TYPE_OF_COMPANY, 'CH', TYPE_OF_COMPANY, 'BR', TYPE_OF_COMPANY, 'BE', TYPE_OF_COMPANY, 'AU', TYPE_OF_COMPANY, 'AR', TYPE_OF_COMPANY, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'TW', LE_INFORMATION1, 'RU', LE_INFORMATION1, 'PT', LE_INFORMATION1, 'MX', LE_INFORMATION1, 'JP', LE_INFORMATION1, 'IN', LE_INFORMATION1, 'HU', LE_INFORMATION1, 'FR', LE_INFORMATION1, 'DE', LE_INFORMATION1, 'BR', LE_INFORMATION1, 'AR', LE_INFORMATION1, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'TW', LE_INFORMATION2, 'RU', LE_INFORMATION2, 'PT', LE_INFORMATION2, 'MX', LE_INFORMATION2, 'IN', LE_INFORMATION2, 'FR', LE_INFORMATION2, 'DE', LE_INFORMATION2, 'BR', LE_INFORMATION2, 'AR', LE_INFORMATION2, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'US', ACTIVITY_CODE, 'TW', ACTIVITY_CODE, 'SG', ACTIVITY_CODE, 'RU', ACTIVITY_CODE, 'PT', ACTIVITY_CODE, 'PE', ACTIVITY_CODE, 'NO', ACTIVITY_CODE, 'MX', ACTIVITY_CODE, 'LU', ACTIVITY_CODE, 'KR', ACTIVITY_CODE, 'JP', ACTIVITY_CODE, 'IT', ACTIVITY_CODE, 'IN', ACTIVITY_CODE, 'IL', ACTIVITY_CODE, 'HU', ACTIVITY_CODE, 'GR', ACTIVITY_CODE, 'FR', ACTIVITY_CODE, 'ES', ACTIVITY_CODE, 'DE', ACTIVITY_CODE, 'CL', ACTIVITY_CODE, 'CH', ACTIVITY_CODE, 'BR', ACTIVITY_CODE, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'TW', SUB_ACTIVITY_CODE, 'SG', SUB_ACTIVITY_CODE, 'PT', SUB_ACTIVITY_CODE, 'KR', SUB_ACTIVITY_CODE, 'JP', SUB_ACTIVITY_CODE, 'IN', SUB_ACTIVITY_CODE, 'ES', SUB_ACTIVITY_CODE, 'CH', SUB_ACTIVITY_CODE, 'BR', SUB_ACTIVITY_CODE, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'BR', LE_INFORMATION3, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'BR', LE_INFORMATION4, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'BR', LE_INFORMATION5, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'CO', ACTIVITY_CODE, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'SG', LE_INFORMATION1, 'MX', LE_INFORMATION3, 'FR', LE_INFORMATION3, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'GB', ACTIVITY_CODE, NULL)), (DECODE (LE_INFORMATION_CONTEXT, 'VE', ACTIVITY_CODE, NULL)),  
 (DECODE (LE_INFORMATION_CONTEXT,  
      'AR', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2,  
      'AU', LE_INFORMATION_CONTEXT || '.' || TYPE_OF_COMPANY,  
      'BE', LE_INFORMATION_CONTEXT || '.' || TYPE_OF_COMPANY,  
      'BR', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2 || '.' || LE_INFORMATION3 || '.' || LE_INFORMATION4 || '.' || LE_INFORMATION5,  
      'CH', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'CL', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'CO', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'DE', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2,  
      'EG', LE_INFORMATION_CONTEXT || '.' || TYPE_OF_COMPANY,  
      'ES', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'FR', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2 || '.' || LE_INFORMATION3,  
      'GB', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'GR', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE,  
      'HU', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1,  
      'IL', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'IN', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2,  
      'IT', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'JP', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1,  
      'KR', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE,  
      'LU', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'MX', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2 || '.' || LE_INFORMATION3,  
      'NO', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'PE', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'PL', LE_INFORMATION_CONTEXT || '.' || TYPE_OF_COMPANY,  
      'PT', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2,  
      'RU', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2,  
      'SG', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1,  
      'TW', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2,  
      'US', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY,  
      'VE', LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY, NULL)) 
 FROM XLE_ENTITY_PROFILES

View Text - HTML Formatted

SELECT ROWID
, LE_INFORMATION_CONTEXT
, (DECODE (LE_INFORMATION_CONTEXT
, 'AR'
, ACTIVITY_CODE
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'VE'
, TYPE_OF_COMPANY
, 'US'
, TYPE_OF_COMPANY
, 'TW'
, TYPE_OF_COMPANY
, 'SG'
, TYPE_OF_COMPANY
, 'RU'
, TYPE_OF_COMPANY
, 'PT'
, TYPE_OF_COMPANY
, 'PL'
, TYPE_OF_COMPANY
, 'PE'
, TYPE_OF_COMPANY
, 'NO'
, TYPE_OF_COMPANY
, 'MX'
, TYPE_OF_COMPANY
, 'LU'
, TYPE_OF_COMPANY
, 'JP'
, TYPE_OF_COMPANY
, 'IT'
, TYPE_OF_COMPANY
, 'IN'
, TYPE_OF_COMPANY
, 'IL'
, TYPE_OF_COMPANY
, 'HU'
, TYPE_OF_COMPANY
, 'GB'
, TYPE_OF_COMPANY
, 'FR'
, TYPE_OF_COMPANY
, 'ES'
, TYPE_OF_COMPANY
, 'EG'
, TYPE_OF_COMPANY
, 'DE'
, TYPE_OF_COMPANY
, 'CO'
, TYPE_OF_COMPANY
, 'CL'
, TYPE_OF_COMPANY
, 'CH'
, TYPE_OF_COMPANY
, 'BR'
, TYPE_OF_COMPANY
, 'BE'
, TYPE_OF_COMPANY
, 'AU'
, TYPE_OF_COMPANY
, 'AR'
, TYPE_OF_COMPANY
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'TW'
, LE_INFORMATION1
, 'RU'
, LE_INFORMATION1
, 'PT'
, LE_INFORMATION1
, 'MX'
, LE_INFORMATION1
, 'JP'
, LE_INFORMATION1
, 'IN'
, LE_INFORMATION1
, 'HU'
, LE_INFORMATION1
, 'FR'
, LE_INFORMATION1
, 'DE'
, LE_INFORMATION1
, 'BR'
, LE_INFORMATION1
, 'AR'
, LE_INFORMATION1
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'TW'
, LE_INFORMATION2
, 'RU'
, LE_INFORMATION2
, 'PT'
, LE_INFORMATION2
, 'MX'
, LE_INFORMATION2
, 'IN'
, LE_INFORMATION2
, 'FR'
, LE_INFORMATION2
, 'DE'
, LE_INFORMATION2
, 'BR'
, LE_INFORMATION2
, 'AR'
, LE_INFORMATION2
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'US'
, ACTIVITY_CODE
, 'TW'
, ACTIVITY_CODE
, 'SG'
, ACTIVITY_CODE
, 'RU'
, ACTIVITY_CODE
, 'PT'
, ACTIVITY_CODE
, 'PE'
, ACTIVITY_CODE
, 'NO'
, ACTIVITY_CODE
, 'MX'
, ACTIVITY_CODE
, 'LU'
, ACTIVITY_CODE
, 'KR'
, ACTIVITY_CODE
, 'JP'
, ACTIVITY_CODE
, 'IT'
, ACTIVITY_CODE
, 'IN'
, ACTIVITY_CODE
, 'IL'
, ACTIVITY_CODE
, 'HU'
, ACTIVITY_CODE
, 'GR'
, ACTIVITY_CODE
, 'FR'
, ACTIVITY_CODE
, 'ES'
, ACTIVITY_CODE
, 'DE'
, ACTIVITY_CODE
, 'CL'
, ACTIVITY_CODE
, 'CH'
, ACTIVITY_CODE
, 'BR'
, ACTIVITY_CODE
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'TW'
, SUB_ACTIVITY_CODE
, 'SG'
, SUB_ACTIVITY_CODE
, 'PT'
, SUB_ACTIVITY_CODE
, 'KR'
, SUB_ACTIVITY_CODE
, 'JP'
, SUB_ACTIVITY_CODE
, 'IN'
, SUB_ACTIVITY_CODE
, 'ES'
, SUB_ACTIVITY_CODE
, 'CH'
, SUB_ACTIVITY_CODE
, 'BR'
, SUB_ACTIVITY_CODE
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'BR'
, LE_INFORMATION3
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'BR'
, LE_INFORMATION4
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'BR'
, LE_INFORMATION5
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'CO'
, ACTIVITY_CODE
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'SG'
, LE_INFORMATION1
, 'MX'
, LE_INFORMATION3
, 'FR'
, LE_INFORMATION3
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'GB'
, ACTIVITY_CODE
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'VE'
, ACTIVITY_CODE
, NULL))
, (DECODE (LE_INFORMATION_CONTEXT
, 'AR'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2
, 'AU'
, LE_INFORMATION_CONTEXT || '.' || TYPE_OF_COMPANY
, 'BE'
, LE_INFORMATION_CONTEXT || '.' || TYPE_OF_COMPANY
, 'BR'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2 || '.' || LE_INFORMATION3 || '.' || LE_INFORMATION4 || '.' || LE_INFORMATION5
, 'CH'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'CL'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'CO'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'DE'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2
, 'EG'
, LE_INFORMATION_CONTEXT || '.' || TYPE_OF_COMPANY
, 'ES'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'FR'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2 || '.' || LE_INFORMATION3
, 'GB'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'GR'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE
, 'HU'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1
, 'IL'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'IN'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2
, 'IT'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'JP'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1
, 'KR'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE
, 'LU'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'MX'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2 || '.' || LE_INFORMATION3
, 'NO'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'PE'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'PL'
, LE_INFORMATION_CONTEXT || '.' || TYPE_OF_COMPANY
, 'PT'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2
, 'RU'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2
, 'SG'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1
, 'TW'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || SUB_ACTIVITY_CODE || '.' || TYPE_OF_COMPANY || '.' || LE_INFORMATION1 || '.' || LE_INFORMATION2
, 'US'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, 'VE'
, LE_INFORMATION_CONTEXT || '.' || ACTIVITY_CODE || '.' || TYPE_OF_COMPANY
, NULL))
FROM XLE_ENTITY_PROFILES