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.INV_INV_LOVS dependencies on WMS_ASN_DETAILS

Line 250: FROM mtl_lot_numbers mln, wms_asn_details wad,

246: SELECT DISTINCT mln.lot_number
247: , mln.description
248: , mln.expiration_date
249: , mmst.status_code
250: FROM mtl_lot_numbers mln, wms_asn_details wad,
251: rcv_shipment_headers rsh, mtl_material_statuses_tl mmst
252: WHERE mln.organization_id = p_organization_id
253: AND mln.inventory_item_id = p_item_id
254: AND mln.lot_number LIKE (p_lot_number)

Line 266: --when there is no data present in wms_asn_details and moqd.

262: AND wad.item_id = p_item_id
263: AND wad.shipment_num = rsh.shipment_num
264: AND rsh.shipment_header_id = p_source_header_id
265: --Bug5726837:Added the following union to take care of direct delivery cases
266: --when there is no data present in wms_asn_details and moqd.
267: UNION
268: SELECT rls.lot_num lot_number
269: , mln.description
270: , mln.expiration_date