Query	Module	4	5.1	Name	Description	Category	4.1 + Query	5.1 + Query
1	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 'CREW02%' and historyflag = 'N' and targcompdate < trunc(sysdate +4) and targcompdate >= trunc(sysdate) and istask = 'N')
2	WorkOrder	X	X	BACKLOG All	All Open Backlog >0 days old	Target date	WHERE WORKORDER.TARGCOMPDATE < trunc(sysdate) AND WORKORDER.SUPERVISOR LIKE 'TEAM03' and (HISTORYFLAG = 'N')	WHERE  (worktype not in ('OH','SO')) and (status not in ('COMP','MACLOSE','CAN') and upper(crewid) like 'TEAM03' and historyflag = 'N' and targcompdate < trunc(sysdate-0) and istask = 'N')
3	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 'TEAM022' AND WORKORDER.WORKTYPE not in ('OH', 'SO') and (HISTORYFLAG = 'N')	WHERE  (status != 'COMP' and upper(crewid) like 'TEAM022%' and historyflag = 'N' and targcompdate < trunc(sysdate-13) and istask = 'N')
4	WorkOrder		X	BKLG 4Cast 7D	Forecasting backlog	Target date		WHERE  (worktype not in ('OH','SO')) and (status not in ('COMP','MACLOSE','CAN') and upper(crewid) like 'TEAM01%' and historyflag = 'N' and (targcompdate < trunc(sysdate +7) or targcompdate is null) and istask = 'N')