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_DUNNING_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 3039: ,ar_payment_schedules a

3035: /*
3036: CURSOR C_DISPUTED_AMOUNT(P_PARTY_ID NUMBER, P_CUST_ACCOUNT_ID NUMBER, P_SITE_USE_ID NUMBER ) IS
3037: select sum(a.amount_in_dispute) - sum(a.amount_due_remaining)
3038: from iex_delinquencies d
3039: ,ar_payment_schedules a
3040: where a.payment_schedule_id = d.payment_schedule_id
3041: and d.party_cust_id = nvl(p_party_id, d.party_cust_id)
3042: and d.cust_account_id = nvl(P_CUST_ACCOUNT_ID, d.cust_account_id )
3043: and d.customer_site_use_id = nvl(p_site_use_id, d.customer_site_use_id )

Line 3049: ,ar_payment_schedules a

3045: */
3046: CURSOR C_DISPUTED_AMOUNT_PARTY(P_PARTY_ID NUMBER) IS
3047: select sum(a.amount_in_dispute) - sum(a.amount_due_remaining)
3048: from iex_delinquencies d
3049: ,ar_payment_schedules a
3050: where a.payment_schedule_id = d.payment_schedule_id
3051: and d.party_cust_id = p_party_id
3052: and d.status IN ('DELINQUENT', 'PREDELINQUENT');
3053:

Line 3057: ,ar_payment_schedules a

3053:
3054: CURSOR C_DISPUTED_AMOUNT_ACCOUNT(P_CUST_ACCOUNT_ID NUMBER) IS
3055: select sum(a.amount_in_dispute) - sum(a.amount_due_remaining)
3056: from iex_delinquencies d
3057: ,ar_payment_schedules a
3058: where a.payment_schedule_id = d.payment_schedule_id
3059: and d.cust_account_id = P_CUST_ACCOUNT_ID
3060: and d.status IN ('DELINQUENT', 'PREDELINQUENT');
3061:

Line 3065: ,ar_payment_schedules a

3061:
3062: CURSOR C_DISPUTED_AMOUNT_BILLTO(P_SITE_USE_ID NUMBER ) IS
3063: select sum(a.amount_in_dispute) - sum(a.amount_due_remaining)
3064: from iex_delinquencies d
3065: ,ar_payment_schedules a
3066: where a.payment_schedule_id = d.payment_schedule_id
3067: and d.customer_site_use_id = p_site_use_id
3068: and d.status IN ('DELINQUENT', 'PREDELINQUENT');
3069:

Line 3781: from ar_payment_schedules_all ps,

3777: --
3778: cursor c_amount (IN_ID number) is
3779: select ps.amount_due_remaining,
3780: ps.invoice_currency_code
3781: from ar_payment_schedules_all ps,
3782: --iex_delinquencies_all del
3783: iex_delinquencies del
3784: where ps.payment_schedule_id (+)= del.payment_schedule_id
3785: and del.delinquency_id = in_id;

Line 5126: from ar_payment_schedules_all ps,

5122: --
5123: cursor c_amount (IN_ID number) is
5124: select ps.amount_due_remaining,
5125: ps.invoice_currency_code
5126: from ar_payment_schedules_all ps,
5127: --iex_delinquencies_all del
5128: iex_delinquencies del
5129: where ps.payment_schedule_id (+)= del.payment_schedule_id
5130: and del.delinquency_id = in_id;

Line 5738: ar_payment_schedules ar

5734: -- begin bug 4914799, add max function and check del status
5735: CURSOR C_GET_PARTY_DAYS (in_party_id number) IS
5736: SELECT max(sysdate - ar.due_date) days
5737: FROM iex_delinquencies del,
5738: ar_payment_schedules ar
5739: WHERE del.party_cust_id = in_party_id
5740: AND del.payment_schedule_id = ar.payment_schedule_id
5741: and del.status in ('DELINQUENT', 'PREDELINQUENT');
5742: --

Line 5746: ar_payment_schedules ar

5742: --
5743: CURSOR C_GET_ACCT_DAYS (in_acct_id number) IS
5744: SELECT max(sysdate - ar.due_date) days
5745: FROM iex_delinquencies del,
5746: ar_payment_schedules ar
5747: WHERE del.cust_account_id = in_acct_id
5748: AND del.payment_schedule_id = ar.payment_schedule_id
5749: and del.status in ('DELINQUENT', 'PREDELINQUENT');
5750: --

Line 5754: ar_payment_schedules ar

5750: --
5751: CURSOR C_GET_SITE_DAYS (in_site_id number) IS
5752: SELECT max(sysdate - ar.due_date) days
5753: FROM iex_delinquencies del,
5754: ar_payment_schedules ar
5755: WHERE del.customer_site_use_id = in_site_id
5756: AND del.payment_schedule_id = ar.payment_schedule_id
5757: and del.status in ('DELINQUENT', 'PREDELINQUENT');
5758: --

Line 5762: ar_payment_schedules ar

5758: --
5759: CURSOR C_GET_DAYS (IN_DEL_ID NUMBER) IS
5760: SELECT (sysdate - ar.due_date) days
5761: FROM iex_delinquencies del,
5762: ar_payment_schedules ar
5763: WHERE delinquency_ID = in_DEL_ID
5764: AND del.payment_schedule_id = ar.payment_schedule_id
5765: and del.status in ('DELINQUENT', 'PREDELINQUENT');
5766: -- end bug 4914799, add max function and check del status

Line 9013: AR_PAYMENT_SCHEDULES ar

9009: h.party_name
9010: FROM IEX_DELINQUENCIES d,
9011: HZ_PARTIES h,
9012: HZ_CUST_ACCOUNTS a,
9013: AR_PAYMENT_SCHEDULES ar
9014: WHERE d.delinquency_ID = in_del_ID
9015: AND h.party_id = d.party_cust_id
9016: AND d.cust_account_id = a.cust_account_id
9017: AND ar.payment_schedule_id = d.payment_schedule_id

Line 9831: from ar_payment_schedules_all ps,

9827: FUNCTION Party_currency_code(p_party_id NUMBER) RETURN VARCHAR2
9828: IS
9829: cursor c_amount (IN_ID number) is
9830: select ps.invoice_currency_code
9831: from ar_payment_schedules_all ps,
9832: iex_delinquencies del
9833: where ps.payment_schedule_id (+)= del.payment_schedule_id
9834: and del.party_cust_id = in_id;
9835: l_code VARCHAR2(15);

Line 9858: from ar_payment_schedules_all ps,

9854: FUNCTION acct_currency_code(p_account_id NUMBER) RETURN VARCHAR2
9855: IS
9856: cursor c_amount (IN_ID number) is
9857: select ps.invoice_currency_code
9858: from ar_payment_schedules_all ps,
9859: --iex_delinquencies_all del
9860: iex_delinquencies del
9861: where ps.payment_schedule_id (+)= del.payment_schedule_id
9862: and del.cust_account_id = in_id;

Line 9886: from ar_payment_schedules_all ps,

9882: FUNCTION site_currency_code(p_customer_site_use_id NUMBER) RETURN VARCHAR2
9883: IS
9884: cursor c_amount (IN_ID number) is
9885: select ps.invoice_currency_code
9886: from ar_payment_schedules_all ps,
9887: iex_delinquencies del
9888: where ps.payment_schedule_id (+)= del.payment_schedule_id
9889: and del.customer_site_use_id = in_id;
9890:

Line 9915: from ar_payment_schedules_all ps,

9911: FUNCTION party_amount_due_remaining(p_party_id NUMBER) RETURN NUMBER
9912: IS
9913: cursor c_amount (IN_ID number) is
9914: select sum(ps.acctd_amount_due_remaining)
9915: from ar_payment_schedules_all ps,
9916: iex_delinquencies del
9917: where ps.payment_schedule_id (+)= del.payment_schedule_id
9918: and del.party_cust_id = in_id;
9919: l_sum number;

Line 9942: from ar_payment_schedules_all ps,

9938: FUNCTION acct_amount_due_remaining(p_account_id NUMBER) RETURN NUMBER
9939: IS
9940: cursor c_amount (IN_ID number) is
9941: select sum(ps.acctd_amount_due_remaining)
9942: from ar_payment_schedules_all ps,
9943: --iex_delinquencies_all del
9944: iex_delinquencies del
9945: where ps.payment_schedule_id (+)= del.payment_schedule_id
9946: and del.cust_account_id = in_id;

Line 9970: from ar_payment_schedules_all ps,

9966: FUNCTION site_amount_due_remaining(p_customer_site_use_id NUMBER) RETURN NUMBER
9967: IS
9968: cursor c_amount (IN_ID number) is
9969: select sum(ps.acctd_amount_due_remaining)
9970: from ar_payment_schedules_all ps,
9971: iex_delinquencies del
9972: where ps.payment_schedule_id (+)= del.payment_schedule_id
9973: and del.customer_site_use_id = in_id;
9974: l_sum number;