SELECT PARTY.ID ID , PARTY.DNZ_CHR_ID DNZ_CHR_ID , PARTY.CHR_ID CHR_ID , NAME , DESCRIPTION , RLE_CODE , JTOT_OBJECT1_CODE , OBJECT1_ID1 , OBJECT1_ID2 FROM OKX_VENDORS_V VEN , OKC_K_PARTY_ROLES_B PARTY WHERE PARTY.OBJECT1_ID1 = VEN.ID1 AND PARTY.OBJECT1_ID2 = VEN.ID2