APPS.IEX_ROUTING_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 32

    SELECT customer_number
          ,customer_id
          ,dso
          ,pastdue_invoices
          ,pastdue_balance
    FROM   ar_customer_accounts
    WHERE  customer_id = p_customer_id
    AND    acctd_or_entered = 'A'
    AND    customer_or_location = 'C';

Line: 75

    SELECT count(1)
    into   i
    FROM   iex_delinquencies_all
    WHERE  party_cust_id = p_customer_id;

Line: 130

	select distinct collector_id
		from jtf_customer_profiles_v prof, jtf_cust_accounts_all_v acct
		where acct.party_id = p_customer_id
			and prof.cust_account_id = acct.cust_account_id;