AP_PAYMENT_DISTRIBUTIONS_ALL

SELECT tab.*

FROM AP_PAYMENT_DISTRIBUTIONS_ALL tab,

AP_INVOICE_PAYMENTS_ALL aip

WHERE aip.invoice_payment_id = tab.invoice_payment_id

AND   aip.invoice_id         = '166014';