VIEW: APPS.PQP_VEH_ALLOC_EXTRA_INFO_DFV

Source

View Text - Preformatted

SELECT ROWID, VAEI_INFORMATION_CATEGORY, (DECODE (VAEI_INFORMATION_CATEGORY, 'PQP_GB_DAYS_UNAVAILABLE', TO_DATE(VAEI_INFORMATION1, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (VAEI_INFORMATION_CATEGORY, 'PQP_GB_DAYS_UNAVAILABLE', TO_DATE(VAEI_INFORMATION2, 'YYYY/MM/DD HH24:MI:SS'), NULL)), (DECODE (VAEI_INFORMATION_CATEGORY, 'PQP_GB_DAYS_UNAVAILABLE', FND_NUMBER.CANONICAL_TO_NUMBER(VAEI_INFORMATION3), NULL)),  
 (DECODE (VAEI_INFORMATION_CATEGORY,  
      'PQP_GB_DAYS_UNAVAILABLE', VAEI_INFORMATION_CATEGORY || '.' || VAEI_INFORMATION1 || '.' || VAEI_INFORMATION2 || '.' || VAEI_INFORMATION3, NULL)) 
 FROM PQP_VEH_ALLOC_EXTRA_INFO

View Text - HTML Formatted

SELECT ROWID
, VAEI_INFORMATION_CATEGORY
, (DECODE (VAEI_INFORMATION_CATEGORY
, 'PQP_GB_DAYS_UNAVAILABLE'
, TO_DATE(VAEI_INFORMATION1
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (VAEI_INFORMATION_CATEGORY
, 'PQP_GB_DAYS_UNAVAILABLE'
, TO_DATE(VAEI_INFORMATION2
, 'YYYY/MM/DD HH24:MI:SS')
, NULL))
, (DECODE (VAEI_INFORMATION_CATEGORY
, 'PQP_GB_DAYS_UNAVAILABLE'
, FND_NUMBER.CANONICAL_TO_NUMBER(VAEI_INFORMATION3)
, NULL))
, (DECODE (VAEI_INFORMATION_CATEGORY
, 'PQP_GB_DAYS_UNAVAILABLE'
, VAEI_INFORMATION_CATEGORY || '.' || VAEI_INFORMATION1 || '.' || VAEI_INFORMATION2 || '.' || VAEI_INFORMATION3
, NULL))
FROM PQP_VEH_ALLOC_EXTRA_INFO