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.

[Home] [Help]

APPS.WMS_RULE_3 dependencies on MTL_LOT_NUMBERS

Line 88: from MTL_LOT_NUMBERS mln

84: ,base.SUBINVENTORY_CODE
85: ,base.LOCATOR_ID
86: ,msi.PRIMARY_UOM_CODE
87: ,mptdtv.TRANSACTION_UOM ) order_by_string
88: from MTL_LOT_NUMBERS mln
89: ,MTL_SYSTEM_ITEMS msi
90: ,
91: MTL_LOT_NUMBERS mlna ,
92: WMS_TRX_DETAILS_TMP_V mptdtv

Line 91: MTL_LOT_NUMBERS mlna ,

87: ,mptdtv.TRANSACTION_UOM ) order_by_string
88: from MTL_LOT_NUMBERS mln
89: ,MTL_SYSTEM_ITEMS msi
90: ,
91: MTL_LOT_NUMBERS mlna ,
92: WMS_TRX_DETAILS_TMP_V mptdtv
93: ,(
94: select msn.current_organization_id organization_id
95: ,msn.inventory_item_id

Line 125: ,mtl_lot_numbers lot

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

Line 200: from MTL_LOT_NUMBERS mln

196: ,base.SUBINVENTORY_CODE
197: ,base.LOCATOR_ID
198: ,msi.PRIMARY_UOM_CODE
199: ,mptdtv.TRANSACTION_UOM ) order_by_string
200: from MTL_LOT_NUMBERS mln
201: ,MTL_SYSTEM_ITEMS msi
202: ,
203: MTL_LOT_NUMBERS mlna ,
204: WMS_TRX_DETAILS_TMP_V mptdtv

Line 203: MTL_LOT_NUMBERS mlna ,

199: ,mptdtv.TRANSACTION_UOM ) order_by_string
200: from MTL_LOT_NUMBERS mln
201: ,MTL_SYSTEM_ITEMS msi
202: ,
203: MTL_LOT_NUMBERS mlna ,
204: WMS_TRX_DETAILS_TMP_V mptdtv
205: ,(
206: select msn.current_organization_id organization_id
207: ,msn.inventory_item_id

Line 237: ,mtl_lot_numbers lot

233: ,NULL location_current_units
234: from mtl_serial_numbers msn
235: ,mtl_secondary_inventories sub
236: ,mtl_item_locations loc
237: ,mtl_lot_numbers lot
238: where msn.current_status = 3
239: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
240: decode(g_unit_number, '-9999', 'a', g_unit_number)
241: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 341: from MTL_LOT_NUMBERS mln

337: ,base.SUBINVENTORY_CODE
338: ,base.LOCATOR_ID
339: ,msi.PRIMARY_UOM_CODE
340: ,mptdtv.TRANSACTION_UOM ) order_by_string
341: from MTL_LOT_NUMBERS mln
342: ,MTL_SYSTEM_ITEMS msi
343: ,
344: MTL_LOT_NUMBERS mlna ,
345: WMS_TRX_DETAILS_TMP_V mptdtv

Line 344: MTL_LOT_NUMBERS mlna ,

340: ,mptdtv.TRANSACTION_UOM ) order_by_string
341: from MTL_LOT_NUMBERS mln
342: ,MTL_SYSTEM_ITEMS msi
343: ,
344: MTL_LOT_NUMBERS mlna ,
345: WMS_TRX_DETAILS_TMP_V mptdtv
346: ,(
347: select msn.current_organization_id organization_id
348: ,msn.inventory_item_id

Line 378: ,mtl_lot_numbers lot

374: ,NULL location_current_units
375: from mtl_serial_numbers msn
376: ,mtl_secondary_inventories sub
377: ,mtl_item_locations loc
378: ,mtl_lot_numbers lot
379: where msn.current_status = 3
380: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
381: decode(g_unit_number, '-9999', 'a', g_unit_number)
382: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 479: from MTL_LOT_NUMBERS mln

475: ,base.SUBINVENTORY_CODE
476: ,base.LOCATOR_ID
477: ,msi.PRIMARY_UOM_CODE
478: ,mptdtv.TRANSACTION_UOM ) order_by_string
479: from MTL_LOT_NUMBERS mln
480: ,MTL_SYSTEM_ITEMS msi
481: ,
482: MTL_LOT_NUMBERS mlna ,
483: WMS_TRX_DETAILS_TMP_V mptdtv

Line 482: MTL_LOT_NUMBERS mlna ,

478: ,mptdtv.TRANSACTION_UOM ) order_by_string
479: from MTL_LOT_NUMBERS mln
480: ,MTL_SYSTEM_ITEMS msi
481: ,
482: MTL_LOT_NUMBERS mlna ,
483: WMS_TRX_DETAILS_TMP_V mptdtv
484: ,(
485: SELECT x.organization_id organization_id
486: ,x.inventory_item_id inventory_item_id

Line 571: ,mtl_lot_numbers lot

567: HAVING
568: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
569: ) x
570: ,mtl_secondary_inventories sub
571: ,mtl_lot_numbers lot
572: where
573: -- x.primary_quantity > 0 and -- high volume project 8546026
574: x.organization_id = sub.organization_id
575: and x.subinventory_code = sub.secondary_inventory_name