List Organization Items which have QTYONHAND but NOT Assigned to New Stock Locator

Hi,

R12.1.3.

In one of the Inventroy Organizations, users have defined New Stock Locators and assigned to some Items only.

We are looking for a query which can list the following information of the items which have:

-QTYONHAND but the QTY is still in Old Locators (Old Locators start   with number like 0,1,2,3 etc).

- The Item is not assigned to New Locator (New Locator start with alpha like A,B,C etc.)

The intended list to include:Item Code (Segment1 of MTL_SYSTEM_ITEMS_B)Organization_IDTRANSACTION_QUANTITY (MTL_ONHAND_QUANTITIES_DETAIL)Segment1 (MTL_ITEM_LOCATIONS)
Best regards,