eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_SHIPPING_LOVS dependencies on BOM_RESOURCES

Line 163: bom_resources r1 ,

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

Line 172: bom_resources r2 ,

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
176: AND x_utt_res2.resource_id = x_eqp_r.resource_id

Line 222: bom_resources r1 ,

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

Line 231: bom_resources r2 ,

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
235: AND x_utt_res2.resource_id = x_eqp_r.resource_id