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

Line 81: from MTL_LOT_NUMBERS mln

77: ,base.secondary_quantity
78: ,base.grade_code
79: ,NULL consist_string
80: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
81: from MTL_LOT_NUMBERS mln
82: ,WMS_TRX_DETAILS_TMP_V mptdtv
83: ,(
84: select msn.current_organization_id organization_id
85: ,msn.inventory_item_id

Line 115: ,mtl_lot_numbers lot

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)
119: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 170: from MTL_LOT_NUMBERS mln

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

Line 204: ,mtl_lot_numbers lot

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)
208: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 276: from MTL_LOT_NUMBERS mln

272: ,sum(base.secondary_quantity)
273: ,base.grade_code
274: ,NULL consist_string
275: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
276: from MTL_LOT_NUMBERS mln
277: ,WMS_TRX_DETAILS_TMP_V mptdtv
278: ,(
279: select msn.current_organization_id organization_id
280: ,msn.inventory_item_id

Line 310: ,mtl_lot_numbers lot

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

Line 379: from MTL_LOT_NUMBERS mln

375: ,sum(base.secondary_quantity)
376: ,base.grade_code
377: ,NULL consist_string
378: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
379: from MTL_LOT_NUMBERS mln
380: ,WMS_TRX_DETAILS_TMP_V mptdtv
381: ,(
382: SELECT x.organization_id organization_id
383: ,x.inventory_item_id inventory_item_id

Line 465: ,mtl_lot_numbers lot

461: ,decode(mils.project_id, mils.project_id, moq.project_id)
462: ,decode(mils.task_id, mils.task_id, moq.task_id)
463: ) x
464: ,mtl_secondary_inventories sub
465: ,mtl_lot_numbers lot
466: where x.primary_quantity > 0
467: and x.organization_id = sub.organization_id
468: and x.subinventory_code = sub.secondary_inventory_name
469: and x.organization_id = lot.organization_id (+)