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_TRANSACTION_LOVS dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 506: FROM mtl_onhand_quantities_detail a, mtl_lot_numbers b

502: p_Lot IN VARCHAR2) IS
503: BEGIN
504: OPEN x_Lots FOR
505: SELECT b.Lot_Number,to_char(b.expiration_date,'MM-DD-YYYY')
506: FROM mtl_onhand_quantities_detail a, mtl_lot_numbers b
507: -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
508: WHERE a.organization_id = p_Organization_Id AND
509: a.inventory_item_id = p_Inventory_Item_Id AND
510: a.subinventory_code = p_subcode AND