FSCM - INV/PO related PS-queries

Hello All:

I'm in the process of developing few queries to achieve the following, please let me know if any delivered queries available in 9.2 (or)  what tables need to be queried, details are as follows:

Queries to be developed in Inventory and PO:

1. View the available quantities in a stockroom for an item that need to order.
2. Status of the items ordered on a Material Stock Request.
3. Status of requested non-stock items including date of purchase; order dispatch date and expected receipt date.
4. Trend of daily order fulfillment percentage.  What percentage of items ordered were filled.

Any help is highly appreciated.