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

Line 83: MTL_LOT_NUMBERS mlna ,

79: ,base.grade_code
80: ,NULL consist_string
81: ,NULL 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 170: MTL_LOT_NUMBERS mlna ,

166: ,base.grade_code
167: ,NULL consist_string
168: ,NULL order_by_string
169: from
170: MTL_LOT_NUMBERS mlna ,
171: WMS_TRX_DETAILS_TMP_V mptdtv
172: ,(
173: select msn.current_organization_id organization_id
174: ,msn.inventory_item_id

Line 204: ,mtl_lot_numbers lot

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

Line 273: MTL_LOT_NUMBERS mlna ,

269: ,base.grade_code
270: ,NULL consist_string
271: ,NULL order_by_string
272: from
273: MTL_LOT_NUMBERS mlna ,
274: WMS_TRX_DETAILS_TMP_V mptdtv
275: ,(
276: select msn.current_organization_id organization_id
277: ,msn.inventory_item_id

Line 307: ,mtl_lot_numbers lot

303: ,NULL location_current_units
304: from mtl_serial_numbers msn
305: ,mtl_secondary_inventories sub
306: ,mtl_item_locations loc
307: ,mtl_lot_numbers lot
308: where msn.current_status = 3
309: and decode(g_unit_number, '-9999', 'a', '-7777', nvl(msn.end_item_unit_number, '-7777'), msn.end_item_unit_number) =
310: decode(g_unit_number, '-9999', 'a', g_unit_number)
311: and (msn.group_mark_id IS NULL or msn.group_mark_id = -1)

Line 373: MTL_LOT_NUMBERS mlna ,

369: ,base.grade_code
370: ,NULL consist_string
371: ,NULL order_by_string
372: from
373: MTL_LOT_NUMBERS mlna ,
374: WMS_TRX_DETAILS_TMP_V mptdtv
375: ,(
376: SELECT x.organization_id organization_id
377: ,x.inventory_item_id inventory_item_id

Line 462: ,mtl_lot_numbers lot

458: HAVING
459: sum(moq.primary_transaction_quantity) > 0 -- high volume project 8546026
460: ) x
461: ,mtl_secondary_inventories sub
462: ,mtl_lot_numbers lot
463: where
464: -- x.primary_quantity > 0 and -- high volume project 8546026
465: x.organization_id = sub.organization_id
466: and x.subinventory_code = sub.secondary_inventory_name