SELECT DISTINCT vendor_id ,set_of_books_id ,vendor_site_id ,pmt_vch_number ,pmt_vch_amount ,pmt_vch_received_date ,pmt_vch_description FROM IGI_CIS_CERT_INV_PMT_VCH_V WHERE pmt_vch_number IS NOT NULL
View Text - HTML Formatted
SELECT DISTINCT VENDOR_ID , SET_OF_BOOKS_ID , VENDOR_SITE_ID , PMT_VCH_NUMBER , PMT_VCH_AMOUNT , PMT_VCH_RECEIVED_DATE , PMT_VCH_DESCRIPTION FROM IGI_CIS_CERT_INV_PMT_VCH_V WHERE PMT_VCH_NUMBER IS NOT NULL