VIEW: APPS.PQP_VEH_REPOS_EXTRA_INFO_DFV

Source

View Text - Preformatted

SELECT ROWID, VREI_INFORMATION_CATEGORY, (DECODE (VREI_INFORMATION_CATEGORY, 'PL_VEHICLE_ACCIDENT_INFO', TO_DATE(VREI_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), VREI_INFORMATION2, (DECODE (VREI_INFORMATION_CATEGORY, 'PL_VEHICLE_ACCIDENT_INFO', FND_NUMBER.CANONICAL_TO_NUMBER(VREI_INFORMATION3), NULL)), VREI_INFORMATION4, (DECODE (VREI_INFORMATION_CATEGORY, 'PL_VEHICLE_INSURANCE_INFO', TO_DATE(VREI_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), 'PL_VEHICLE_ADDITIONAL_INFO', TO_DATE(VREI_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), VREI_INFORMATION2, VREI_INFORMATION2, (DECODE (VREI_INFORMATION_CATEGORY, 'RU_VEHICLE_INSURANCE_INFO', VREI_INFORMATION4, 'PL_VEHICLE_INSURANCE_INFO', VREI_INFORMATION3, NULL)), (DECODE (VREI_INFORMATION_CATEGORY, 'RU_VEHICLE_INSURANCE_INFO', VREI_INFORMATION1, 'PL_VEHICLE_INSURANCE_INFO', VREI_INFORMATION4, NULL)), (DECODE (VREI_INFORMATION_CATEGORY, 'RU_VEHICLE_INSURANCE_INFO', TO_DATE(VREI_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (VREI_INFORMATION_CATEGORY, 'RU_VEHICLE_INSURANCE_INFO', TO_DATE(VREI_INFORMATION3, 'YYYY/MM/DD HH24:MI:SS'), NULL)), VREI_INFORMATION5, VREI_INFORMATION6, VREI_INFORMATION7,  
 (DECODE (VREI_INFORMATION_CATEGORY,  
      'PL_VEHICLE_ACCIDENT_INFO', VREI_INFORMATION_CATEGORY || '.' || VREI_INFORMATION1 || '.' || VREI_INFORMATION2 || '.' || VREI_INFORMATION3 || '.' || VREI_INFORMATION4,  
      'PL_VEHICLE_ADDITIONAL_INFO', VREI_INFORMATION_CATEGORY || '.' || VREI_INFORMATION1 || '.' || VREI_INFORMATION2,  
      'PL_VEHICLE_INSURANCE_INFO', VREI_INFORMATION_CATEGORY || '.' || VREI_INFORMATION1 || '.' || VREI_INFORMATION2 || '.' || VREI_INFORMATION3 || '.' || VREI_INFORMATION4,  
      'RU_VEHICLE_INSURANCE_INFO', VREI_INFORMATION_CATEGORY || '.' || VREI_INFORMATION1 || '.' || VREI_INFORMATION2 || '.' || VREI_INFORMATION3 || '.' || VREI_INFORMATION4 || '.' || VREI_INFORMATION5 || '.' || VREI_INFORMATION6 || '.' || VREI_INFORMATION7, NULL)) 
 FROM PQP_VEH_REPOS_EXTRA_INFO

View Text - HTML Formatted

SELECT ROWID
, VREI_INFORMATION_CATEGORY
, (DECODE (VREI_INFORMATION_CATEGORY
, 'PL_VEHICLE_ACCIDENT_INFO'
, TO_DATE(VREI_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, VREI_INFORMATION2
, (DECODE (VREI_INFORMATION_CATEGORY
, 'PL_VEHICLE_ACCIDENT_INFO'
, FND_NUMBER.CANONICAL_TO_NUMBER(VREI_INFORMATION3)
, NULL))
, VREI_INFORMATION4
, (DECODE (VREI_INFORMATION_CATEGORY
, 'PL_VEHICLE_INSURANCE_INFO'
, TO_DATE(VREI_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, 'PL_VEHICLE_ADDITIONAL_INFO'
, TO_DATE(VREI_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, VREI_INFORMATION2
, VREI_INFORMATION2
, (DECODE (VREI_INFORMATION_CATEGORY
, 'RU_VEHICLE_INSURANCE_INFO'
, VREI_INFORMATION4
, 'PL_VEHICLE_INSURANCE_INFO'
, VREI_INFORMATION3
, NULL))
, (DECODE (VREI_INFORMATION_CATEGORY
, 'RU_VEHICLE_INSURANCE_INFO'
, VREI_INFORMATION1
, 'PL_VEHICLE_INSURANCE_INFO'
, VREI_INFORMATION4
, NULL))
, (DECODE (VREI_INFORMATION_CATEGORY
, 'RU_VEHICLE_INSURANCE_INFO'
, TO_DATE(VREI_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (VREI_INFORMATION_CATEGORY
, 'RU_VEHICLE_INSURANCE_INFO'
, TO_DATE(VREI_INFORMATION3
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, VREI_INFORMATION5
, VREI_INFORMATION6
, VREI_INFORMATION7
, (DECODE (VREI_INFORMATION_CATEGORY
, 'PL_VEHICLE_ACCIDENT_INFO'
, VREI_INFORMATION_CATEGORY || '.' || VREI_INFORMATION1 || '.' || VREI_INFORMATION2 || '.' || VREI_INFORMATION3 || '.' || VREI_INFORMATION4
, 'PL_VEHICLE_ADDITIONAL_INFO'
, VREI_INFORMATION_CATEGORY || '.' || VREI_INFORMATION1 || '.' || VREI_INFORMATION2
, 'PL_VEHICLE_INSURANCE_INFO'
, VREI_INFORMATION_CATEGORY || '.' || VREI_INFORMATION1 || '.' || VREI_INFORMATION2 || '.' || VREI_INFORMATION3 || '.' || VREI_INFORMATION4
, 'RU_VEHICLE_INSURANCE_INFO'
, VREI_INFORMATION_CATEGORY || '.' || VREI_INFORMATION1 || '.' || VREI_INFORMATION2 || '.' || VREI_INFORMATION3 || '.' || VREI_INFORMATION4 || '.' || VREI_INFORMATION5 || '.' || VREI_INFORMATION6 || '.' || VREI_INFORMATION7
, NULL))
FROM PQP_VEH_REPOS_EXTRA_INFO