VIEW: APPS.FPA_AW_INV_CRITERIA_V

Source

View Text - Preformatted

SELECT strategic_obj ,strategic_obj_parent from table ( olap_table(fpa_utilities_pvt.aw_space_name || ' duration query','fpa_inv_criteria_tbl','', 'DIMENSION strategic_obj from strategic_obj_d                                         WITH HIERARCHY strategic_obj_parent from strategic_obj_h'))

View Text - HTML Formatted

SELECT STRATEGIC_OBJ
, STRATEGIC_OBJ_PARENT
FROM TABLE ( OLAP_TABLE(FPA_UTILITIES_PVT.AW_SPACE_NAME || ' DURATION QUERY'
, 'FPA_INV_CRITERIA_TBL'
, ''
, 'DIMENSION STRATEGIC_OBJ
FROM STRATEGIC_OBJ_D WITH HIERARCHY STRATEGIC_OBJ_PARENT
FROM STRATEGIC_OBJ_H'))