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 229: FROM mtl_lot_numbers mln, wms_asn_details wad,

225: SELECT DISTINCT mln.lot_number
226: , mln.description
227: , mln.expiration_date
228: , mmst.status_code
229: FROM mtl_lot_numbers mln, wms_asn_details wad,
230: rcv_shipment_headers rsh, mtl_material_statuses_tl mmst
231: WHERE mln.organization_id = p_organization_id
232: AND mln.inventory_item_id = p_item_id
233: AND mln.lot_number LIKE (p_lot_number)

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

241: AND wad.item_id = p_item_id
242: AND wad.shipment_num = rsh.shipment_num
243: AND rsh.shipment_header_id = p_source_header_id
244: --Bug5726837:Added the following union to take care of direct delivery cases
245: --when there is no data present in wms_asn_details and moqd.
246: UNION
247: SELECT rls.lot_num lot_number
248: , mln.description
249: , mln.expiration_date