VIEW: APPS.OTA_TRAINING_PLAN_COSTS1_DFV

Source

View Text - Preformatted

SELECT ROWID, INFORMATION_CATEGORY, (DECODE (INFORMATION_CATEGORY, 'FR_FR_VAE', TP_COST_INFORMATION1, 'FR_FR_SKILLS_ASSESSMENT', TP_COST_INFORMATION1, 'FR_FR_ACTUAL_HOURS', TP_COST_INFORMATION1, NULL)), TP_COST_INFORMATION2, TP_COST_INFORMATION3, (DECODE (INFORMATION_CATEGORY, 'FR_FR_VAE', FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION4), 'FR_FR_SKILLS_ASSESSMENT', FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION4), 'FR_FR_ACTUAL_HOURS', FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION4), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_DEDUCT_EXT_TRN_PLAN_VAE', FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION1), 'FR_FR_DEDUCT_EXT_TRN_PLAN_SA', FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION1), NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_VAE', TP_COST_INFORMATION2, 'FR_FR_SKILLS_ASSESSMENT', TP_COST_INFORMATION2, NULL)), (DECODE (INFORMATION_CATEGORY, 'FR_FR_VAE', FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION3), 'FR_FR_SKILLS_ASSESSMENT', FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION3), NULL)),  
 (DECODE (INFORMATION_CATEGORY,  
      'FR_FR_ACTUAL_HOURS', INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1 || '.' || TP_COST_INFORMATION2 || '.' || TP_COST_INFORMATION3 || '.' || TP_COST_INFORMATION4,  
      'FR_FR_DEDUCT_EXT_TRN_PLAN_SA', INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1,  
      'FR_FR_DEDUCT_EXT_TRN_PLAN_VAE', INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1,  
      'FR_FR_SKILLS_ASSESSMENT', INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1 || '.' || TP_COST_INFORMATION2 || '.' || TP_COST_INFORMATION3 || '.' || TP_COST_INFORMATION4,  
      'FR_FR_VAE', INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1 || '.' || TP_COST_INFORMATION2 || '.' || TP_COST_INFORMATION3 || '.' || TP_COST_INFORMATION4, NULL)) 
 FROM OTA_TRAINING_PLAN_COSTS

View Text - HTML Formatted

SELECT ROWID
, INFORMATION_CATEGORY
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_VAE'
, TP_COST_INFORMATION1
, 'FR_FR_SKILLS_ASSESSMENT'
, TP_COST_INFORMATION1
, 'FR_FR_ACTUAL_HOURS'
, TP_COST_INFORMATION1
, NULL))
, TP_COST_INFORMATION2
, TP_COST_INFORMATION3
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_VAE'
, FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION4)
, 'FR_FR_SKILLS_ASSESSMENT'
, FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION4)
, 'FR_FR_ACTUAL_HOURS'
, FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION4)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_DEDUCT_EXT_TRN_PLAN_VAE'
, FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION1)
, 'FR_FR_DEDUCT_EXT_TRN_PLAN_SA'
, FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION1)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_VAE'
, TP_COST_INFORMATION2
, 'FR_FR_SKILLS_ASSESSMENT'
, TP_COST_INFORMATION2
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_VAE'
, FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION3)
, 'FR_FR_SKILLS_ASSESSMENT'
, FND_NUMBER.CANONICAL_TO_NUMBER(TP_COST_INFORMATION3)
, NULL))
, (DECODE (INFORMATION_CATEGORY
, 'FR_FR_ACTUAL_HOURS'
, INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1 || '.' || TP_COST_INFORMATION2 || '.' || TP_COST_INFORMATION3 || '.' || TP_COST_INFORMATION4
, 'FR_FR_DEDUCT_EXT_TRN_PLAN_SA'
, INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1
, 'FR_FR_DEDUCT_EXT_TRN_PLAN_VAE'
, INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1
, 'FR_FR_SKILLS_ASSESSMENT'
, INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1 || '.' || TP_COST_INFORMATION2 || '.' || TP_COST_INFORMATION3 || '.' || TP_COST_INFORMATION4
, 'FR_FR_VAE'
, INFORMATION_CATEGORY || '.' || TP_COST_INFORMATION1 || '.' || TP_COST_INFORMATION2 || '.' || TP_COST_INFORMATION3 || '.' || TP_COST_INFORMATION4
, NULL))
FROM OTA_TRAINING_PLAN_COSTS