VIEW: APPS.FPA_AW_PROJS_V

Source

View Text - Preformatted

SELECT project ,class_code ,portfolio ,planning_cycle from table (olap_table(fpa_utilities_pvt.aw_space_name || ' duration query','fpa_proj_tbl','', 'DIMENSION project from project_d                          WITH ATTRIBUTE class_code from class_code_project_r                          ATTRIBUTE portfolio from portfolio_project_r                          ATTRIBUTE planning_Cycle from pc_project_r'))

View Text - HTML Formatted

SELECT PROJECT
, CLASS_CODE
, PORTFOLIO
, PLANNING_CYCLE
FROM TABLE (OLAP_TABLE(FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_PROJ_TBL'
, ''
, 'DIMENSION PROJECT
FROM PROJECT_D WITH ATTRIBUTE CLASS_CODE
FROM CLASS_CODE_PROJECT_R ATTRIBUTE PORTFOLIO
FROM PORTFOLIO_PROJECT_R ATTRIBUTE PLANNING_CYCLE
FROM PC_PROJECT_R'))