select 'OPR' partnerType, operatorId partnerId, territoryId, territoryName, companyName, address address1, address2, city, state, zipcode, country, phone from qmd_operatorDetails select 'CDR' partnerType, cdr_recordId partnerId, territoryId, territoryName, cdr_dstcode accountNbr, cdr_dstname companyName, cdr_dstaddress1 address1, cdr_dstaddress2 address2, cdr_dstcity city, cdr_dststate state, cdr_dstzip zipcode, country, cdr_dstPhone phone from qmd_distributorDetails select * from qmd_interactionPurposes union select * from qmd_inactivePurpose