Advertisement
Advertisement
| 07.18.2008 at 08:16AM PDT, ID: 23577110 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: |
PARAMETERS ManID Short; SELECT a.TSK_ID, a.PREF, a.SFX, b.LVL, a.SD_NO, a.TITLE, a.RCVD_DT AS Received, b.DUE_DT AS Scheduled, b.EST_CST, a.ACTL_CST, a.PCTCOMPLETE, a.SCHEDULECODE, a.COSTCODE, a.TECHCODE, a.NOTE_1 AS [report comments], e.full_nm AS Manager, c2.Engineer, c3.ALCOPR, c4.GovtEngineer, a.ACTIVE_IND, a.STAT_ID FROM ESIS_TSK AS a, esis_rev AS b, rptqryActiveESTEngineers AS c2, rptqryActiveESTALCOPRs AS c3, rptqryActiveESTGovtEngineers AS c4, esis_tsk_asgn AS d, esis_empl AS e WHERE ( ( (a.TSK_ID)=[c2].[tsk_id] And (a.TSK_ID)=[c3].[tsk_id] And (a.TSK_ID)=[c4].[tsk_id]) AND ((b.LVL)=(select max(lvl) from esis_rev d where a.tsk_id = d.tsk_id)) AND ((a.ACTIVE_IND)="Y") AND ((a.STAT_ID)=1) AND ((a.TASKTYPE)=2) AND ((b.TSK_ID)=[a].[tsk_id]) and (a.tsk_id=d.tsk_id and d.empl_id=ManID and d.empl_id = e.empl_id) ) ORDER BY a.PREF, a.SFX; |