AP_TERMS
SELECT *
FROM AP_TERMS
WHERE term_id IN
(SELECT DISTINCT terms_id
FROM AP_INVOICES_ALL
WHERE invoice_id = '166014'
);
_________________________________________________________________
AP_TERMS_LINES
SELECT *
FROM AP_TERMS_LINES
WHERE term_id IN
(SELECT DISTINCT terms_id
FROM AP_INVOICES_ALL
WHERE invoice_id = '166014'
);
