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_PORTF_HEADERS_V

Source

View Text - Preformatted


SELECT portfolio, owner, portfolio_organization, portfolio_class_code FROM table ( olap_table (fpa_utilities_pvt.aw_space_name || ' duration query', 'fpa_portf_headers_tbl','', 'DIMENSION portfolio from portfolio_d              WITH ATTRIBUTE owner from owner_portfolio_r              MEASURE portfolio_organization from portfolio_organization_m      	     measure portfolio_class_code from portfolio_class_code_m'))

View Text - HTML Formatted

SELECT PORTFOLIO
, OWNER
, PORTFOLIO_ORGANIZATION
, PORTFOLIO_CLASS_CODE
FROM TABLE ( OLAP_TABLE (FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PORTF_HEADERS_TBL'
, ''
, 'DIMENSION PORTFOLIO
FROM PORTFOLIO_D WITH ATTRIBUTE OWNER
FROM OWNER_PORTFOLIO_R MEASURE PORTFOLIO_ORGANIZATION
FROM PORTFOLIO_ORGANIZATION_M MEASURE PORTFOLIO_CLASS_CODE
FROM PORTFOLIO_CLASS_CODE_M'))