How do I link the supplier with on-hand item (answer)

Hi all, I am crearting a report to draw the on-hand item to see the stock aging,

there are some item miscellaneous receipt without do PO, therefore, i have problem drawing data for both received from PO receipt and Miscellaneous receipt, so i union the 2 sql, but it runs too long, can't result,  is there any better ways to get the supplier for the PO receipt one , null for Miscellaneous receipt,  thanks

 SELECT distinct  MOQV.CREATE_TRANSACTION_ID CREATID,

HROU.ATTRIBUTE1 ORG_CODE,

  MOQV.SUBINVENTORY_CODE SUBINV,

      IICA.ITEM_CATEGORY_201 CATEGORY, 

  ITEM,

  MSB.DESCRIPTION,

  T.LONG_DESCRIPTION,

  LOT_NUMBER AS LOT_NUM,