VIEW: APPS.FPA_AW_PCLASS_FIN_METRICS_V

Source

View Text - Preformatted

SELECT class_code ,scenario ,funds_available ,funds_required ,funding_variance ,total_benefit ,net_present_value ,internal_rate_return ,return_on_inv ,payback_period ,sce_class_code_valid FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_proj_class_tbl', 'lmt scenario_d to scenario_d', 'DIMENSION scenario FROM scenario_d   	     DIMENSION class_code from class_code_d  	     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 net_present_value from scenario_class_code_npv_m  		 MEASURE internal_rate_return from scenario_class_code_irr_m  		 MEASURE return_on_inv  from scenario_class_code_roi_m  		 MEASURE payback_period from scenario_class_code_payback_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
, FUNDS_AVAILABLE
, FUNDS_REQUIRED
, FUNDING_VARIANCE
, TOTAL_BENEFIT
, NET_PRESENT_VALUE
, INTERNAL_RATE_RETURN
, RETURN_ON_INV
, PAYBACK_PERIOD
, SCE_CLASS_CODE_VALID
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PROJ_CLASS_TBL'
, 'LMT SCENARIO_D TO SCENARIO_D'
, 'DIMENSION SCENARIO
FROM SCENARIO_D DIMENSION CLASS_CODE
FROM CLASS_CODE_D 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 NET_PRESENT_VALUE
FROM SCENARIO_CLASS_CODE_NPV_M MEASURE INTERNAL_RATE_RETURN
FROM SCENARIO_CLASS_CODE_IRR_M MEASURE RETURN_ON_INV
FROM SCENARIO_CLASS_CODE_ROI_M MEASURE PAYBACK_PERIOD
FROM SCENARIO_CLASS_CODE_PAYBACK_M MEASURE SCE_CLASS_CODE_VALID
FROM SCENARIO_CLASS_CODE_M'))
WHERE SCE_CLASS_CODE_VALID = 1