Inventory Transaction Open Interface Errors Fix- Report(SQL)

SELECT MSI.SEGMENT1 NSN, M.ORGANIZATION_CODE ORG, M.TRANSACTION_QUANTITY TRXN_QTY, M.TRANSACTION_UOM UOM,M.SUBINVENTORY_CODE SUBINVENTORY, MIL.SEGMENT1||’.’||MIL.SEGMENT2||’.’||MIL.SEGMENT3||’.’||MIL.SEGMENT4 LOCATOR,
M.TRANSACTION_SOURCE_ID TRX_SOURCE_ID,M.TRANSACTION_REFERENCE, M.TRANSFER_SUBINVENTORY TRSFR_SUB, M.TRANSFER_LOCATOR TRSFR_LOCATOR, /M.TRANSFER_ORGANIZATION_CODE,/
M.SHIPMENT_NUMBER, /M.ERROR_EXPLANATION,/ M.ERROR_CODE , M2.TRANSACTION_QUANTITY ONHAND_QTY, M2.SUBINVENTORY_CODE ONHAND_SUB_INV, M2.ITEM_LOCATOR_NAME ONHAND_LOCATOR
FROM APPS.MTL_TRANSACTIONS_INTERFACE_V M,
APPS.MTL_SYSTEM_ITEMS_B MSI,
APPS.MTL_ITEM_LOCATIONS MIL,
(SELECT MSI.INVENTORY_ITEM_ID,MSI.SEGMENT1, MOQ.TRANSACTION_QUANTITY, MOQ.SUBINVENTORY_CODE, MIL.SEGMENT1||’.’||MIL.SEGMENT2||’.’||MIL.SEGMENT3||’.’||MIL.SEGMENT4 ITEM_LOCATOR_NAME , MOQ.ORGANIZATION_ID, MSI.UNIT_OF_ISSUE
FROM APPS.MTL_SYSTEM_ITEMS_B MSI,
APPS.MTL_ONHAND_QUANTITIES MOQ,
APPS.MTL_ITEM_LOCATIONS MIL
WHERE MSI.INVENTORY_ITEM_ID = MOQ.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MOQ.ORGANIZATION_ID
AND MOQ.INVENTORY_ITEM_ID = MIL.INVENTORY_ITEM_ID
AND MOQ.ORGANIZATION_ID = MIL.ORGANIZATION_ID
AND MOQ.LOCATOR_ID = MIL.INVENTORY_LOCATION_ID) M2
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)
AND M.ORGANIZATION_CODE = ‘XXX’
AND MSI.INVENTORY_ITEM_ID = M2.INVENTORY_ITEM_ID(+)
ORDER BY MSI.SEGMENT1 DESC;