Query to find out inventory adjustment made by specific user in specific time

Query to find out inventory adjustment made by specific user in specific time 

Below is the query to find out inventory adjustment made by specific user in specific time :

SELECT   (SELECT segment1
            FROM mtl_system_items_b
           WHERE inventory_item_id = mpa.inventory_item_id
             AND organization_id = mpa.organization_id) item_number,
         (SELECT fu.user_name
            FROM apps.fnd_user fu
           WHERE fu.user_id = mpa.created_by) created_by, creation_date,
         mpa.organization_id,
         (SELECT NAME
            FROM apps.hr_organization_units hou
           WHERE organization_id = mpa.organization_id) org_name
    FROM mtl_physical_adjustments mpa
   WHERE 1 = 1 AND mpa.created_by = :user_id
   AND TRUNC (creation_date) >:p_date
ORDER BY creation_date;