Query to extract payment terms associated with a customer

oracle-ebs-customer-payment-terms

SELECT customer_name, site_use_code, location,

payment_term_id, name

  FROM apps.hz_cust_site_uses_all a1,

       hz_cust_acct_sites_all a2,

       ar_customers a3,

       ra_terms a4

 WHERE a1.cust_acct_site_id = a2.cust_acct_site_id

   AND a2.cust_account_id = a3.customer_id

   AND a3.customer_id = :p_customer_id

   AND a1.payment_term_id = a4.term_id(+);