VIEW: APPS.PER_TIME_PERIODS1_DFV

Source

View Text - Preformatted

SELECT ROWID, PRD_INFORMATION_CATEGORY, (DECODE (PRD_INFORMATION_CATEGORY, 'DK', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION1), NULL)), (DECODE (PRD_INFORMATION_CATEGORY, 'FI', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION1), NULL)), (DECODE (PRD_INFORMATION_CATEGORY, 'FI', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION2), NULL)), (DECODE (PRD_INFORMATION_CATEGORY, 'FI', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION3), NULL)), (DECODE (PRD_INFORMATION_CATEGORY, 'FI', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION4), NULL)), (DECODE (PRD_INFORMATION_CATEGORY, 'FI', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION5), NULL)), PRD_INFORMATION1, PRD_INFORMATION2, PRD_INFORMATION1, PRD_INFORMATION1, PRD_INFORMATION2, PRD_INFORMATION1, PRD_INFORMATION2, (DECODE (PRD_INFORMATION_CATEGORY, 'SE', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION3), NULL)), PRD_INFORMATION4, PRD_INFORMATION6, PRD_INFORMATION7, (DECODE (PRD_INFORMATION_CATEGORY, 'SE', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION8), NULL)), PRD_INFORMATION9, (DECODE (PRD_INFORMATION_CATEGORY, 'ZA', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION1), NULL)), (DECODE (PRD_INFORMATION_CATEGORY, 'ZA', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION2), NULL)), (DECODE (PRD_INFORMATION_CATEGORY, 'ZA', FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION3), NULL)),  
 (DECODE (PRD_INFORMATION_CATEGORY,  
      'DK', PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1,  
      'FI', PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2 || '.' || PRD_INFORMATION3 || '.' || PRD_INFORMATION4 || '.' || PRD_INFORMATION5,  
      'FR', PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2,  
      'GB', PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1,  
      'NO', PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2,  
      'SE', PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2 || '.' || PRD_INFORMATION3 || '.' || PRD_INFORMATION4 || '.' || PRD_INFORMATION6 || '.' || PRD_INFORMATION7 || '.' || PRD_INFORMATION8 || '.' || PRD_INFORMATION9,  
      'ZA', PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2 || '.' || PRD_INFORMATION3, NULL)) 
 FROM PER_TIME_PERIODS

View Text - HTML Formatted

SELECT ROWID
, PRD_INFORMATION_CATEGORY
, (DECODE (PRD_INFORMATION_CATEGORY
, 'DK'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION1)
, NULL))
, (DECODE (PRD_INFORMATION_CATEGORY
, 'FI'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION1)
, NULL))
, (DECODE (PRD_INFORMATION_CATEGORY
, 'FI'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION2)
, NULL))
, (DECODE (PRD_INFORMATION_CATEGORY
, 'FI'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION3)
, NULL))
, (DECODE (PRD_INFORMATION_CATEGORY
, 'FI'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION4)
, NULL))
, (DECODE (PRD_INFORMATION_CATEGORY
, 'FI'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION5)
, NULL))
, PRD_INFORMATION1
, PRD_INFORMATION2
, PRD_INFORMATION1
, PRD_INFORMATION1
, PRD_INFORMATION2
, PRD_INFORMATION1
, PRD_INFORMATION2
, (DECODE (PRD_INFORMATION_CATEGORY
, 'SE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION3)
, NULL))
, PRD_INFORMATION4
, PRD_INFORMATION6
, PRD_INFORMATION7
, (DECODE (PRD_INFORMATION_CATEGORY
, 'SE'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION8)
, NULL))
, PRD_INFORMATION9
, (DECODE (PRD_INFORMATION_CATEGORY
, 'ZA'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION1)
, NULL))
, (DECODE (PRD_INFORMATION_CATEGORY
, 'ZA'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION2)
, NULL))
, (DECODE (PRD_INFORMATION_CATEGORY
, 'ZA'
, FND_NUMBER.CANONICAL_TO_NUMBER(PRD_INFORMATION3)
, NULL))
, (DECODE (PRD_INFORMATION_CATEGORY
, 'DK'
, PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1
, 'FI'
, PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2 || '.' || PRD_INFORMATION3 || '.' || PRD_INFORMATION4 || '.' || PRD_INFORMATION5
, 'FR'
, PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2
, 'GB'
, PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1
, 'NO'
, PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2
, 'SE'
, PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2 || '.' || PRD_INFORMATION3 || '.' || PRD_INFORMATION4 || '.' || PRD_INFORMATION6 || '.' || PRD_INFORMATION7 || '.' || PRD_INFORMATION8 || '.' || PRD_INFORMATION9
, 'ZA'
, PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2 || '.' || PRD_INFORMATION3
, NULL))
FROM PER_TIME_PERIODS