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

Line 1441: FROM ar_receivable_applications

1437: END IF;
1438:
1439: SELECT cash_receipt_id
1440: INTO p_cash_receipt_id
1441: FROM ar_receivable_applications
1442: where receivable_application_id = (SELECT MAX(receivable_application_id)
1443: FROM ar_receivable_applications
1444: WHERE applied_customer_trx_id = p_customer_trx_id
1445: AND status = 'APP' );

Line 1443: FROM ar_receivable_applications

1439: SELECT cash_receipt_id
1440: INTO p_cash_receipt_id
1441: FROM ar_receivable_applications
1442: where receivable_application_id = (SELECT MAX(receivable_application_id)
1443: FROM ar_receivable_applications
1444: WHERE applied_customer_trx_id = p_customer_trx_id
1445: AND status = 'APP' );
1446:
1447: IF PG_DEBUG in ('Y', 'C') THEN

Line 1481: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE)

1477:
1478:
1479: PROCEDURE Find_Last_STD ( p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE ,
1480: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE ,
1481: p_receivable_application_id OUT NOCOPY ar_receivable_applications.receivable_application_id%TYPE)
1482:
1483: IS
1484:
1485: CURSOR last_std_application_cur IS

Line 1487: FROM ar_receivable_applications

1483: IS
1484:
1485: CURSOR last_std_application_cur IS
1486: SELECT receivable_application_id, cash_receipt_id
1487: FROM ar_receivable_applications
1488: WHERE link_to_customer_trx_id = p_customer_trx_id
1489: AND status = 'ACTIVITY'
1490: AND applied_payment_schedule_id = -2
1491: AND display = 'Y'

Line 1797: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE;

1793: l_msg_count NUMBER;
1794: l_msg_data VARCHAR2(2000);
1795: l_return_status VARCHAR2(1);
1796:
1797: l_receivables_trx_id ar_receivable_applications.receivables_trx_id%TYPE;
1798: l_cr_rec ar_cash_receipts%ROWTYPE;
1799:
1800: l_secondary_application_ref_id NUMBER:= NULL;
1801: l_application_ref_type VARCHAR2(30):= NULL;

Line 1804: ln_rec_application_id ar_receivable_applications.receivable_application_id%type;

1800: l_secondary_application_ref_id NUMBER:= NULL;
1801: l_application_ref_type VARCHAR2(30):= NULL;
1802: l_application_ref_id NUMBER:= NULL;
1803: l_application_ref_num VARCHAR2(30);
1804: ln_rec_application_id ar_receivable_applications.receivable_application_id%type;
1805:
1806: l_org_return_status VARCHAR2(1);
1807: l_org_id NUMBER;
1808: BEGIN

Line 1940: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

1936:
1937: IS
1938:
1939:
1940: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
1941:
1942: l_msg_count NUMBER;
1943: l_msg_data VARCHAR2(2000);
1944: l_return_status VARCHAR2(1);

Line 2055: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;

2051: l_adj_id ar_adjustments.adjustment_id%TYPE ;
2052: l_batch_rec ar_batches%ROWTYPE ;
2053: l_called_from VARCHAR2(30) := NULL ;
2054: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE ;
2055: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2056: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE ;
2057:
2058: BEGIN
2059:

Line 2711: FROM ar_receivable_applications

2707: IS
2708:
2709: CURSOR last_application_cur IS
2710: SELECT receivable_application_id
2711: FROM ar_receivable_applications
2712: WHERE applied_customer_trx_id = p_trh_rec.customer_trx_id
2713: AND status = 'APP'
2714: AND display = 'Y'
2715: ORDER BY receivable_application_id DESC;

Line 2759: UPDATE ar_receivable_applications

2755: | Update the LINK_TO_TRX_HIST_ID on the |
2756: | application |
2757: +-----------------------------------------------*/
2758:
2759: UPDATE ar_receivable_applications
2760: SET LINK_TO_TRX_HIST_ID = p_trh_rec.transaction_history_id
2761: WHERE receivable_application_id = last_application_rec.receivable_application_id;
2762:
2763: