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_PROJECT_SETS_V

Source

View Text - Preformatted


SELECT portfolio, init_project_set_id, appr_project_set_id FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_portfolio_pset_tbl', '', 'DIMENSION portfolio from portfolio_d 	     WITH ATTRIBUTE appr_project_set_id from PORTFOLIO_PROJECT_SET_APPROVED_R 	     ATTRIBUTE init_project_set_id from PORTFOLIO_PROJECT_SET_SUBMITTED_R'))

View Text - HTML Formatted

SELECT PORTFOLIO
, INIT_PROJECT_SET_ID
, APPR_PROJECT_SET_ID
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PORTFOLIO_PSET_TBL'
, ''
, 'DIMENSION PORTFOLIO
FROM PORTFOLIO_D WITH ATTRIBUTE APPR_PROJECT_SET_ID
FROM PORTFOLIO_PROJECT_SET_APPROVED_R ATTRIBUTE INIT_PROJECT_SET_ID
FROM PORTFOLIO_PROJECT_SET_SUBMITTED_R'))