[Home] [Help]
View: PSBFV_ALLOCATION_PERCENTAGES
View Text
SELECT PE.NAME
, PAP.PERIOD_NUM
, DECODE(PAP.NUMBER_OF_PERIODS
, 12
, PAP.PERCENT)
, DECODE(PAP.NUMBER_OF_PERIODS
, 4
, PAP.PERCENT)
, DECODE(PAP.NUMBER_OF_PERIODS
, 2
, PAP.PERCENT)
, '_DF:PSB:PSB_ALLOCRULE_PERCENTS:PAP'
, PAP.ALLOCATION_RULE_PERCENT_ID
, PAP.ALLOCATION_RULE_ID
, PAP.LAST_UPDATE_DATE
, PAP.LAST_UPDATED_BY
, PAP.CREATED_BY
, PAP.CREATION_DATE
FROM PSB_ALLOCRULE_PERCENTS PAP
, PSB_ENTITY PE
WHERE PE.ENTITY_ID = PAP.ALLOCATION_RULE_ID
AND PE.ENTITY_TYPE = 'ALLOCRULE' WITH READ ONLY
Columns
Name |
ALLOCATION_RULE_NAME |
PERIOD_NUMBER |
MONTHLY |
QUARTERLY |
SEMI_ANNUAL |
"_DF" |
ALLOCATION_PERCENTAGE_ID |
ALLOCATION_RULE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATED_BY |
CREATION_DATE |