158: utt_eqp.inventory_item_id eqp_id
159: FROM
160: (SELECT x_utt_res1.standard_operation_id standard_operation_id,
161: x_emp_r.person_id
162: FROM bom_std_op_resources x_utt_res1,
163: bom_resources r1 ,
164: bom_resource_employees x_emp_r
165: WHERE x_utt_res1.resource_id = r1.resource_id
166: AND r1.resource_type = 2
167: AND x_utt_res1.resource_id = x_emp_r.resource_id
168: ) utt_emp ,
169: (SELECT x_utt_res2.standard_operation_id standard_operation_id,
170: x_eqp_r.inventory_item_id
171: FROM bom_std_op_resources x_utt_res2,
172: bom_resources r2 ,
173: bom_resource_equipments x_eqp_r
174: WHERE x_utt_res2.resource_id = r2.resource_id
175: AND r2.resource_type = 1
217: utt_eqp.inventory_item_id eqp_id
218: FROM
219: (SELECT x_utt_res1.standard_operation_id standard_operation_id,
220: x_emp_r.person_id
221: FROM bom_std_op_resources x_utt_res1,
222: bom_resources r1 ,
223: bom_resource_employees x_emp_r
224: WHERE x_utt_res1.resource_id = r1.resource_id
225: AND r1.resource_type = 2
226: AND x_utt_res1.resource_id = x_emp_r.resource_id
227: ) utt_emp ,
228: (SELECT x_utt_res2.standard_operation_id standard_operation_id,
229: x_eqp_r.inventory_item_id
230: FROM bom_std_op_resources x_utt_res2,
231: bom_resources r2 ,
232: bom_resource_equipments x_eqp_r
233: WHERE x_utt_res2.resource_id = r2.resource_id
234: AND r2.resource_type = 1