VIEW: APPS.FPA_AW_PC_DISC_FUNDS_V

Source

View Text - Preformatted

SELECT planning_cycle ,pc_discount_rate ,pc_funding ,pc_display_factor from table ( olap_table(fpa_utilities_pvt.aw_space_name || ' duration query','fpa_pc_discount_tbl','', 'DIMENSION planning_cycle from planning_cycle_d                          WITH ATTRIBUTE pc_display_factor from factor_pc_r                          MEASURE pc_discount_rate from pc_discount_rate_m                          MEASURE pc_funding from pc_funding_m'))

View Text - HTML Formatted

SELECT PLANNING_CYCLE
, PC_DISCOUNT_RATE
, PC_FUNDING
, PC_DISPLAY_FACTOR
FROM TABLE ( OLAP_TABLE(FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PC_DISCOUNT_TBL'
, ''
, 'DIMENSION PLANNING_CYCLE
FROM PLANNING_CYCLE_D WITH ATTRIBUTE PC_DISPLAY_FACTOR
FROM FACTOR_PC_R MEASURE PC_DISCOUNT_RATE
FROM PC_DISCOUNT_RATE_M MEASURE PC_FUNDING
FROM PC_FUNDING_M'))