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 82: from MTL_LOT_NUMBERS mln

78: ,base.secondary_quantity
79: ,base.grade_code
80: ,mln.LOT_NUMBER consist_string
81: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
82: from MTL_LOT_NUMBERS mln
83: ,
84: MTL_LOT_NUMBERS mlna ,
85: WMS_TRX_DETAILS_TMP_V mptdtv
86: ,(

Line 84: MTL_LOT_NUMBERS mlna ,

80: ,mln.LOT_NUMBER consist_string
81: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
82: from MTL_LOT_NUMBERS mln
83: ,
84: MTL_LOT_NUMBERS mlna ,
85: WMS_TRX_DETAILS_TMP_V mptdtv
86: ,(
87: select msn.current_organization_id organization_id
88: ,msn.inventory_item_id

Line 118: ,mtl_lot_numbers lot

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

Line 177: from MTL_LOT_NUMBERS mln

173: ,sum(base.secondary_quantity)
174: ,base.grade_code
175: ,mln.LOT_NUMBER consist_string
176: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
177: from MTL_LOT_NUMBERS mln
178: ,
179: MTL_LOT_NUMBERS mlna ,
180: WMS_TRX_DETAILS_TMP_V mptdtv
181: ,(

Line 179: MTL_LOT_NUMBERS mlna ,

175: ,mln.LOT_NUMBER consist_string
176: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
177: from MTL_LOT_NUMBERS mln
178: ,
179: MTL_LOT_NUMBERS mlna ,
180: WMS_TRX_DETAILS_TMP_V mptdtv
181: ,(
182: select msn.current_organization_id organization_id
183: ,msn.inventory_item_id

Line 213: ,mtl_lot_numbers lot

209: ,NULL location_current_units
210: from mtl_serial_numbers msn
211: ,mtl_secondary_inventories sub
212: ,mtl_item_locations loc
213: ,mtl_lot_numbers lot
214: where msn.current_status = 3
215: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
216: decode(g_unit_number, '-9999', 'a', g_unit_number)
217: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 291: from MTL_LOT_NUMBERS mln

287: ,sum(base.secondary_quantity)
288: ,base.grade_code
289: ,mln.LOT_NUMBER consist_string
290: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
291: from MTL_LOT_NUMBERS mln
292: ,
293: MTL_LOT_NUMBERS mlna ,
294: WMS_TRX_DETAILS_TMP_V mptdtv
295: ,(

Line 293: MTL_LOT_NUMBERS mlna ,

289: ,mln.LOT_NUMBER consist_string
290: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
291: from MTL_LOT_NUMBERS mln
292: ,
293: MTL_LOT_NUMBERS mlna ,
294: WMS_TRX_DETAILS_TMP_V mptdtv
295: ,(
296: select msn.current_organization_id organization_id
297: ,msn.inventory_item_id

Line 327: ,mtl_lot_numbers lot

323: ,NULL location_current_units
324: from mtl_serial_numbers msn
325: ,mtl_secondary_inventories sub
326: ,mtl_item_locations loc
327: ,mtl_lot_numbers lot
328: where msn.current_status = 3
329: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
330: decode(g_unit_number, '-9999', 'a', g_unit_number)
331: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 402: from MTL_LOT_NUMBERS mln

398: ,sum(base.secondary_quantity)
399: ,base.grade_code
400: ,mln.LOT_NUMBER consist_string
401: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
402: from MTL_LOT_NUMBERS mln
403: ,
404: MTL_LOT_NUMBERS mlna ,
405: WMS_TRX_DETAILS_TMP_V mptdtv
406: ,(

Line 404: MTL_LOT_NUMBERS mlna ,

400: ,mln.LOT_NUMBER consist_string
401: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
402: from MTL_LOT_NUMBERS mln
403: ,
404: MTL_LOT_NUMBERS mlna ,
405: WMS_TRX_DETAILS_TMP_V mptdtv
406: ,(
407: SELECT x.organization_id organization_id
408: ,x.inventory_item_id inventory_item_id

Line 493: ,mtl_lot_numbers lot

489: HAVING
490: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
491: ) x
492: ,mtl_secondary_inventories sub
493: ,mtl_lot_numbers lot
494: where
495: -- x.primary_quantity > 0 and -- high volume project 8546026
496: x.organization_id = sub.organization_id
497: and x.subinventory_code = sub.secondary_inventory_name