Hi Dave,
would you suggest or agree that the following code is where I need to add the "prj_obs_unit_flat?"
SELECT B.ID, B.NAME, (SELECT FULL_NAME FROM SRM_RESOURCES WHERE USER_ID = B.MANAGER_ID) MANAGER, A.LIFECYCLE_STATUS, (SELECT NAME FROM PRJ_OBS_UNITS WHERE ID = F.OBS_ID) OBS, DECODE(F.ATTRIB_NOT_COMPLETE,0,'Yes','No') PAGE_STATUS, SUBPAGE