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

Line 83: MTL_LOT_NUMBERS mlna ,

79: ,base.grade_code
80: ,NULL consist_string
81: ,base.DATE_RECEIVED order_by_string
82: from
83: MTL_LOT_NUMBERS mlna ,
84: WMS_TRX_DETAILS_TMP_V mptdtv
85: ,(
86: select msn.current_organization_id organization_id
87: ,msn.inventory_item_id

Line 117: ,mtl_lot_numbers lot

113: ,NULL location_current_units
114: from mtl_serial_numbers msn
115: ,mtl_secondary_inventories sub
116: ,mtl_item_locations loc
117: ,mtl_lot_numbers lot
118: where msn.current_status = 3
119: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
120: decode(g_unit_number, '-9999', 'a', g_unit_number)
121: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 171: MTL_LOT_NUMBERS mlna ,

167: ,base.grade_code
168: ,NULL consist_string
169: ,base.DATE_RECEIVED order_by_string
170: from
171: MTL_LOT_NUMBERS mlna ,
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 276: MTL_LOT_NUMBERS mlna ,

272: ,base.grade_code
273: ,NULL consist_string
274: ,base.DATE_RECEIVED order_by_string
275: from
276: MTL_LOT_NUMBERS mlna ,
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 378: MTL_LOT_NUMBERS mlna ,

374: ,base.grade_code
375: ,NULL consist_string
376: ,base.DATE_RECEIVED order_by_string
377: from
378: MTL_LOT_NUMBERS mlna ,
379: WMS_TRX_DETAILS_TMP_V mptdtv
380: ,(
381: SELECT x.organization_id organization_id
382: ,x.inventory_item_id inventory_item_id

Line 467: ,mtl_lot_numbers lot

463: HAVING
464: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
465: ) x
466: ,mtl_secondary_inventories sub
467: ,mtl_lot_numbers lot
468: where
469: -- x.primary_quantity > 0 and -- high volume project 8546026
470: x.organization_id = sub.organization_id
471: and x.subinventory_code = sub.secondary_inventory_name