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

Line 82: from MTL_LOT_NUMBERS mln

78: ,base.secondary_quantity
79: ,base.grade_code
80: ,NULL 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: ,NULL 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 176: from MTL_LOT_NUMBERS mln

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

Line 178: MTL_LOT_NUMBERS mlna ,

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

Line 212: ,mtl_lot_numbers lot

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

Line 287: from MTL_LOT_NUMBERS mln

283: ,sum(base.secondary_quantity)
284: ,base.grade_code
285: ,NULL consist_string
286: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
287: from MTL_LOT_NUMBERS mln
288: ,
289: MTL_LOT_NUMBERS mlna ,
290: WMS_TRX_DETAILS_TMP_V mptdtv
291: ,(

Line 289: MTL_LOT_NUMBERS mlna ,

285: ,NULL consist_string
286: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
287: from MTL_LOT_NUMBERS mln
288: ,
289: MTL_LOT_NUMBERS mlna ,
290: WMS_TRX_DETAILS_TMP_V mptdtv
291: ,(
292: select msn.current_organization_id organization_id
293: ,msn.inventory_item_id

Line 323: ,mtl_lot_numbers lot

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

Line 395: from MTL_LOT_NUMBERS mln

391: ,sum(base.secondary_quantity)
392: ,base.grade_code
393: ,NULL consist_string
394: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
395: from MTL_LOT_NUMBERS mln
396: ,
397: MTL_LOT_NUMBERS mlna ,
398: WMS_TRX_DETAILS_TMP_V mptdtv
399: ,(

Line 397: MTL_LOT_NUMBERS mlna ,

393: ,NULL consist_string
394: ,mln.EXPIRATION_DATE||base.DATE_RECEIVED order_by_string
395: from MTL_LOT_NUMBERS mln
396: ,
397: MTL_LOT_NUMBERS mlna ,
398: WMS_TRX_DETAILS_TMP_V mptdtv
399: ,(
400: SELECT x.organization_id organization_id
401: ,x.inventory_item_id inventory_item_id

Line 486: ,mtl_lot_numbers lot

482: HAVING
483: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
484: ) x
485: ,mtl_secondary_inventories sub
486: ,mtl_lot_numbers lot
487: where
488: -- x.primary_quantity > 0 and -- high volume project 8546026
489: x.organization_id = sub.organization_id
490: and x.subinventory_code = sub.secondary_inventory_name