how to pick order number based on customer number and inventory_item_id

Hi,

I am new to customer tables and can work with order management

can any body please help me in meeting a requirement

i need to pick the order number of the particular customer and of the particular inventory_item_id where the schedule_ship_date is between sysdate to 365 days back with a minimum shipping date with only one row

--picking the old  order number for that customer with the same upc scanned 

   --with in 365 days based on minimum shipping date

    has to pick for the customer with in 365 days with minimum shipping date*/

need to pick the  earliest Order you find..  e.g. take the order line with MIN shipping date.