VIEW: APPS.PER_TIME_PERIODS_DFV

Source

View Text - Preformatted

SELECT ROWID, PRD_INFORMATION_CATEGORY, PRD_INFORMATION1, PRD_INFORMATION2, (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, 'FR', PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2, 'ZA', PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2 || '.' || PRD_INFORMATION3, NULL)) FROM PER_TIME_PERIODS

View Text - HTML Formatted

SELECT ROWID
, PRD_INFORMATION_CATEGORY
, PRD_INFORMATION1
, PRD_INFORMATION2
, (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
, 'FR'
, PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2
, 'ZA'
, PRD_INFORMATION_CATEGORY || '.' || PRD_INFORMATION1 || '.' || PRD_INFORMATION2 || '.' || PRD_INFORMATION3
, NULL))
FROM PER_TIME_PERIODS