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_PCS_V

Source

View Text - Preformatted


SELECT planning_cycle ,portfolio FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_pc_tbl','', 'DIMENSION planning_cycle FROM planning_cycle_d              WITH ATTRIBUTE portfolio from portfolio_pc_r'))

View Text - HTML Formatted

SELECT PLANNING_CYCLE
, PORTFOLIO
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PC_TBL'
, ''
, 'DIMENSION PLANNING_CYCLE
FROM PLANNING_CYCLE_D WITH ATTRIBUTE PORTFOLIO
FROM PORTFOLIO_PC_R'))