VIEW: APPS.PQP_VEHICLE_ALLOCATIONS_F_DFV

Source

View Text - Preformatted

SELECT ROWID, VAL_INFORMATION_CATEGORY, (DECODE (VAL_INFORMATION_CATEGORY, 'GB', VAL_INFORMATION10, NULL)), (DECODE (VAL_INFORMATION_CATEGORY, 'PL', VAL_INFORMATION1, NULL)), (DECODE (VAL_INFORMATION_CATEGORY, 'PL', VAL_INFORMATION2, NULL)), (DECODE (VAL_INFORMATION_CATEGORY, 'PL', FND_NUMBER.CANONICAL_TO_NUMBER(VAL_INFORMATION3), NULL)), (DECODE (VAL_INFORMATION_CATEGORY, 'PL', VAL_INFORMATION4, NULL)),  
 (DECODE (VAL_INFORMATION_CATEGORY,  
      'GB', VAL_INFORMATION_CATEGORY || '.' || VAL_INFORMATION10,  
      'PL', VAL_INFORMATION_CATEGORY || '.' || VAL_INFORMATION1 || '.' || VAL_INFORMATION2 || '.' || VAL_INFORMATION3 || '.' || VAL_INFORMATION4, NULL)) 
 FROM PQP_VEHICLE_ALLOCATIONS_F

View Text - HTML Formatted

SELECT ROWID
, VAL_INFORMATION_CATEGORY
, (DECODE (VAL_INFORMATION_CATEGORY
, 'GB'
, VAL_INFORMATION10
, NULL))
, (DECODE (VAL_INFORMATION_CATEGORY
, 'PL'
, VAL_INFORMATION1
, NULL))
, (DECODE (VAL_INFORMATION_CATEGORY
, 'PL'
, VAL_INFORMATION2
, NULL))
, (DECODE (VAL_INFORMATION_CATEGORY
, 'PL'
, FND_NUMBER.CANONICAL_TO_NUMBER(VAL_INFORMATION3)
, NULL))
, (DECODE (VAL_INFORMATION_CATEGORY
, 'PL'
, VAL_INFORMATION4
, NULL))
, (DECODE (VAL_INFORMATION_CATEGORY
, 'GB'
, VAL_INFORMATION_CATEGORY || '.' || VAL_INFORMATION10
, 'PL'
, VAL_INFORMATION_CATEGORY || '.' || VAL_INFORMATION1 || '.' || VAL_INFORMATION2 || '.' || VAL_INFORMATION3 || '.' || VAL_INFORMATION4
, NULL))
FROM PQP_VEHICLE_ALLOCATIONS_F