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_SCES_V

Source

View Text - Preformatted


SELECT scenario ,planning_cycle FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_scenario_tbl','', 'DIMENSION scenario FROM scenario_d                                      WITH ATTRIBUTE planning_cycle from planning_cycle_scenario_r'))

View Text - HTML Formatted

SELECT SCENARIO
, PLANNING_CYCLE
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_SCENARIO_TBL'
, ''
, 'DIMENSION SCENARIO
FROM SCENARIO_D WITH ATTRIBUTE PLANNING_CYCLE
FROM PLANNING_CYCLE_SCENARIO_R'))