— attempt to id non-reporters
–find full list of resources
select wr.res_name
from MSP_WEB_RESOURCES WR,MSP_TEXT_FIELDS TXTFLD, MSP_CONVERSIONS CONV
where WR.RES_EUID = TXTFLD.TEXT_REF_UID
and TXTFLD.TEXT_FIELD_ID = CONV.CONV_VALUE
and TXTFLD.text_category = 1
and proj_id = 1
and conv_string = ‘Resource Group’
and wr.RES_NAME not in
( — list of resources who have pending task updates.
select distinct R.RES_NAME
from MSP_WEB_ASSIGNMENTS A, MSP_WEB_PROJECTS P, MSP_WEB_RESOURCES R
where A.WASSN_ACTUALS_PENDING =1 — flag to indicate task is pending manager approval
and A.wproj_id = P.WPROJ_ID
AND R.WRES_ID = A.WRES_ID
)
order by res_name