SELECT /*+ gather_plan_statistics use_nl(wo wo_creator) leading(wo nc_user wo_creator) alab0315 */ nc_user.object_id, wo.object_id VALUE
FROM
nc_objects nc_user,
nc_objects wo,
nc_params_ix wo_creator,
nc_params wo_status,
nc_params wo_close_date
WHERE nc_user.object_id IN (111/*#$objectids$#*//*objectids*/)
  AND wo.object_type_id IN (9132801633113990794/*Miscellaneous Work Order*/, 9132801633113990791/*Operation & Maintenance Work Order*/)
  AND wo_creator.attr_id = 61 /*Created By*/
  AND wo_creator.object_id = wo.object_id
  AND wo_creator.ix_key = pkgutils.params_ix(nc_user.name)
  AND wo_close_date.object_id(+) = wo.object_id
  AND wo_close_date.attr_id(+) = 9132869866313027584/*Closure Date/Time*/
  AND wo_status.object_id = wo.object_id
  AND wo_status.attr_id = 9102964045013847425/*Status*/
  AND NOT
  (
    wo_status.list_value_id = 9102964045013847420/*New*/
    OR
    (
      wo_status.list_value_id = 9132606120313205086/*Closed*/
      AND trunc(wo_close_date.date_value) < (trunc(sysdate) - 3)
    )
  );