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