[Home] [Help]
View: PSB_ALLOCRULE_PERCENTS_V
View Text
SELECT PAP.ALLOCATION_RULE_ID
, PAP.PERIOD_NUM
, SUM(DECODE(PAP.NUMBER_OF_PERIODS
, 12
, PAP.PERCENT))
, SUM(DECODE(PAP.NUMBER_OF_PERIODS
, 4
, PAP.PERCENT))
, SUM(DECODE(PAP.NUMBER_OF_PERIODS
, 2
, PAP.PERCENT))
FROM PSB_ALLOCRULE_PERCENTS PAP GROUP BY PAP.ALLOCATION_RULE_ID
, PAP.PERIOD_NUM
Columns
Name |
ALLOCATION_RULE_ID |
PERIOD_NUM |
MONTHLY |
QUARTERLY |
SEMI_ANNUAL |