eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_UTILITIES dependencies on AR_PAYMENT_SCHEDULES

Line 58: FROM AR_PAYMENT_SCHEDULES

54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: SELECT nvl( SUM (acctd_amount_due_remaining), 0) AMOUNT
57: into Amount
58: FROM AR_PAYMENT_SCHEDULES
59: WHERE customer_id = p_cust_acct_id
60: AND customer_id+0 = p_cust_acct_id
61: AND class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
62: AND status = 'OP' ;

Line 68: FROM AR_PAYMENT_SCHEDULES

64: total := amount ;
65:
66: SELECT nvl(SUM (acctd_amount_due_remaining), 0) AMOUNT
67: into amount
68: FROM AR_PAYMENT_SCHEDULES
69: WHERE customer_id = p_cust_acct_id
70: AND customer_id+0 = p_cust_acct_id
71: AND class = 'PMT'
72: AND status = 'OP'

Line 81: FROM AR_PAYMENT_SCHEDULES

77:
78:
79: SELECT nvl(SUM (acctd_amount_due_remaining), 0) AMOUNT
80: into amount
81: FROM AR_PAYMENT_SCHEDULES
82: WHERE customer_id = p_cust_acct_id
83: AND customer_id+0 = p_cust_acct_id
84: AND class = 'CM'
85: AND status = 'OP';

Line 1580: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

1576:
1577: -- only open status
1578: cursor c_amount_billto (p_site_use_id number) is
1579: select nvl(a.amount_due_remaining, 0), a.invoice_currency_code, class
1580: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
1581: where a.payment_schedule_id = b.payment_schedule_id
1582: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1583: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1584: and a.status = 'OP'

Line 1597: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

1593:
1594: -- only open status
1595: cursor c_amount_account (p_cust_account_id number) is
1596: select nvl(a.amount_due_remaining,0), a.invoice_currency_code, class
1597: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
1598: where a.payment_schedule_id = b.payment_schedule_id
1599: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1600: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1601: and a.status = 'OP'

Line 1610: from ar_payment_schedules_all a, iex_delinquencies_all b

1606: l_tot_amt_due_rem number;
1607:
1608: cursor c_billto_dist_inv_cur (p_site_use_id number) is
1609: select distinct a.invoice_currency_code
1610: from ar_payment_schedules_all a, iex_delinquencies_all b
1611: where a.payment_schedule_id = b.payment_schedule_id
1612: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1613: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1614: and a.status = 'OP'

Line 1626: from ar_payment_schedules_all a, iex_delinquencies_all b

1622: and currency_code = p_currency_code;
1623:
1624: cursor c_billto_tot_amt_due_rem (p_site_use_id number, p_currency_code varchar, p_min_dun_inv_amt number) is
1625: select sum(nvl(a.amount_due_remaining,0))
1626: from ar_payment_schedules_all a, iex_delinquencies_all b
1627: where a.payment_schedule_id = b.payment_schedule_id
1628: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1629: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1630: and a.status = 'OP'

Line 1637: from ar_payment_schedules_all a, iex_delinquencies_all b

1633: and a.amount_due_remaining >= p_min_dun_inv_amt;
1634:
1635: cursor c_acc_dist_inv_cur (p_cust_account_id number) is
1636: select distinct a.invoice_currency_code
1637: from ar_payment_schedules_all a, iex_delinquencies_all b
1638: where a.payment_schedule_id = b.payment_schedule_id
1639: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1640: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1641: and a.status = 'OP'

Line 1654: from ar_payment_schedules_all a, iex_delinquencies_all b

1650: and site_use_id is null;
1651:
1652: cursor c_acc_tot_amt_due_rem (p_cust_account_id number, p_currency_code varchar, p_min_dun_inv_amt number) is
1653: select sum(nvl(a.amount_due_remaining,0))
1654: from ar_payment_schedules_all a, iex_delinquencies_all b
1655: where a.payment_schedule_id = b.payment_schedule_id
1656: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1657: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP')
1658: and a.status = 'OP'

Line 1926: select sum(amount_due_remaining) into amount_due_remaining from ar_payment_schedules_all

1922: FUNCTION get_amount_due_remaining (p_customer_trx_id IN number)
1923: return number is
1924: amount_due_remaining number;
1925: BEGIN
1926: select sum(amount_due_remaining) into amount_due_remaining from ar_payment_schedules_all
1927: where customer_trx_id = p_customer_trx_id;
1928: return amount_due_remaining;
1929: EXCEPTION
1930: WHEN OTHERS THEN

Line 1940: select sum(amount_due_original) into amount_due_original from ar_payment_schedules_all

1936: FUNCTION get_amount_due_original (p_customer_trx_id IN number)
1937: return number is
1938: amount_due_original number;
1939: BEGIN
1940: select sum(amount_due_original) into amount_due_original from ar_payment_schedules_all
1941: where customer_trx_id = p_customer_trx_id;
1942: return amount_due_original;
1943: EXCEPTION
1944: WHEN OTHERS THEN