VIEW: APPS.FPA_AW_SCE_CONTEXT_V

Source

View Text - Preformatted

SELECT scenario ,planning_cycle ,pc_display_factor ,portfolio ,portfolio_organization ,portfolio_class_code ,funding_period_from ,funding_period_to ,discount_rate ,funds_required ,funds_available ,funding_Variance ,approved_Flag ,recommended_flag ,is_initial_scenario FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_scen_context_vo_tbl','lmt scenario_d to planning_cycle_scenario_r', 'DIMENSION scenario FROM scenario_d WITH ATTRIBUTE planning_cycle from planning_cycle_scenario_r MEASURE pc_display_factor FROM AW_EXPR factor_pc_r(planning_cycle_d planning_cycle_scenario_r) MEASURE portfolio FROM AW_EXPR portfolio_pc_r(planning_cycle_d planning_cycle_scenario_r) MEASURE portfolio_organization from AW_EXPR portfolio_organization_m(portfolio_d portfolio_pc_r(planning_cycle_d planning_cycle_scenario_r)) MEASURE portfolio_class_code from AW_EXPR portfolio_class_code_m(portfolio_d portfolio_pc_r(planning_cycle_d planning_cycle_scenario_r)) MEASURE funding_period_from FROM AW_EXPR pc_funding_period_from_m(planning_cycle_d planning_cycle_scenario_r) MEASURE funding_period_to from AW_EXPR pc_funding_period_to_m(planning_cycle_d planning_cycle_scenario_r) MEASURE discount_rate from scenario_discount_rate_m MEASURE funds_available from scenario_funding_m MEASURE funds_required from scenario_funds_req_m MEASURE funding_variance from scenario_fund_var_m  MEASURE approved_flag from scenario_approved_flag_m MEASURE recommended_flag from scenario_recommended_flag_m MEASURE is_initial_scenario FROM scenario_initial_m '))

View Text - HTML Formatted

SELECT SCENARIO
, PLANNING_CYCLE
, PC_DISPLAY_FACTOR
, PORTFOLIO
, PORTFOLIO_ORGANIZATION
, PORTFOLIO_CLASS_CODE
, FUNDING_PERIOD_FROM
, FUNDING_PERIOD_TO
, DISCOUNT_RATE
, FUNDS_REQUIRED
, FUNDS_AVAILABLE
, FUNDING_VARIANCE
, APPROVED_FLAG
, RECOMMENDED_FLAG
, IS_INITIAL_SCENARIO
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_SCEN_CONTEXT_VO_TBL'
, 'LMT SCENARIO_D TO PLANNING_CYCLE_SCENARIO_R'
, 'DIMENSION SCENARIO
FROM SCENARIO_D WITH ATTRIBUTE PLANNING_CYCLE
FROM PLANNING_CYCLE_SCENARIO_R MEASURE PC_DISPLAY_FACTOR
FROM AW_EXPR FACTOR_PC_R(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R) MEASURE PORTFOLIO
FROM AW_EXPR PORTFOLIO_PC_R(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R) MEASURE PORTFOLIO_ORGANIZATION
FROM AW_EXPR PORTFOLIO_ORGANIZATION_M(PORTFOLIO_D PORTFOLIO_PC_R(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R)) MEASURE PORTFOLIO_CLASS_CODE
FROM AW_EXPR PORTFOLIO_CLASS_CODE_M(PORTFOLIO_D PORTFOLIO_PC_R(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R)) MEASURE FUNDING_PERIOD_FROM
FROM AW_EXPR PC_FUNDING_PERIOD_FROM_M(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R) MEASURE FUNDING_PERIOD_TO
FROM AW_EXPR PC_FUNDING_PERIOD_TO_M(PLANNING_CYCLE_D PLANNING_CYCLE_SCENARIO_R) MEASURE DISCOUNT_RATE
FROM SCENARIO_DISCOUNT_RATE_M MEASURE FUNDS_AVAILABLE
FROM SCENARIO_FUNDING_M MEASURE FUNDS_REQUIRED
FROM SCENARIO_FUNDS_REQ_M MEASURE FUNDING_VARIANCE
FROM SCENARIO_FUND_VAR_M MEASURE APPROVED_FLAG
FROM SCENARIO_APPROVED_FLAG_M MEASURE RECOMMENDED_FLAG
FROM SCENARIO_RECOMMENDED_FLAG_M MEASURE IS_INITIAL_SCENARIO
FROM SCENARIO_INITIAL_M '))