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

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

Line 177: MTL_LOT_NUMBERS mlna ,

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

Line 211: ,mtl_lot_numbers lot

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

Line 285: from MTL_LOT_NUMBERS mln

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

Line 287: MTL_LOT_NUMBERS mlna ,

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

Line 321: ,mtl_lot_numbers lot

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

Line 392: from MTL_LOT_NUMBERS mln

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

Line 394: MTL_LOT_NUMBERS mlna ,

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

Line 483: ,mtl_lot_numbers lot

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