eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.FPA_AW_PC_FINANCIAL_TARGETS_V

Source

View Text - Preformatted


SELECT planning_cycle , financial_metrics, financial_target_from , financial_target_to FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_pc_fin_targets_tbl','', 'DIMENSION planning_cycle from planning_cycle_d              DIMENSION financial_metrics from FINANCIAL_METRICS_D              measure financial_target_from from pc_fintargets_range_from_m  	     measure financial_target_to from pc_fintargets_range_to_m'))

View Text - HTML Formatted

SELECT PLANNING_CYCLE
, FINANCIAL_METRICS
, FINANCIAL_TARGET_FROM
, FINANCIAL_TARGET_TO
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PC_FIN_TARGETS_TBL'
, ''
, 'DIMENSION PLANNING_CYCLE
FROM PLANNING_CYCLE_D DIMENSION FINANCIAL_METRICS
FROM FINANCIAL_METRICS_D MEASURE FINANCIAL_TARGET_FROM
FROM PC_FINTARGETS_RANGE_FROM_M MEASURE FINANCIAL_TARGET_TO
FROM PC_FINTARGETS_RANGE_TO_M'))