DBA Data[Home] [Help]

APPS.ARI_UTILITIES dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 1726: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites

1722: --------------------------------------------------------------------
1723:
1724: select aps.customer_id,sites.CUST_ACCT_SITE_ID,trx_number
1725: into l_customer_id,l_customer_acct_site_id,l_trx_number
1726: from ar_payment_schedules_all aps,HZ_CUST_SITE_USES sites
1727: where aps.customer_trx_id = l_customer_trx_id
1728: and aps.org_id = l_org_id
1729: and sites.site_use_id = aps.customer_site_use_id;
1730:

Line 1993: from ar_payment_schedules_all aps,ra_terms t

1989: ---------------------------------------------------------------------------
1990:
1991: select aps.trx_number,aps.amount_due_original,aps.invoice_currency_code,aps.due_date,t.name,t.description
1992: into l_trx_number,l_inv_amt_due,l_inv_curr_code,l_inv_due_date,l_term_nanme,l_term_desc
1993: from ar_payment_schedules_all aps,ra_terms t
1994: where aps.customer_trx_id = l_customer_trx_id
1995: and aps.customer_id = p_customer_id
1996: and aps.term_id = t.term_id(+);
1997: