Inventory Transactions Open Interface Errors (SQL)

SELECT M.SOURCE_HEADER_ID, M.SOURCE_LINE_ID, M.CREATION_DATE, MSI.SEGMENT1,
M.ORGANIZATION_CODE, M.TRANSACTION_QUANTITY, M.TRANSACTION_UOM,
M.SUBINVENTORY_CODE,
MIL.SEGMENT1||’.’||MIL.SEGMENT2||’.’||MIL.SEGMENT3||’.’||MIL.SEGMENT4 LOCATOR_NAME,
M.TRANSACTION_SOURCE_ID,M.TRANSACTION_REFERENCE, M.TRANSFER_SUBINVENTORY,
M.TRANSFER_LOCATOR, M.TRANSFER_ORGANIZATION_CODE,
M.SHIPMENT_NUMBER, M.ERROR_EXPLANATION, M.ERROR_CODE
FROM APPS.MTL_TRANSACTIONS_INTERFACE_V M,
APPS.MTL_SYSTEM_ITEMS_B MSI,
APPS.MTL_ITEM_LOCATIONS MIL
WHERE M.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND M.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND M.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID
AND M.ORGANIZATION_ID = MIL.ORGANIZATION_ID
AND M.PROCESS_FLAG_DESC <> ‘Yes’
AND TRUNC(M.CREATION_DATE) > TRUNC(SYSDATE -30)
ORDER BY M.SOURCE_HEADER_ID DESC;