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

Line 81: from MTL_LOT_NUMBERS mln

77: ,base.secondary_quantity
78: ,base.grade_code
79: ,mln.LOT_NUMBER 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 171: from MTL_LOT_NUMBERS mln

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

Line 205: ,mtl_lot_numbers lot

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

Line 280: from MTL_LOT_NUMBERS mln

276: ,sum(base.secondary_quantity)
277: ,base.grade_code
278: ,mln.LOT_NUMBER consist_string
279: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
280: from MTL_LOT_NUMBERS mln
281: ,WMS_TRX_DETAILS_TMP_V mptdtv
282: ,(
283: select msn.current_organization_id organization_id
284: ,msn.inventory_item_id

Line 314: ,mtl_lot_numbers lot

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

Line 386: from MTL_LOT_NUMBERS mln

382: ,sum(base.secondary_quantity)
383: ,base.grade_code
384: ,mln.LOT_NUMBER consist_string
385: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
386: from MTL_LOT_NUMBERS mln
387: ,WMS_TRX_DETAILS_TMP_V mptdtv
388: ,(
389: SELECT x.organization_id organization_id
390: ,x.inventory_item_id inventory_item_id

Line 472: ,mtl_lot_numbers lot

468: ,decode(mils.project_id, mils.project_id, moq.project_id)
469: ,decode(mils.task_id, mils.task_id, moq.task_id)
470: ) x
471: ,mtl_secondary_inventories sub
472: ,mtl_lot_numbers lot
473: where x.primary_quantity > 0
474: and x.organization_id = sub.organization_id
475: and x.subinventory_code = sub.secondary_inventory_name
476: and x.organization_id = lot.organization_id (+)