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

Line 3918: from ar_receivable_applications rap

3914: BEGIN
3915: IF p_customer_trx_line_id IS NULL THEN
3916: select 'Y'
3917: into l_found
3918: from ar_receivable_applications rap
3919: where rap.payment_schedule_id = p_cr_payment_schedule_id
3920: and rap.applied_payment_schedule_id = p_applied_payment_schedule_id
3921: and applied_customer_trx_line_id is NULL
3922: and rap.display = 'Y'

Line 3927: from ar_receivable_applications rap

3923: and rap.status = 'APP';
3924: ELSE
3925: select 'Y'
3926: into l_found
3927: from ar_receivable_applications rap
3928: where rap.payment_schedule_id = p_cr_payment_schedule_id
3929: and rap.applied_payment_schedule_id = p_applied_payment_schedule_id
3930: and rap.applied_customer_trx_line_id = p_customer_trx_line_id
3931: and rap.display = 'Y'

Line 4120: FROM ar_receivable_applications ra

4116: END;
4117:
4118: SELECT SUM(NVL(ra.amount_applied,0))
4119: INTO p_cr_unapp_amount
4120: FROM ar_receivable_applications ra
4121: WHERE ra.status = 'UNAPP'
4122: AND ra.cash_receipt_id = p_cash_receipt_id;
4123:
4124: ELSE

Line 5197: FROM ar_receivable_applications ra

5193: SELECT receivable_application_id, gl_date
5194: ,applied_customer_trx_id
5195: INTO p_receivable_application_id, p_apply_gl_date
5196: ,p_customer_trx_id
5197: FROM ar_receivable_applications ra
5198: WHERE ra.cash_receipt_id = p_cash_receipt_id
5199: AND ra.applied_payment_schedule_id = p_applied_payment_schedule_id
5200: AND ra.display = 'Y'
5201: AND ra.status = 'APP'

Line 5292: FROM ar_receivable_applications ra,

5288: ) IS
5289: CURSOR rec_apppln IS
5290: SELECT ra.cash_receipt_id, ra.applied_payment_schedule_id, ra.gl_date /* Bug fix 3451241 */
5291: , ra.applied_customer_trx_id
5292: FROM ar_receivable_applications ra,
5293: ar_payment_schedules ps
5294: WHERE ra.applied_payment_schedule_id = ps.payment_schedule_id
5295: AND ra.receivable_application_id = p_ra_id
5296: AND ra.display = 'Y'

Line 5304: FROM ar_receivable_applications ra

5300:
5301: CURSOR rec_apppln_br_remit IS
5302: SELECT ra.cash_receipt_id, ra.applied_payment_schedule_id, ra.gl_date /* Bug fix 3451241 */
5303: , ra.applied_customer_trx_id
5304: FROM ar_receivable_applications ra
5305: WHERE ra.receivable_application_id = p_ra_id
5306: AND ra.display = 'Y'
5307: AND ra.status = 'APP';
5308:

Line 5555: FROM ar_receivable_applications

5551: IF p_apply_gl_date IS NULL THEN
5552: --get the gl_date for the application
5553: SELECT gl_date, cash_receipt_id
5554: INTO l_apply_gl_date, p_cash_receipt_id
5555: FROM ar_receivable_applications
5556: WHERE receivable_application_id =
5557: p_receivable_application_id;
5558: END IF;
5559: /* Bug fix 3503167 : We need to pass the apply_gl_date as the candidate gl_date and

Line 5627: FROM ar_receivable_applications ra

5623: /* Default p_cr_unapp_amount for 3119391 */
5624:
5625: SELECT SUM(NVL(ra.amount_applied,0))
5626: INTO p_cr_unapp_amount
5627: FROM ar_receivable_applications ra
5628: WHERE ra.status = 'UNAPP'
5629: AND ra.cash_receipt_id = l_cash_receipt_id;
5630:
5631: --default the receipt gl date which is to be used later

Line 6020: FROM ar_receivable_applications

6016:
6017: BEGIN
6018: SELECT receivable_application_id, gl_date
6019: INTO l_rec_appln_id , p_apply_gl_date
6020: FROM ar_receivable_applications
6021: WHERE cash_receipt_id = p_cash_receipt_id
6022: AND display = 'Y'
6023: AND status = 'ACC';
6024: EXCEPTION

Line 6045: FROM ar_receivable_applications

6041:
6042: BEGIN
6043: SELECT cash_receipt_id, gl_date
6044: INTO l_cash_receipt_id , p_apply_gl_date
6045: FROM ar_receivable_applications
6046: WHERE receivable_application_id = p_receivable_application_id
6047: and display = 'Y'
6048: and status = 'ACC';
6049: EXCEPTION

Line 6114: FROM ar_receivable_applications

6110:
6111: BEGIN
6112: SELECT receivable_application_id, gl_date
6113: INTO l_rec_appln_id , p_apply_gl_date
6114: FROM ar_receivable_applications
6115: WHERE cash_receipt_id = p_cash_receipt_id
6116: AND applied_payment_schedule_id = p_applied_ps_id
6117: AND display = 'Y'
6118: AND status = 'OTHER ACC';

Line 6140: FROM ar_receivable_applications

6136:
6137: BEGIN
6138: SELECT cash_receipt_id, gl_date
6139: INTO l_cash_receipt_id , p_apply_gl_date
6140: FROM ar_receivable_applications
6141: WHERE receivable_application_id = p_receivable_application_id
6142: and display = 'Y'
6143: and applied_payment_schedule_id = p_applied_ps_id
6144: and status = 'OTHER ACC';

Line 6174: FROM ar_receivable_applications ra

6170: /* Bug fix 3569640 */
6171: IF p_cash_receipt_id IS NOT NULL THEN
6172: SELECT SUM(NVL(ra.amount_applied,0))
6173: INTO p_cr_unapp_amt
6174: FROM ar_receivable_applications ra
6175: WHERE ra.cash_receipt_id = p_cash_receipt_id
6176: AND ra.status = 'UNAPP'
6177: AND nvl(ra.confirmed_flag,'Y') = 'Y';
6178: END IF;

Line 6302: FROM ar_receivable_applications

6298:
6299: BEGIN
6300: SELECT receivable_application_id, gl_date
6301: INTO l_rec_appln_id , p_apply_gl_date
6302: FROM ar_receivable_applications
6303: WHERE cash_receipt_id = p_cash_receipt_id
6304: and ((NVL(p_called_from,'RAPI') = 'BR_FACTORED_WITH_RECOURSE' AND
6305: applied_payment_schedule_id = -2)
6306: or applied_payment_schedule_id IN (-3,-6,-8)

Line 6343: FROM ar_receivable_applications

6339: /* Bug 3840287 - credit card refund included */
6340: BEGIN
6341: SELECT cash_receipt_id, gl_date
6342: INTO l_cash_receipt_id , p_apply_gl_date
6343: FROM ar_receivable_applications
6344: WHERE receivable_application_id = p_receivable_application_id
6345: and ((NVL(p_called_from,'RAPI') = 'BR_FACTORED_WITH_RECOURSE' AND
6346: applied_payment_schedule_id = -2)
6347: or applied_payment_schedule_id IN (-3,-6,-8)

Line 6380: FROM ar_receivable_applications ra

6376: /* Bug fix 3569640 */
6377: IF p_cash_receipt_id IS NOT NULL THEN
6378: SELECT SUM(NVL(ra.amount_applied,0))
6379: INTO p_cr_unapp_amount
6380: FROM ar_receivable_applications ra
6381: WHERE ra.cash_receipt_id = p_cash_receipt_id
6382: AND ra.status = 'UNAPP'
6383: AND nvl(ra.confirmed_flag,'Y') = 'Y';
6384: END IF;

Line 7663: l_status ar_receivable_applications.status%TYPE;

7659: l_cr_unapp_amount NUMBER;
7660: l_cr_payment_schedule_id NUMBER;
7661: l_remit_bank_acct_use_id NUMBER;
7662: l_receipt_method_id NUMBER;
7663: l_status ar_receivable_applications.status%TYPE;
7664: l_display ar_receivable_applications.display%TYPE;
7665:
7666: BEGIN
7667:

Line 7664: l_display ar_receivable_applications.display%TYPE;

7660: l_cr_payment_schedule_id NUMBER;
7661: l_remit_bank_acct_use_id NUMBER;
7662: l_receipt_method_id NUMBER;
7663: l_status ar_receivable_applications.status%TYPE;
7664: l_display ar_receivable_applications.display%TYPE;
7665:
7666: BEGIN
7667:
7668: IF PG_DEBUG in ('Y', 'C') THEN

Line 7721: FROM ar_receivable_applications

7717: x_customer_reference,
7718: x_customer_reason,
7719: l_status,
7720: l_display
7721: FROM ar_receivable_applications
7722: WHERE receivable_application_id = p_open_rec_app_id ;
7723: EXCEPTION
7724: WHEN no_data_found THEN
7725: FND_MESSAGE.SET_NAME('AR','AR_RAPI_REC_APP_ID_INVALID');

Line 7762: FROM ar_receivable_applications

7758: END IF;
7759:
7760: SELECT SUM(amount_applied)
7761: INTO x_unapplied_cash
7762: FROM ar_receivable_applications
7763: WHERE cash_receipt_id = p_cash_receipt_id
7764: AND status = 'UNAPP';
7765:
7766: IF p_open_rec_app_id IS NULL

Line 7770: FROM ar_receivable_applications

7766: IF p_open_rec_app_id IS NULL
7767: THEN
7768: SELECT SUM(amount_applied)
7769: INTO x_open_amount_applied
7770: FROM ar_receivable_applications
7771: WHERE cash_receipt_id = p_open_cash_receipt_id
7772: AND status = 'UNAPP';
7773: END IF;
7774:

Line 7857: FROM ar_receivable_applications app,

7853: app.amount_applied
7854: INTO x_applied_rec_app_id,
7855: x_applied_cash_receipt_id,
7856: x_amount_applied
7857: FROM ar_receivable_applications app,
7858: ar_receivable_applications applied_app
7859: WHERE app.applied_rec_app_id = applied_app.receivable_application_id
7860: AND app.receivable_application_id = p_receivable_application_id;
7861:

Line 7858: ar_receivable_applications applied_app

7854: INTO x_applied_rec_app_id,
7855: x_applied_cash_receipt_id,
7856: x_amount_applied
7857: FROM ar_receivable_applications app,
7858: ar_receivable_applications applied_app
7859: WHERE app.applied_rec_app_id = applied_app.receivable_application_id
7860: AND app.receivable_application_id = p_receivable_application_id;
7861:
7862: IF PG_DEBUG in ('Y', 'C') THEN