| | |
|---|
| | | left join TFlw_Rtdt B on K.code=B.rout_code and B.first_choke='Y' |
|---|
| | | left join TFlw_Rteqp C on B.step_code= C.step_code |
|---|
| | | left join TEqpInfo D on C.eqp_code=D.code |
|---|
| | | left join TPrteEqp_Stad H on C.eqp_code= H.eqp_code and K.code=H.route_code and B.step_code=H.step_code |
|---|
| | | left join TPrteStep_Price H on C.eqp_code= H.eqp_code and K.code=H.route_code and B.step_code=H.step_code |
|---|
| | | where A.wo_code=@wocode and H.materiel_code=@partcode and D.wksp_code=@wkshpcode and D.enable='Y' |
|---|
| | | order by C.eqp_code"; |
|---|
| | | dynamicParams.Add("@wocode", wocode); |
|---|
