AnsweredAssumed Answered

urgent:  Need to incorporate the Collaboration Managers in Query

Question asked by mscann on Mar 4, 2013
Latest reply on Mar 4, 2013 by mscann
All,

I need to list all of the Collaboration Managers for all of my Projects that have documents attached. I believe that the information is in the CLB_PROJECT_PARTICIPANTS_V View....but I need help in incorporating it into my Query.

This is my Query:

select INV.NAME INV_PROJECT_NAME,
INV.CODE PROJECT_ID,
usr.first_name||' '||usr.last_name "PROJECT MANAGER",
nbi.path "FUNCTIONAL OBS",
INV.DESCRIPTION "PROJECT DESC",
INV.IS_ACTIVE "IS ACTIVE",
INV.SCHEDULE_START "START DATE",
INV.SCHEDULE_FINISH "FINISH DATE",
from INV_INVESTMENTS INV,
cmn_sec_users usr,
prj_obs_associations prj,
nbi_dim_obs nbi
where inv.manager_id = usr.id and
inv.id = prj.record_id and
prj.unit_id = nbi.obs_unit_id and
nbi.obs_type_id = ********* and
inv.id in
(select distinct inv.id
FROM CLB_DMS_FILES FIL
left JOIN CLB_DMS_FOLDERS FLD ON FIL.PARENT_FOLDER_ID = FLD.ID
left JOIN INV_INVESTMENTS INV ON niku.ZZ_GET_PROJECT_DOCUMENT(fil.ID) = INV.ID
left join cmn_sec_users usr on inv.manager_id = usr.id
left join prj_obs_associations prj on inv.id = prj.record_id
left join nbi_dim_obs nbi on prj.unit_id = nbi.obs_unit_id and nbi.obs_type_id = 5000009
where inv.name is not null);

Can any of you help with the Sql that will get this information? Thanks!

Outcomes