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 82: from MTL_ITEM_LOCATIONS mil

78: ,base.secondary_quantity
79: ,base.grade_code
80: ,NULL consist_string
81: ,NULL order_by_string
82: from MTL_ITEM_LOCATIONS mil
83: ,
84: MTL_LOT_NUMBERS mlna ,
85: WMS_TRX_DETAILS_TMP_V mptdtv
86: ,(

Line 117: ,mtl_item_locations loc

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

Line 175: from MTL_ITEM_LOCATIONS mil

171: ,sum(base.secondary_quantity)
172: ,base.grade_code
173: ,NULL consist_string
174: ,NULL order_by_string
175: from MTL_ITEM_LOCATIONS mil
176: ,
177: MTL_LOT_NUMBERS mlna ,
178: WMS_TRX_DETAILS_TMP_V mptdtv
179: ,(

Line 210: ,mtl_item_locations loc

206: ,NULL empty_flag
207: ,NULL location_current_units
208: from mtl_serial_numbers msn
209: ,mtl_secondary_inventories sub
210: ,mtl_item_locations loc
211: ,mtl_lot_numbers lot
212: where msn.current_status = 3
213: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
214: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 284: from MTL_ITEM_LOCATIONS mil

280: ,sum(base.secondary_quantity)
281: ,base.grade_code
282: ,NULL consist_string
283: ,NULL order_by_string
284: from MTL_ITEM_LOCATIONS mil
285: ,
286: MTL_LOT_NUMBERS mlna ,
287: WMS_TRX_DETAILS_TMP_V mptdtv
288: ,(

Line 319: ,mtl_item_locations loc

315: ,NULL empty_flag
316: ,NULL location_current_units
317: from mtl_serial_numbers msn
318: ,mtl_secondary_inventories sub
319: ,mtl_item_locations loc
320: ,mtl_lot_numbers lot
321: where msn.current_status = 3
322: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
323: decode(g_unit_number, '-9999', 'a', g_unit_number)

Line 390: from MTL_ITEM_LOCATIONS mil

386: ,sum(base.secondary_quantity)
387: ,base.grade_code
388: ,NULL consist_string
389: ,NULL order_by_string
390: from MTL_ITEM_LOCATIONS mil
391: ,
392: MTL_LOT_NUMBERS mlna ,
393: WMS_TRX_DETAILS_TMP_V mptdtv
394: ,(

Line 462: mtl_onhand_quantities_detail moq,mtl_item_locations mils

458: ,moq.lpn_id lpn_id
459: ,decode(mils.project_id, mils.project_id, moq.project_id) project_id
460: ,decode(mils.task_id, mils.task_id, moq.task_id) task_id
461: FROM
462: mtl_onhand_quantities_detail moq,mtl_item_locations mils
463: WHERE
464: moq.organization_id = g_organization_id
465: AND moq.inventory_item_id = g_inventory_item_id
466: AND moq.organization_id = mils.organization_id (+)

Line 491: ,mtl_item_locations loc

487: and x.inventory_item_id = lot.inventory_item_id (+)
488: and x.lot_number = lot.lot_number (+)
489: ) x
490: ,mtl_secondary_inventories sub
491: ,mtl_item_locations loc
492: WHERE x.organization_id = loc.organization_id (+)
493: AND x.locator_id = loc.inventory_location_id (+)
494: AND sub.organization_id = x.organization_id
495: AND sub.secondary_inventory_name = x.subinventory_code