DBA Data[Home] [Help]

APPS.WMS_SHIPPING_LOVS dependencies on BOM_STD_OP_RESOURCES

Line 162: FROM bom_std_op_resources x_utt_res1,

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

Line 171: FROM bom_std_op_resources x_utt_res2,

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

Line 221: FROM bom_std_op_resources x_utt_res1,

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

Line 230: FROM bom_std_op_resources x_utt_res2,

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