APPS.INV_TABLE_LOCK_PVT dependencies on MTL_ONHAND_QUANTITIES_DETAIL
Line 30: FROM mtl_onhand_quantities_detail
26: p_locator;
27: if (p_issue_receipt = 0) then
28: -- Receipt 0 Issue 1
29: SELECT count(1) into l_neg_exists 30: FROM mtl_onhand_quantities_detail 31: WHERE organization_id = p_organization_id
32: AND inventory_item_id = p_inventory_item_id
33: AND subinventory_code like p_subinventory
34: AND nvl(lot_number,'@@@') like nvl(p_lot,'@@@')