select TO_CHAR((ihdr.inventory_date),'MM/DD/YYYY') as inv_date,
inv.user_id,
stor.storage_code,
prd.product_name_number,
inv.primary_count,
inv.alt1_count,
inv.alt2_count,
inv.alt3_count
from t_product_company prd,
t_storage stor,
t_dtl_inventory_schedule inv,
t_hdr_inventory_schedule ihdr,
(select *
from t_location
where location_code = '0202' --Input your location code here
and location_active = 'Y') loc
where ihdr.hdr_inventory_schedule_pk = inv.hdr_inventory_schedule_pk
and ihdr.location_id = inv.location_id
and ihdr.inventory_date = to_date('&post_date','mm/dd/yyyy')
and prd.product_id = inv.product_id
and stor.storage_id = inv.storage_id
and ihdr.location_id = loc.location_id
--and stor.storage_code = 'UNASGN'
order by 2,3;


Instruction:
Copy the below query from the word 'select' into your Oracle interface.

Input your Location Code in the 15th line of the query, where you see "Input your location code here".  This code must be surrounded by single apostrophes as seen.

Run the query.  When you run it, you will be asked for the Post Date that you would like to run the query for.  This should be a single date in MM/DD/YYYY format. 

Export the results as .CSV and open in excel to edit or resave in import format.

NOTE: If you have any fields that contain leading 0's, excel will drop them.  In this query, this may be the case with your Storage Codes.  If it is important to open the file and not drop leading zeroes in any field, use excel's "Open from text" feature, and open as a Comma Delimited File, adjusting your column(s) with the leading zeroes to be a 'Text' column data format.
Once your file is ready you can name it "008" + Location Code, and save as a Tab Delimited Text file.