DBA Data[Home] [Help]

VIEW: APPS.IGI_CIS_PMT_VCH_V

Source

View Text - Preformatted

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