eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PER_CONTACT_RELATIONSHIPS_DFV

Source

View Text - Preformatted


SELECT ROWID, CONT_INFORMATION_CATEGORY, (DECODE (CONT_INFORMATION_CATEGORY, 'DE_PQH', CONT_INFORMATION1, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'DE_PQH', CONT_INFORMATION2, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'DE_PQH', CONT_INFORMATION3, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'DE_PQH', CONT_INFORMATION4, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'DE_PQH', FND_NUMBER.CANONICAL_TO_NUMBER(CONT_INFORMATION5), NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'DE_PQH', FND_NUMBER.CANONICAL_TO_NUMBER(CONT_INFORMATION6), NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'ES', CONT_INFORMATION1, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'ES', CONT_INFORMATION2, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'FR', CONT_INFORMATION1, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'FR', CONT_INFORMATION2, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'HU', CONT_INFORMATION2, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'HU', CONT_INFORMATION1, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'HU', CONT_INFORMATION3, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'IN', CONT_INFORMATION13, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'IN', TO_DATE(CONT_INFORMATION14, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'IN', CONT_INFORMATION15, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'IN', CONT_INFORMATION17, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'JP', CONT_INFORMATION1, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'JP', FND_NUMBER.CANONICAL_TO_NUMBER(CONT_INFORMATION2), NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'JP', CONT_INFORMATION3, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'KR', CONT_INFORMATION1, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'KR', CONT_INFORMATION2, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'KR', CONT_INFORMATION8, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'KR', CONT_INFORMATION3, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'KR', CONT_INFORMATION7, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'KR', CONT_INFORMATION4, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'KR', CONT_INFORMATION15, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'KR', CONT_INFORMATION5, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'KR', CONT_INFORMATION9, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'KR', CONT_INFORMATION11, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'NO', CONT_INFORMATION1, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'NO', CONT_INFORMATION2, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'PL', CONT_INFORMATION1, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'PL', CONT_INFORMATION2, NULL)), (DECODE (CONT_INFORMATION_CATEGORY, 'RU', CONT_INFORMATION1, NULL)),  
 (DECODE (CONT_INFORMATION_CATEGORY,  
      'DE_PQH', CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2 || '.' || CONT_INFORMATION3 || '.' || CONT_INFORMATION4 || '.' || CONT_INFORMATION5 || '.' || CONT_INFORMATION6,  
      'ES', CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2,  
      'FR', CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2,  
      'HU', CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION2 || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION3,  
      'IN', CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION13 || '.' || CONT_INFORMATION14 || '.' || CONT_INFORMATION15 || '.' || CONT_INFORMATION17,  
      'JP', CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2 || '.' || CONT_INFORMATION3,  
      'KR', CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2 || '.' || CONT_INFORMATION8 || '.' || CONT_INFORMATION3 || '.' || CONT_INFORMATION7 || '.' || CONT_INFORMATION4 || '.' || CONT_INFORMATION15 || '.' || CONT_INFORMATION5 || '.' || CONT_INFORMATION9 || '.' || CONT_INFORMATION11,  
      'NO', CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2,  
      'PL', CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2,  
      'RU', CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1, NULL)) 
 FROM PER_CONTACT_RELATIONSHIPS

View Text - HTML Formatted

SELECT ROWID
, CONT_INFORMATION_CATEGORY
, (DECODE (CONT_INFORMATION_CATEGORY
, 'DE_PQH'
, CONT_INFORMATION1
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'DE_PQH'
, CONT_INFORMATION2
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'DE_PQH'
, CONT_INFORMATION3
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'DE_PQH'
, CONT_INFORMATION4
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'DE_PQH'
, FND_NUMBER.CANONICAL_TO_NUMBER(CONT_INFORMATION5)
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'DE_PQH'
, FND_NUMBER.CANONICAL_TO_NUMBER(CONT_INFORMATION6)
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'ES'
, CONT_INFORMATION1
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'ES'
, CONT_INFORMATION2
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'FR'
, CONT_INFORMATION1
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'FR'
, CONT_INFORMATION2
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'HU'
, CONT_INFORMATION2
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'HU'
, CONT_INFORMATION1
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'HU'
, CONT_INFORMATION3
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'IN'
, CONT_INFORMATION13
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'IN'
, TO_DATE(CONT_INFORMATION14
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'IN'
, CONT_INFORMATION15
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'IN'
, CONT_INFORMATION17
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'JP'
, CONT_INFORMATION1
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'JP'
, FND_NUMBER.CANONICAL_TO_NUMBER(CONT_INFORMATION2)
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'JP'
, CONT_INFORMATION3
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'KR'
, CONT_INFORMATION1
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'KR'
, CONT_INFORMATION2
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'KR'
, CONT_INFORMATION8
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'KR'
, CONT_INFORMATION3
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'KR'
, CONT_INFORMATION7
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'KR'
, CONT_INFORMATION4
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'KR'
, CONT_INFORMATION15
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'KR'
, CONT_INFORMATION5
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'KR'
, CONT_INFORMATION9
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'KR'
, CONT_INFORMATION11
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'NO'
, CONT_INFORMATION1
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'NO'
, CONT_INFORMATION2
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'PL'
, CONT_INFORMATION1
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'PL'
, CONT_INFORMATION2
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'RU'
, CONT_INFORMATION1
, NULL))
, (DECODE (CONT_INFORMATION_CATEGORY
, 'DE_PQH'
, CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2 || '.' || CONT_INFORMATION3 || '.' || CONT_INFORMATION4 || '.' || CONT_INFORMATION5 || '.' || CONT_INFORMATION6
, 'ES'
, CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2
, 'FR'
, CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2
, 'HU'
, CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION2 || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION3
, 'IN'
, CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION13 || '.' || CONT_INFORMATION14 || '.' || CONT_INFORMATION15 || '.' || CONT_INFORMATION17
, 'JP'
, CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2 || '.' || CONT_INFORMATION3
, 'KR'
, CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2 || '.' || CONT_INFORMATION8 || '.' || CONT_INFORMATION3 || '.' || CONT_INFORMATION7 || '.' || CONT_INFORMATION4 || '.' || CONT_INFORMATION15 || '.' || CONT_INFORMATION5 || '.' || CONT_INFORMATION9 || '.' || CONT_INFORMATION11
, 'NO'
, CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2
, 'PL'
, CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1 || '.' || CONT_INFORMATION2
, 'RU'
, CONT_INFORMATION_CATEGORY || '.' || CONT_INFORMATION1
, NULL))
FROM PER_CONTACT_RELATIONSHIPS