SELECT DISTINCT T.ROWID ROW_ID , T.TRANS_UNIT_ID , T.TRANS_UNIT_NUM , T.CREATION_DATE , T.AMOUNT , T.CREATED_BY , F.USER_NAME , X.APPLICATION , T.DOC_TYPE_ID , L.MEANING STATUS FROM FND_USER F , IGI_EXP_TRAN_UNIT_DEF T , IGI_EXP_TRX_TYPE X , IGI_LOOKUPS L , PO_VENDORS P WHERE T.CREATED_BY = F.USER_ID AND T.DOC_TYPE_ID = X.DOC_TYPE_ID AND T.TRANS_UNIT_STATUS = L.LOOKUP_CODE AND L.LOOKUP_TYPE = 'IGI_EXP_TRANS_UNIT_STATUS'