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_RULE_18 dependencies on MTL_ITEM_LOCATIONS

Line 81: from MTL_ITEM_LOCATIONS mil

77: ,base.secondary_quantity
78: ,base.grade_code
79: ,NULL consist_string
80: ,NULL order_by_string
81: from MTL_ITEM_LOCATIONS mil
82: ,WMS_TRX_DETAILS_TMP_V mptdtv
83: ,(
84: select msn.current_organization_id organization_id
85: ,msn.inventory_item_id

Line 114: ,mtl_item_locations loc

110: ,NULL empty_flag
111: ,NULL location_current_units
112: from mtl_serial_numbers msn
113: ,mtl_secondary_inventories sub
114: ,mtl_item_locations loc
115: ,mtl_lot_numbers lot
116: where msn.current_status = 3
117: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
118: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 170: from MTL_ITEM_LOCATIONS mil

166: ,sum(base.secondary_quantity)
167: ,base.grade_code
168: ,NULL consist_string
169: ,NULL order_by_string
170: from MTL_ITEM_LOCATIONS mil
171: ,WMS_TRX_DETAILS_TMP_V mptdtv
172: ,(
173: select msn.current_organization_id organization_id
174: ,msn.inventory_item_id

Line 203: ,mtl_item_locations loc

199: ,NULL empty_flag
200: ,NULL location_current_units
201: from mtl_serial_numbers msn
202: ,mtl_secondary_inventories sub
203: ,mtl_item_locations loc
204: ,mtl_lot_numbers lot
205: where msn.current_status = 3
206: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
207: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 275: from MTL_ITEM_LOCATIONS mil

271: ,sum(base.secondary_quantity)
272: ,base.grade_code
273: ,NULL consist_string
274: ,NULL order_by_string
275: from MTL_ITEM_LOCATIONS mil
276: ,WMS_TRX_DETAILS_TMP_V mptdtv
277: ,(
278: select msn.current_organization_id organization_id
279: ,msn.inventory_item_id

Line 308: ,mtl_item_locations loc

304: ,NULL empty_flag
305: ,NULL location_current_units
306: from mtl_serial_numbers msn
307: ,mtl_secondary_inventories sub
308: ,mtl_item_locations loc
309: ,mtl_lot_numbers lot
310: where msn.current_status = 3
311: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
312: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 377: from MTL_ITEM_LOCATIONS mil

373: ,sum(base.secondary_quantity)
374: ,base.grade_code
375: ,NULL consist_string
376: ,NULL order_by_string
377: from MTL_ITEM_LOCATIONS mil
378: ,WMS_TRX_DETAILS_TMP_V mptdtv
379: ,(
380: SELECT x.organization_id organization_id
381: ,x.inventory_item_id inventory_item_id

Line 447: mtl_onhand_quantities_detail moq,mtl_item_locations mils

443: ,moq.lpn_id lpn_id
444: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
445: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
446: FROM
447: mtl_onhand_quantities_detail moq,mtl_item_locations mils
448: WHERE
449: moq.organization_id = g_organization_id
450: AND moq.inventory_item_id = g_inventory_item_id
451: AND moq.organization_id = mils.organization_id (+)

Line 472: ,mtl_item_locations loc

468: and x.inventory_item_id = lot.inventory_item_id (+)
469: and x.lot_number = lot.lot_number (+)
470: ) x
471: ,mtl_secondary_inventories sub
472: ,mtl_item_locations loc
473: WHERE x.organization_id = loc.organization_id (+)
474: AND x.locator_id = loc.inventory_location_id (+)
475: AND sub.organization_id = x.organization_id
476: AND sub.secondary_inventory_name = x.subinventory_code