VIEW: APPS.FPA_AW_PCLASS_FUNDS_V

Source

View Text - Preformatted

SELECT class_code ,scenario ,planning_cycle ,funds_available ,funds_required ,funding_variance ,total_benefit ,sce_class_code_valid FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_proj_class_tbl','', 'DIMENSION class_code from class_code_d                                    DIMENSION scenario FROM scenario_d              WITH ATTRIBUTE planning_cycle FROM planning_cycle_scenario_r 	     MEASURE funds_available from scenario_class_code_funding_m 	     MEASURE funds_required from scenario_class_code_funds_req_m 	     MEASURE funding_variance from scenario_class_code_fund_var_m 	     MEASURE total_benefit from scenario_class_code_benefit_m 	     MEASURE sce_class_code_valid from scenario_class_code_m')) WHERE sce_class_code_valid = 1

View Text - HTML Formatted

SELECT CLASS_CODE
, SCENARIO
, PLANNING_CYCLE
, FUNDS_AVAILABLE
, FUNDS_REQUIRED
, FUNDING_VARIANCE
, TOTAL_BENEFIT
, SCE_CLASS_CODE_VALID
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PROJ_CLASS_TBL'
, ''
, 'DIMENSION CLASS_CODE
FROM CLASS_CODE_D DIMENSION SCENARIO
FROM SCENARIO_D WITH ATTRIBUTE PLANNING_CYCLE
FROM PLANNING_CYCLE_SCENARIO_R MEASURE FUNDS_AVAILABLE
FROM SCENARIO_CLASS_CODE_FUNDING_M MEASURE FUNDS_REQUIRED
FROM SCENARIO_CLASS_CODE_FUNDS_REQ_M MEASURE FUNDING_VARIANCE
FROM SCENARIO_CLASS_CODE_FUND_VAR_M MEASURE TOTAL_BENEFIT
FROM SCENARIO_CLASS_CODE_BENEFIT_M MEASURE SCE_CLASS_CODE_VALID
FROM SCENARIO_CLASS_CODE_M'))
WHERE SCE_CLASS_CODE_VALID = 1