VIEW: APPS.JAI_AP_TDS_THHOLD_VENDOR_V

Source

View Text - Preformatted

SELECT DISTINCT b.tds_vendor_type_lookup_code vendor_type_lookup_code, a.vendor_id, a.vendor_name FROM po_vendors a, JAI_AP_TDS_VENDOR_HDRS b WHERE a.vendor_id = b.vendor_id AND b.vendor_site_id = 0 AND b.tds_vendor_type_lookup_code IS NOT NULL

View Text - HTML Formatted

SELECT DISTINCT B.TDS_VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, A.VENDOR_ID
, A.VENDOR_NAME
FROM PO_VENDORS A
, JAI_AP_TDS_VENDOR_HDRS B
WHERE A.VENDOR_ID = B.VENDOR_ID
AND B.VENDOR_SITE_ID = 0
AND B.TDS_VENDOR_TYPE_LOOKUP_CODE IS NOT NULL