find all the workorders currently in progress:
SELECT r_object_id, object_name, completion_status, mw.object_name, w.master_workorder_id
FROM dmc_rps_work_order w, dmc_rps_master_work_order mw
where completion_status = ‘PROCESSING’
and mw.r_object_id = w.master_workorder_id
SELECT r_object_id, object_name, completion_status
FROM dmc_rps_master_work_order mw
where completion_status = ‘PROCESSING’
The following work order (6523) is in progress:
dump:
select distinct operation_name from dmc_rps_master_work_order
select distinct operation_name, count(r_object_id)
from dmc_rps_master_work_order
group by operation_name
RETAINER_PROMOTION ……………………………..829
RETAINER_QUALIFICATION ………………………..343
APPLY_REMOVE_MARKUP ………………………….1
MASTER_WORK_ORDER_DESTRUCTION ….28
APPLY_REMOVE_RECORDS_POLICY ………….1
RETAINER_DISPOSITION ……………………………..1246
EVALUATE_RETENTION_DATE …………………….946