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