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 …
Read More