VIEW: APPS.PQP_VEHICLE_REPOSITORY_F_DFV

Source

View Text - Preformatted

SELECT ROWID, VRE_INFORMATION_CATEGORY, (DECODE (VRE_INFORMATION_CATEGORY, 'DK', VRE_INFORMATION1, NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'DK', FND_NUMBER.CANONICAL_TO_NUMBER(VRE_INFORMATION2), NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'PL', VRE_INFORMATION1, NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'PL', VRE_INFORMATION2, NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'PL', VRE_INFORMATION3, NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'PL', TO_DATE(VRE_INFORMATION4, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'PL', TO_DATE(VRE_INFORMATION5, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'PL', VRE_INFORMATION6, NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'RU', VRE_INFORMATION1, NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'RU', VRE_INFORMATION2, NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'RU', VRE_INFORMATION3, NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'RU', VRE_INFORMATION4, NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'RU', VRE_INFORMATION5, NULL)), (DECODE (VRE_INFORMATION_CATEGORY, 'RU', VRE_INFORMATION6, NULL)),  
 (DECODE (VRE_INFORMATION_CATEGORY,  
      'DK', VRE_INFORMATION_CATEGORY || '.' || VRE_INFORMATION1 || '.' || VRE_INFORMATION2,  
      'PL', VRE_INFORMATION_CATEGORY || '.' || VRE_INFORMATION1 || '.' || VRE_INFORMATION2 || '.' || VRE_INFORMATION3 || '.' || VRE_INFORMATION4 || '.' || VRE_INFORMATION5 || '.' || VRE_INFORMATION6,  
      'RU', VRE_INFORMATION_CATEGORY || '.' || VRE_INFORMATION1 || '.' || VRE_INFORMATION2 || '.' || VRE_INFORMATION3 || '.' || VRE_INFORMATION4 || '.' || VRE_INFORMATION5 || '.' || VRE_INFORMATION6, NULL)) 
 FROM PQP_VEHICLE_REPOSITORY_F

View Text - HTML Formatted

SELECT ROWID
, VRE_INFORMATION_CATEGORY
, (DECODE (VRE_INFORMATION_CATEGORY
, 'DK'
, VRE_INFORMATION1
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'DK'
, FND_NUMBER.CANONICAL_TO_NUMBER(VRE_INFORMATION2)
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'PL'
, VRE_INFORMATION1
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'PL'
, VRE_INFORMATION2
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'PL'
, VRE_INFORMATION3
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'PL'
, TO_DATE(VRE_INFORMATION4
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'PL'
, TO_DATE(VRE_INFORMATION5
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'PL'
, VRE_INFORMATION6
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'RU'
, VRE_INFORMATION1
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'RU'
, VRE_INFORMATION2
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'RU'
, VRE_INFORMATION3
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'RU'
, VRE_INFORMATION4
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'RU'
, VRE_INFORMATION5
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'RU'
, VRE_INFORMATION6
, NULL))
, (DECODE (VRE_INFORMATION_CATEGORY
, 'DK'
, VRE_INFORMATION_CATEGORY || '.' || VRE_INFORMATION1 || '.' || VRE_INFORMATION2
, 'PL'
, VRE_INFORMATION_CATEGORY || '.' || VRE_INFORMATION1 || '.' || VRE_INFORMATION2 || '.' || VRE_INFORMATION3 || '.' || VRE_INFORMATION4 || '.' || VRE_INFORMATION5 || '.' || VRE_INFORMATION6
, 'RU'
, VRE_INFORMATION_CATEGORY || '.' || VRE_INFORMATION1 || '.' || VRE_INFORMATION2 || '.' || VRE_INFORMATION3 || '.' || VRE_INFORMATION4 || '.' || VRE_INFORMATION5 || '.' || VRE_INFORMATION6
, NULL))
FROM PQP_VEHICLE_REPOSITORY_F