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_AUTOREC_API dependencies on AR_RECEIVABLE_APPLICATIONS

Line 125: update ar_receivable_applications SET

121: IF PG_DEBUG in ('Y','C') THEN
122: arp_debug.debug ( 'NO of Receipts updated PS = '|| to_char(SQL%ROWCOUNT));
123: END IF;
124:
125: update ar_receivable_applications SET
126: created_by = pg_created_by,
127: last_update_date = sysdate,
128: last_updated_by = pg_created_by,
129: last_update_login = pg_last_update_login,

Line 147: ar_receivable_applications ra,

143: set selected_for_receipt_batch_id = NULL
144: where payment_schedule_id in
145: ( select /*+ unnest */ r.payment_schedule_id
146: from ar_receipts_gt r,
147: ar_receivable_applications ra,
148: ra_customer_trx ct,
149: ar_receipt_methods rm,
150: ar_receipt_classes rc
151: where r.gt_id = p_gt_id

Line 181: ar_receivable_applications ra

177: l_to_doc_id,
178: l_from_ra_doc_id,
179: l_to_ra_doc_id
180: from AR_RECEIPTS_GT gt,
181: ar_receivable_applications ra
182: where gt.cash_receipt_id = ra.cash_receipt_id
183: and gt_id = p_gt_id;
184:
185: IF PG_DEBUG in ('Y','C') THEN

Line 225: ar_receivable_applications ra

221: max(ra.receivable_application_id)
222: into l_from_ra_doc_id,
223: l_to_ra_doc_id
224: from AR_RECEIPTS_GT gt,
225: ar_receivable_applications ra
226: where gt.cash_receipt_id = ra.cash_receipt_id
227: and gt_id = p_gt_id
228: and ra.event_id is null ;
229:

Line 2636: from ar_receivable_applications

2632: from ar_distributions
2633: where source_table = 'RA'
2634: and source_id in
2635: ( select receivable_application_id
2636: from ar_receivable_applications
2637: where cash_receipt_id in
2638: ( select distinct ex.cash_receipt_id
2639: from ar_autorec_exceptions ex,
2640: ar_receipts_gt r

Line 2651: from ar_receivable_applications

2647: arp_debug.debug ( ' rows DELETED AR_DIST2 = ' || SQL%ROWCOUNT );
2648: END IF;
2649:
2650: delete
2651: from ar_receivable_applications
2652: where cash_receipt_id in
2653: ( select distinct ex.cash_receipt_id
2654: from ar_autorec_exceptions ex,
2655: ar_receipts_gt r

Line 2773: ar_receivable_applications ra,

2769: SET seq_type_last = 'Y'
2770: WHERE cash_receipt_id IN (
2771: SELECT crh.cash_receipt_id
2772: FROM ar_cash_receipt_history crh,
2773: ar_receivable_applications ra,
2774: ra_customer_trx ct,
2775: iby_fndcpt_tx_extensions ext
2776: WHERE crh.batch_id = p_batch_id
2777: AND crh.current_record_flag = 'Y'

Line 3961: FROM ar_receivable_applications ra,

3957:
3958: CURSOR unbal_rec_applns( p_cr_id NUMBER, p_gt_id NUMBER) IS
3959: SELECT ard.source_id, ard.source_id_secondary, trx.upgrade_method,
3960: ra.applied_customer_trx_id, ra.payment_schedule_id, ra.applied_payment_schedule_id
3961: FROM ar_receivable_applications ra,
3962: ar_distributions ard,
3963: ra_customer_trx trx,
3964: ar_receipts_gt rgt
3965: WHERE ra.cash_receipt_id = p_cr_id

Line 4548: from ar_receivable_applications

4544: delete from ar_distributions
4545: where source_table = 'RA'
4546: and source_id in
4547: ( select receivable_application_id
4548: from ar_receivable_applications
4549: where cash_receipt_id = l_receipt_id_array(j));
4550:
4551: IF PG_DEBUG in ('Y','C') THEN
4552: arp_standard.debug ( ' rows DELETED AR_DIST2 = ' || SQL%ROWCOUNT );

Line 4555: delete from ar_receivable_applications

4551: IF PG_DEBUG in ('Y','C') THEN
4552: arp_standard.debug ( ' rows DELETED AR_DIST2 = ' || SQL%ROWCOUNT );
4553: END IF;
4554:
4555: delete from ar_receivable_applications
4556: where cash_receipt_id = l_receipt_id_array(j);
4557:
4558: IF PG_DEBUG in ('Y','C') THEN
4559: arp_standard.debug ( ' rows DELETED REC_APPS = ' || SQL%ROWCOUNT );

Line 4908: FROM AR_RECEIVABLE_APPLICATIONS RA1

4904: NVL(PS.DISCOUNT_REMAINING, 0)
4905: + NVL(RA1.EARNED_DISCOUNT_TAKEN, 0),
4906: NVL(PS.DISCOUNT_TAKEN_EARNED, 0)
4907: - NVL(RA1.EARNED_DISCOUNT_TAKEN, 0)
4908: FROM AR_RECEIVABLE_APPLICATIONS RA1
4909: WHERE RA1.APPLIED_PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID
4910: AND RA1.CASH_RECEIPT_ID = l_unbal_rcpt_tab(i).cash_receipt_id
4911: AND RA1.RECEIVABLE_APPLICATION_ID = unbal_rec_appln.source_id_secondary )
4912: WHERE PS.PAYMENT_SCHEDULE_ID = unbal_rec_appln.applied_payment_schedule_id;

Line 4931: FROM AR_RECEIVABLE_APPLICATIONS RA1

4927: DECODE((NVL(PS.AMOUNT_DUE_REMAINING, 0) - NVL(RA1.AMOUNT_APPLIED, 0)),
4928: 0, PS.GL_DATE_CLOSED, to_date('12/31/4712', 'MM/DD/YYYY')),
4929: DECODE((NVL(PS.AMOUNT_DUE_REMAINING, 0) - NVL(RA1.AMOUNT_APPLIED, 0)),
4930: 0, PS.ACTUAL_DATE_CLOSED, to_date('12/31/4712', 'MM/DD/YYYY'))
4931: FROM AR_RECEIVABLE_APPLICATIONS RA1
4932: WHERE RA1.PAYMENT_SCHEDULE_ID = PS.PAYMENT_SCHEDULE_ID
4933: AND RA1.RECEIVABLE_APPLICATION_ID = unbal_rec_appln.source_id_secondary )
4934: WHERE PS.PAYMENT_SCHEDULE_ID = unbal_rec_appln.payment_schedule_id;
4935:

Line 4943: DELETE FROM AR_RECEIVABLE_APPLICATIONS WHERE RECEIVABLE_APPLICATION_ID IN

4939: unbal_rec_appln.source_id_secondary)
4940: AND SOURCE_TABLE = 'RA';
4941:
4942: arp_standard.debug('Delete Application Entries');
4943: DELETE FROM AR_RECEIVABLE_APPLICATIONS WHERE RECEIVABLE_APPLICATION_ID IN
4944: (unbal_rec_appln.source_id,
4945: unbal_rec_appln.source_id_secondary);
4946:
4947: arp_standard.debug('Reset Invoice Line Level Balances If maintained on the invoice');