Query Module 4 5.1 Name Description Category 4.1 + Query 5.1 + Query
1 Any Module   X ROW LIMIT <200 Row Limit <=200 Row Limit   WHERE  (crewid like 'MCB%1401' and historyflag = 'N' and istask = 'Y') and rownum <= 200
2 EQUIPMENT   X HAZZID Equip where HAZZARDID =? Hazzard   WHERE (eq9 like 'MEH%') and eqnum in (select eqnum from safetylexicon where hazardid='SCS-EVT')
3 EQUIPMENT   X REPLACE EQ PUR REPLACE EQ IF total cost is > purchase price Flagged   WHERE  (equipment.purchaseprice>1) and (equipment.totalcost>purchaseprice)
4 EQUIPMENT   X REPLACE EQ REPL REPLACE EQ if total cost is > replacement price Flagged   WHERE  (equipment.replacecost>1) and (equipment.totalcost>replacecost)
5 Labor Reporting   X Search by Crew Search By Crew Crew   WHERE  LABORCODE in (select LABORCODE from LABTRANS where ((CREWID like'%MMM%') and (LABORCODE = LABOR.LABORCODE)))
6 WorkOrder X   All YTD ALL Jobs YTD All jobs WHERE WORKORDER.REPORTDATE >= '2003-01-01-0.00.00' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'  
7 WorkOrder X   Not Planned YTD. All Reactive Jobs Not in PM, PD All jobs WHERE WORKORDER.REPORTDATE >= '2003-01-01-0.00.00' AND WORKORDER.WORKTYPE Not In ('PM','PD') AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'  
8 WorkOrder X   Planned YTD.. All Preventive All jobs WHERE WORKORDER.REPORTDATE >= '2003-01-01-0.00.00' AND WORKORDER.WORKTYPE In ('PM','PD') AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'  
9 WorkOrder   X BKLG fwd 3days Backlog look ahead 3 days Backlog   WHERE  (worktype not in ('OH','SO')) and (status not in ('COMP','MACLOSE','CAN') and upper(crewid) like 'MMM%' and historyflag = 'N' and targcompdate < trunc(sysdate +4) and targcompdate >= trunc(sysdate) and istask = 'N')
10 WorkOrder X   Comp between Date Completed BETWEEN ACTUAL FINISH DATE Completed WHERE WORKORDER. ACTFINISH BETWEEN '2003-08-13-0.00.00' AND '2003-08-13-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'  
11 WorkOrder X   Fin between Dates BETWEEN ACTUAL FINISH DATE Completed WHERE WORKORDER. ACTFINISH BETWEEN '2003-08-13-0.00.00' AND '2003-08-13-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'  
12 WorkOrder X   LABOR Closed WITHOUT labor between dates Completed WHERE WORKORDER.STATUS = 'CLOSE' AND WORKORDER.REPORTDATE BETWEEN '2004-01-01-0.00.00' AND '2004-09-07-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' AND WORKORDER.ACTLABHRS = 0  
13 WorkOrder X   LABOR. Comp WITHOUT labor Year Completed WHERE WORKORDER.STATUS = 'CLOSE' AND WORKORDER.STATUS = 'COMP' AND WORKORDER.ACTLABHRS = 0 AND WORKORDER.REPORTDATE > '2004-01-01-0.00.00' AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' AND WORKORDER.ACTLABHRS = 0  
14 WorkOrder X   OPEN OPEN !=COMP Completed WHERE WORKORDER.STATUS != 'COMP' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401' and (HISTORYFLAG = 'N')  
15 WorkOrder X   OPEN JOBS Total open Jobs including 'COMP' Completed WHERE WORKORDER.SUPERVISOR LIKE 'MMM%1401' and (HISTORYFLAG = 'N')  
16 WorkOrder   X Workorders created Workorders created by BEMSID all Find jobs   WHERE  wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby='M206755'))
17 WorkOrder   X PJ created by Planned jobs that has been created BEMSID Find jobs   Where (istask = 'N' and worktype like '%P%') and wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby in ('M485244','M398006')))
18 WorkOrder   X Created 48Hrs Created by BEMSID '48hrs' (Not PM's) Find jobs   WHERE  reportdate >=trunc(sysdate-2) and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M206755') and istask = 'N'
19 WorkOrder X X Created by Created by BEMSID 'TODAY' (Not PM's) Find jobs Where reportdate >=trunc(sysdate) and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M206755') WHERE  reportdate >=trunc(sysdate) and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M206755') and istask = 'N'
20 WorkOrder X X PC'S CREATED Worktype 'PC' created by  '773025' Find jobs Where workorder.worktype = 'PC' and workorder.reportdate between '2004-01-01-00.00.00' and '2004-12-31-23.59.59' and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M773025') Where (historyflag = 'N' and istask = 'N' and worktype like '%PC%') and wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby='M773025'))
21 WorkOrder   X APPR today Crew Aproved today on your Crew Find jobs   WHERE  (upper(crewid) like 'MCB%1401') and wonum in (select wonum from wostatus where status='APPR' and changedate >trunc(sysdate-0) and istask='N')
22 WorkOrder X X NEW JOBS New Jobs for today (SYSDATE) open or closed Find jobs WHERE WORKORDER.REPORTDATE >=trunc(sysdate) AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' WHERE  workorder.reportdate >=trunc(sysdate) and (upper(crewid) like 'MCB%1401') and (istask = 'N' )
23 WorkOrder X X NEW... Created by BEMSID ALL Find jobs Where wonum in (select wonum from wostatus where status='WAPPR' and changeby='M773025') WHERE wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby='M206755')) and (historyflag = 'N' and istask = 'N')
24 WorkOrder   X WAPPR  ALL Current WAPPR jobs in your crew Find jobs   WHERE  workorder.status = 'WAPPR' and (upper(crewid) like 'MCB%1401')
25 WorkOrder X X PC'S CREATED PC Worktype created by '773025' Find jobs Where workorder.worktype = 'PC' and workorder.reportdate between '2004-01-01-00.00.00' and '2004-12-31-23.59.59' and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M773025') Where (historyflag = 'N' and istask = 'N' and worktype like '%PC%') and wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby='M773025'))
26 WorkOrder   X WAPPR NEW New Jobs for today (SYSDATE) WAPPR Find jobs   WHERE WORKORDER.STATUS = 'WAPPR' AND WORKORDER.REPORTDATE >=trunc(sysdate) AND (upper(crewid) like 'MCB%1401') and istask = 'N'
27 WorkOrder X X NEW... Created by ID today Find jobs Where reportdate >=trunc(sysdate) and wonum in (select wonum from wostatus where status='WAPPR' and changeby='M773025') WHERE  workorder.reportdate >=trunc(sysdate) and wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby='M206755'))
28 WorkOrder X X Wappr Status Between Workorders Statused by BEMSID BetweenDates Find jobs WHERE  wonum in(select wonum from wostatus where status = 'WAPPR' and changedate <= TO_DATE ('2005-08-04' , 'YYYY-MM-DD') and changedate >= TO_DATE ('2005-08-02' , 'YYYY-MM-DD') and changeby in('M49288', 'M16171', 'M80165', 'M87231', 'M88926', 'M42165', 'M126741', 'M123346', 'M125223', 'M21956')) WHERE  wonum in(select wonum from wostatus where status = 'WAPPR' and changedate <= TO_DATE ('2005-08-04' , 'YYYY-MM-DD') and changedate >= TO_DATE ('2005-08-02' , 'YYYY-MM-DD') and changeby in('M49288', 'M16171', 'M80165', 'M87231', 'M88926', 'M42165', 'M126741', 'M123346', 'M125223', 'M21956'))
29 WorkOrder X   CLOSED Closed Today (SYSDATE) Find jobs WHERE WORKORDER. ACTFINISH >=trunc(sysdate) AND WORKORDER.SUPERVISOR LIKE 'MCB%1401'  
30 WorkOrder X   MaintGrp Search By Maintain Grp Find jobs WHERE WORKORDER.WOEQ9 = 'MMMXXXXX' and (HISTORYFLAG = 'N')  
31 WorkOrder X   NEW. BETWEEN REPORT DATE Find jobs WHERE WORKORDER.REPORTDATE BETWEEN '2003-08-13-00.00.00' AND '2003-08-13-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401'  
32 WorkOrder X X NEW PMS New PMs for today (SYSDATE) Find PM's WHERE WORKORDER.REPORTDATE >=trunc(sysdate) AND WORKORDER.WORKTYPE in ('PM','PD') AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' WHERE  workorder.reportdate >=trunc(sysdate) and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
33 WorkOrder   X NEW UNASS PM NEW Unassigned PM's Released today Find PM's   WHERE  leadcraft is null and workorder.reportdate >=trunc(sysdate) and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
34 WorkOrder   X NEW UNSC PMs NEW UnScheduled  PM's Released today Find PM's   WHERE  schedstart is null and workorder.reportdate >=trunc(sysdate) and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
35 WorkOrder   X UNASSIGN PM All Unassigned PM's Find PM's   WHERE  leadcraft is null and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
36 WorkOrder   X UNSCHED PM All UN-Scheduled PM's Find PM's   WHERE  schedstart is null and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
37 WorkOrder X   NEW PM'S New PM's BETWEEN Report Dates Find PM's WHERE WORKORDER.REPORTDATE BETWEEN '2004-01-29-00.00.00' AND '2004-01-29-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MMM%1401' and WORKORDER.WORKTYPE in ('PM','PD')  
38 WorkOrder X   ALL JOBS. MAINTENANCE HISTORY History WHERE WORKORDER.SUPERVISOR LIKE 'M%'  
39 WorkOrder X   ALL JOBS.. MAINTENANCE HISTORY - year History WHERE WORKORDER. ACTFINISH >= '2003-01-01-0.00.00' AND WORKORDER.SUPERVISOR LIKE 'M%'  
40 WorkOrder X X PlansTab Plans tab -LaborCode search by crew Labor code WHERE WORKORDER.REPORTDATE BETWEEN '2004-03-31-00.00.00' AND '2005-03-31-23.59.59' AND WORKORDER.SUPERVISOR LIKE 'MMMC1401' and wonum in(select wonum from WPlabor where laborcode ='CBTR') and WORKORDER.WORKTYPE = 'PM'  WHERE  (status not like '%C%O%')and   workorder.crewid like 'MSGS1801' and wonum in(select wonum from wplabor where laborcode ='ELEV') and workorder.worktype in ('RD','PJ','PM') and istask='N'
41 WorkOrder   X UNASSIGN PM All UNASSIGNED PM'S for Crew Leadcraft   WHERE  leadcraft IS NULL and workorder.worktype in ('PM','PD') and (upper(crewid) like 'MCB%1401') and (historyflag = 'N' and istask = 'N')
42 WorkOrder X   NULL Bad Data Incomplete fields (All Jobs) Null WHERE (SUPERVISOR Like 'MCB%1401') AND ((STATUS Not In ('COMP','CLOSE','CAN')) AND (WOPRIORITY Is Null) OR (LEADCRAFT IS NULL) OR (TARGSTARTDATE Is Null) OR (TARGCOMPDATE Is Null) OR (SCHEDSTART Is Null) OR (SCHEDFINISH Is Null))  
43 WorkOrder X   NULL. Bad Data Incomplete fields Null WHERE (SUPERVISOR Like 'MCB%1401') AND WORKTYPE NOT IN ('OH','SO') AND ((STATUS Not In ('COMP','CLOSE','CAN')) AND (WOPRIORITY Is Null) OR (TARGSTARTDATE Is Null) OR (TARGCOMPDATE Is Null) OR (SCHEDSTART Is Null) OR (SCHEDFINISH Is Null))  
44 WorkOrder X   PROBLEM CODE PROBLEM CODE IS NOT NULL Null WHERE WORKORDER.PROBLEMCODE IS NOT NULL AND WORKORDER.SUPERVISOR LIKE 'MM%'  
45 WorkOrder X X MR COUNT MR- Count WorkOrders with MR's Reqs Where WORKORDER.SUPERVISOR Like 'MCB%1401' and wonum in (select wonum from mr where MR.MRNUM Is Not Null) Where upper(crewid) like 'MCB%1401' and wonum in (select wonum from mr where MR.MRNUM Is Not Null)
46 WorkOrder   X NULL S. DATES No Schedule Dates Schedule date   WHERE  (upper(crewid) like 'MCB%1401' and historyflag = 'N' and schedstart is null and istask = 'N' and worktype not like '%O%')
47 WorkOrder   X NULL S. DATES No Schedule Dates Excludes OH, SO and Excludes status of comp, close, Maclose Schedule date   WHERE  ((status not like '%C%O%' and crewid like 'MCB%1401') and historyflag = 'N' and schedstart is null and istask = 'N' and worktype not like '%O%')
48 WorkOrder X X BACKLOG All All Open Backlog >0 days old Target date WHERE WORKORDER.TARGCOMPDATE < trunc(sysdate) AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' and (HISTORYFLAG = 'N') WHERE  (worktype not in ('OH','SO')) and (status not in ('COMP','MACLOSE','CAN') and upper(crewid) like 'MCB%1401' and historyflag = 'N' and targcompdate < trunc(sysdate-0) and istask = 'N')
49 WorkOrder X X BACKLOG 14D Backlog >=14 Days Old Target date WHERE WORKORDER.STATUS != 'COMP' AND WORKORDER.TARGCOMPDATE < trunc(sysdate-13) AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' AND WORKORDER.WORKTYPE not in ('OH', 'SO') and (HISTORYFLAG = 'N') WHERE  (status != 'COMP' and upper(crewid) like 'MEHE1002%' and historyflag = 'N' and targcompdate < trunc(sysdate-13) and istask = 'N')
50 WorkOrder   X BKLG 4Cast 7D Backlog +7days look ahead Target date   WHERE  (worktype not in ('OH','SO')) and (status not in ('COMP','MACLOSE','CAN') and upper(crewid) like 'MCB%' and historyflag = 'N' and targcompdate < trunc(sysdate +7) and targcompdate >= trunc(sysdate) and istask = 'N')
51 WorkOrder   X Created by PJ Planned jobs that Individuals has created Types Created   Where (istask = 'N' and worktype like '%P%') and wonum in (select wonum from wostatus where (status like '%WAPPR%') and (changeby in ('M485244','M398006')))
52 WorkOrder X X COMP- NO VAR COMPed jobs NO variance Completed WHERE WORKORDER.STATUS = 'COMP' AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' AND WORKORDER.WO5 is null and (HISTORYFLAG = 'N') WHERE  (workorder.status = 'COMP' and upper(crewid) like 'MCB%1401') and workorder.wo5 is null and (historyflag = 'N' and istask = 'N')
53 WorkOrder X X COMP Var COMPed jobs WITH a variance Completed WHERE WORKORDER.STATUS = 'COMP' AND WORKORDER.SUPERVISOR LIKE 'MCB%1401' AND WORKORDER.WO5 is not null and (HISTORYFLAG = 'N') and (HISTORYFLAG = 'N') WHERE  (workorder.status = 'COMP' and upper(crewid) like 'MCB%1401') and workorder.wo5 is not null and (historyflag = 'N')