| | |
|---|
| | | inner join TK_Wrk_Step P on A.wo_code=P.wo_code and A.step_code=P.step_code and P.isend='Y' |
|---|
| | | left join TK_Wrk_Man K on A.wo_code=K.wo_code |
|---|
| | | left join TGroup G on B.usergroup_code=G.group_code |
|---|
| | | left join TPrteEqp_Stad S on A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code and K.wkshp_code=S.wkspcode |
|---|
| | | left join TWoPrteEqp_Stad S on A.wo_code=S.wo and A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code |
|---|
| | | left join TMateriel_Info M on A.materiel_code=M.partcode |
|---|
| | | left join TStep T on A.step_code=T.stepcode |
|---|
| | | left join TUser U on A.lm_user=U.usercode |
|---|
| | |
|---|
| | | inner join TK_Wrk_Step P on A.wo_code=P.wo_code and A.step_code=P.step_code and P.isend='Y' |
|---|
| | | left join TK_Wrk_Man K on A.wo_code=K.wo_code |
|---|
| | | left join TGroup G on B.usergroup_code=G.group_code |
|---|
| | | left join TPrteEqp_Stad S on A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code and K.wkshp_code=S.wkspcode |
|---|
| | | left join TWoPrteEqp_Stad S on A.wo_code=S.wo and A.materiel_code=S.materiel_code and A.eqp_code=S.eqp_code and A.step_code=S.step_code and K.route_code=S.route_code |
|---|
| | | left join TMateriel_Info M on A.materiel_code=M.partcode |
|---|
| | | left join TStep T on A.step_code=T.stepcode |
|---|
| | | left join TUser U on A.lm_user=U.usercode |
|---|
