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.ARP_MAINTAIN_PS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 986: from ar_receivable_applications app

982:
983: CURSOR del_app IS
984: select app.receivable_application_id app_id,
985: app.customer_trx_id trx_id
986: from ar_receivable_applications app
987: where app.customer_trx_id = p_customer_trx_id
988: and nvl(app.confirmed_flag,'Y') = 'Y' --accounting exists in ar_distributions only if confirmed
989: and exists (select 'x'
990: from ar_distributions ard

Line 1023: FROM ar_receivable_applications ra

1019: END LOOP;
1020:
1021: --Now delete parent application record
1022: DELETE
1023: FROM ar_receivable_applications ra
1024: WHERE ra.customer_trx_id = p_customer_trx_id
1025: RETURNING receivable_application_id
1026: BULK COLLECT INTO l_rec_app_key_value_list;
1027:

Line 1037: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',

1033: +---------------------------------*/
1034:
1035: ar_mrc_engine.maintain_mrc_data(
1036: p_event_mode => 'DELETE',
1037: p_table_name => 'AR_RECEIVABLE_APPLICATIONS',
1038: p_mode => 'BATCH',
1039: p_key_value_list => l_rec_app_key_value_list);
1040:
1041: EXCEPTION

Line 1228: ar_receivable_applications ra2

1224: FROM
1225: ar_adjustments adj,
1226: ar_payment_schedules ps2,
1227: ar_adjustments adj2,
1228: ar_receivable_applications ra2
1229: WHERE adj.receivables_trx_id =-1
1230: and adj.customer_trx_id = p_customer_trx_id
1231: and adj.subsequent_trx_id = p_subsequent_trx_id
1232: and adj.payment_schedule_id = ps2.payment_schedule_id

Line 1378: ar_receivable_applications ra,

1374: p_profile_info.user_id,
1375: trunc(sysdate),
1376: p_profile_info.conc_login_id
1377: FROM
1378: ar_receivable_applications ra,
1379: ar_payment_schedules ps2,
1380: ar_adjustments adj2,
1381: ar_receivable_applications ra2
1382: WHERE ra.customer_trx_id = p_customer_trx_id

Line 1381: ar_receivable_applications ra2

1377: FROM
1378: ar_receivable_applications ra,
1379: ar_payment_schedules ps2,
1380: ar_adjustments adj2,
1381: ar_receivable_applications ra2
1382: WHERE ra.customer_trx_id = p_customer_trx_id
1383: and ra.status||'' = 'APP'
1384: and ra.applied_payment_schedule_id = ps2.payment_schedule_id
1385: and ps2.payment_schedule_id =ps.payment_schedule_id

Line 1411: FROM ar_receivable_applications ra3

1407: ra.receivables_charges_applied)
1408: WHERE ps.payment_schedule_id in
1409: (
1410: SELECT ra3.applied_payment_schedule_id
1411: FROM ar_receivable_applications ra3
1412: WHERE ra3.customer_trx_id = p_customer_trx_id
1413: and ra3.status='APP'
1414: )
1415: RETURNING ps.payment_schedule_id

Line 1462: from ar_receivable_applications app

1458: --BUG#5324129
1459: CURSOR del_app(p_app_id IN NUMBER) IS
1460: select app.receivable_application_id app_id,
1461: app.customer_trx_id trx_id
1462: from ar_receivable_applications app
1463: where app.applied_payment_schedule_id = p_control.payment_schedule_id --inv ps
1464: and app.customer_trx_id = p_control.customer_trx_id --cm trx id
1465: and nvl(app.confirmed_flag,'Y') = 'Y' --accounting exists in ar_distributions only if confirmed
1466: and app.reversal_gl_date IS NULL

Line 1477: from ar_receivable_applications app

1473: --BUG#5324129
1474: CURSOR cre_app(p_app_id IN NUMBER) IS
1475: select app.receivable_application_id app_id,
1476: app.customer_trx_id trx_id
1477: from ar_receivable_applications app
1478: where app.applied_payment_schedule_id = p_control.payment_schedule_id
1479: and app.customer_trx_id = p_control.customer_trx_id
1480: and nvl(app.confirmed_flag,'Y') = 'Y'
1481: and app.reversal_gl_date IS NULL

Line 1491: from ar_receivable_applications

1487:
1488: --BUG#5324129
1489: CURSOR cu_posted IS
1490: select *
1491: from ar_receivable_applications
1492: where applied_payment_schedule_id = p_control.payment_schedule_id
1493: and customer_trx_id = p_control.customer_trx_id
1494: and nvl(confirmed_flag,'Y') = 'Y'
1495: and reversal_gl_date IS NULL;

Line 1501: from ar_receivable_applications app

1497:
1498: CURSOR get_app_id(p_app_id IN NUMBER) IS
1499: select app.receivable_application_id,
1500: app.amount_applied
1501: from ar_receivable_applications app
1502: where app.applied_payment_schedule_id = p_control.payment_schedule_id
1503: and app.customer_trx_id = p_control.customer_trx_id
1504: and app.receivable_application_id = p_app_id;
1505:

Line 1531: old_rec_app ar_receivable_Applications%ROWTYPE;

1527: l_amount_applied NUMBER;
1528: l_ra_id NUMBER;
1529: l_del_app_rec del_app%ROWTYPE;
1530: l_cre_app_rec cre_app%ROWTYPE;
1531: old_rec_app ar_receivable_Applications%ROWTYPE;
1532: ins_ra_rec ar_receivable_Applications%ROWTYPE;
1533: no_app_found EXCEPTION;
1534:
1535: BEGIN

Line 1532: ins_ra_rec ar_receivable_Applications%ROWTYPE;

1528: l_ra_id NUMBER;
1529: l_del_app_rec del_app%ROWTYPE;
1530: l_cre_app_rec cre_app%ROWTYPE;
1531: old_rec_app ar_receivable_Applications%ROWTYPE;
1532: ins_ra_rec ar_receivable_Applications%ROWTYPE;
1533: no_app_found EXCEPTION;
1534:
1535: BEGIN
1536:

Line 1575: ar_receivable_applications ra

1571: l_inv_rate
1572: FROM
1573: ar_payment_schedules ps_cm,
1574: ar_payment_schedules ps_inv,
1575: ar_receivable_applications ra
1576: WHERE p_system_info.base_currency <> ps_inv.invoice_currency_code
1577: and ra.applied_payment_schedule_id = ps_inv.payment_schedule_id
1578: and ps_inv.payment_schedule_id = p_control.payment_schedule_id
1579: and ra.payment_schedule_id = ps_cm.payment_schedule_id

Line 1710: ar_receivable_applications ra,

1706: p_profile_info.user_id,
1707: trunc(sysdate),
1708: p_profile_info.conc_login_id
1709: FROM
1710: ar_receivable_applications ra,
1711: ar_payment_schedules ps2,
1712: ar_receivable_applications ra2,
1713: ar_adjustments adj2
1714: WHERE ra.customer_trx_id = p_control.customer_trx_id

Line 1712: ar_receivable_applications ra2,

1708: p_profile_info.conc_login_id
1709: FROM
1710: ar_receivable_applications ra,
1711: ar_payment_schedules ps2,
1712: ar_receivable_applications ra2,
1713: ar_adjustments adj2
1714: WHERE ra.customer_trx_id = p_control.customer_trx_id
1715: and ra.status||'' = 'APP'
1716: and ra.reversal_gl_date IS NULL

Line 1747: FROM ar_receivable_applications ra3

1743: ps2.exchange_rate)
1744: WHERE ps.payment_schedule_id in
1745: (
1746: SELECT ra3.applied_payment_schedule_id
1747: FROM ar_receivable_applications ra3
1748: WHERE ra3.customer_trx_id = p_control.customer_trx_id
1749: and ra3.status = 'APP'
1750: and ra3.applied_payment_schedule_id = p_control.payment_schedule_id
1751: and ra3.reversal_gl_date IS NULL

Line 1820: UPDATE ar_receivable_applications ra

1816: -- Update the CM application record to the correct amount
1817: ----------------------------------------------------------------
1818: arp_standard.debug('Update the CM app ra_id '|| old_rec_app.receivable_application_id || '+');
1819:
1820: UPDATE ar_receivable_applications ra
1821: SET
1822: acctd_amount_applied_from =
1823: decode(l_foreign_transaction,
1824: 'N',

Line 1982: UPDATE ar_receivable_applications

1978: arp_app_pkg.insert_p( ins_ra_rec, l_ra_id );
1979: arp_standard.debug('Reverse application inserted ra_id :'||l_ra_id);
1980:
1981: --Update the reversal app record reversal_gl_date
1982: UPDATE ar_receivable_applications
1983: SET reversal_gl_date = TRUNC(SYSDATE),
1984: display = 'N'
1985: WHERE receivable_application_id = old_rec_app.receivable_application_id;
1986:

Line 2112: from ar_receivable_applications app

2108:
2109: CURSOR del_app IS
2110: select app.receivable_application_id app_id,
2111: app.customer_trx_id trx_id
2112: from ar_receivable_applications app
2113: where app.applied_payment_schedule_id = p_control.payment_schedule_id
2114: and app.customer_trx_id = p_control.customer_trx_id
2115: and nvl(app.confirmed_flag,'Y') = 'Y' --accounting exists in ar_distributions only if confirmed
2116: and app.status = 'APP'

Line 2228: ar_receivable_applications ra

2224: l_new_adj_amount
2225: FROM
2226: ar_payment_schedules ps_cm,
2227: ar_payment_schedules ps_inv,
2228: ar_receivable_applications ra
2229: WHERE p_system_info.base_currency <> ps_inv.invoice_currency_code
2230: and ra.applied_payment_schedule_id = ps_inv.payment_schedule_id
2231: and ps_inv.payment_schedule_id = p_control.payment_schedule_id
2232: and ra.payment_schedule_id = ps_cm.payment_schedule_id

Line 2416: ar_receivable_applications ra,

2412: -3
2413: ,arp_standard.sysparm.org_id /* SSA changes anuj */
2414: FROM
2415: ar_adjustments adj2,
2416: ar_receivable_applications ra,
2417: ra_customer_trx ct
2418: WHERE adj2.receivables_trx_id= -1
2419: and adj2.customer_trx_id = p_control.previous_customer_trx_id
2420: and adj2.subsequent_trx_id = p_control.customer_trx_id

Line 2546: ar_receivable_applications ra,

2542: p_profile_info.user_id,
2543: trunc(sysdate),
2544: p_profile_info.conc_login_id
2545: FROM
2546: ar_receivable_applications ra,
2547: ra_customer_trx ct
2548: WHERE ra.customer_trx_id = p_control.customer_trx_id
2549: and ra.status||'' = 'APP'
2550: and ra.applied_payment_schedule_id = p_control.payment_schedule_id

Line 2691: ar_receivable_applications ra,

2687: p_profile_info.user_id,
2688: trunc(sysdate),
2689: p_profile_info.conc_login_id
2690: FROM
2691: ar_receivable_applications ra,
2692: ar_payment_schedules ps2,
2693: ar_receivable_applications ra2,
2694: ar_adjustments adj2
2695: WHERE ra.customer_trx_id = p_control.customer_trx_id

Line 2693: ar_receivable_applications ra2,

2689: p_profile_info.conc_login_id
2690: FROM
2691: ar_receivable_applications ra,
2692: ar_payment_schedules ps2,
2693: ar_receivable_applications ra2,
2694: ar_adjustments adj2
2695: WHERE ra.customer_trx_id = p_control.customer_trx_id
2696: and ra.status||'' = 'APP'
2697: and ra.applied_payment_schedule_id = ps2.payment_schedule_id

Line 2756: from ar_receivable_applications app

2752: DECLARE
2753: CURSOR get_app_id IS
2754: select app.receivable_application_id,
2755: app.amount_applied
2756: from ar_receivable_applications app
2757: where app.applied_payment_schedule_id = p_control.payment_schedule_id
2758: and app.customer_trx_id = p_control.customer_trx_id
2759: and app.status = 'APP';
2760:

Line 2783: UPDATE ar_receivable_applications ra

2779: arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
2780:
2781: END LOOP;
2782:
2783: UPDATE ar_receivable_applications ra
2784: SET
2785: acctd_amount_applied_from =
2786: decode(l_foreign_transaction,
2787: 'N',