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;