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_3 dependencies on MTL_LOT_NUMBERS

Line 87: from MTL_LOT_NUMBERS mln

83: ,base.SUBINVENTORY_CODE
84: ,base.LOCATOR_ID
85: ,msi.PRIMARY_UOM_CODE
86: ,mptdtv.TRANSACTION_UOM ) order_by_string
87: from MTL_LOT_NUMBERS mln
88: ,MTL_SYSTEM_ITEMS msi
89: ,WMS_TRX_DETAILS_TMP_V mptdtv
90: ,(
91: select msn.current_organization_id organization_id

Line 122: ,mtl_lot_numbers lot

118: ,NULL location_current_units
119: from mtl_serial_numbers msn
120: ,mtl_secondary_inventories sub
121: ,mtl_item_locations loc
122: ,mtl_lot_numbers lot
123: where msn.current_status = 3
124: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
125: decode(g_unit_number, '-9999', 'a', g_unit_number)
126: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 194: from MTL_LOT_NUMBERS mln

190: ,base.SUBINVENTORY_CODE
191: ,base.LOCATOR_ID
192: ,msi.PRIMARY_UOM_CODE
193: ,mptdtv.TRANSACTION_UOM ) order_by_string
194: from MTL_LOT_NUMBERS mln
195: ,MTL_SYSTEM_ITEMS msi
196: ,WMS_TRX_DETAILS_TMP_V mptdtv
197: ,(
198: select msn.current_organization_id organization_id

Line 229: ,mtl_lot_numbers lot

225: ,NULL location_current_units
226: from mtl_serial_numbers msn
227: ,mtl_secondary_inventories sub
228: ,mtl_item_locations loc
229: ,mtl_lot_numbers lot
230: where msn.current_status = 3
231: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
232: decode(g_unit_number, '-9999', 'a', g_unit_number)
233: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 330: from MTL_LOT_NUMBERS mln

326: ,base.SUBINVENTORY_CODE
327: ,base.LOCATOR_ID
328: ,msi.PRIMARY_UOM_CODE
329: ,mptdtv.TRANSACTION_UOM ) order_by_string
330: from MTL_LOT_NUMBERS mln
331: ,MTL_SYSTEM_ITEMS msi
332: ,WMS_TRX_DETAILS_TMP_V mptdtv
333: ,(
334: select msn.current_organization_id organization_id

Line 365: ,mtl_lot_numbers lot

361: ,NULL location_current_units
362: from mtl_serial_numbers msn
363: ,mtl_secondary_inventories sub
364: ,mtl_item_locations loc
365: ,mtl_lot_numbers lot
366: where msn.current_status = 3
367: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
368: decode(g_unit_number, '-9999', 'a', g_unit_number)
369: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 463: from MTL_LOT_NUMBERS mln

459: ,base.SUBINVENTORY_CODE
460: ,base.LOCATOR_ID
461: ,msi.PRIMARY_UOM_CODE
462: ,mptdtv.TRANSACTION_UOM ) order_by_string
463: from MTL_LOT_NUMBERS mln
464: ,MTL_SYSTEM_ITEMS msi
465: ,WMS_TRX_DETAILS_TMP_V mptdtv
466: ,(
467: SELECT x.organization_id organization_id

Line 550: ,mtl_lot_numbers lot

546: ,decode(mils.project_id, mils.project_id, moq.project_id)
547: ,decode(mils.task_id, mils.task_id, moq.task_id)
548: ) x
549: ,mtl_secondary_inventories sub
550: ,mtl_lot_numbers lot
551: where x.primary_quantity > 0
552: and x.organization_id = sub.organization_id
553: and x.subinventory_code = sub.secondary_inventory_name
554: and x.organization_id = lot.organization_id (+)