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.FV_LOCKBOX_FC_PKG dependencies on AR_INTERIM_CASH_RECEIPTS

Line 23: v_transaction_code ar_interim_cash_receipts.ussgl_transaction_code%TYPE;

19: v_payment_schedule_id ar_payment_schedules.payment_schedule_id%TYPE;
20: v_appl_inv_id ra_customer_trx.customer_trx_id%TYPE;
21: v_appl_inv_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
22: v_sold_to_customer ar_interim_cash_rcpt_lines_all.sold_to_customer%TYPE;
23: v_transaction_code ar_interim_cash_receipts.ussgl_transaction_code%TYPE;
24: v_appl_inv_amt number;
25: v_appl_amt_remain number;
26: v_appl_dm_id fv_lockbox_ipa_temp.debit_memo_id%TYPE;
27: v_dm_amt fv_lockbox_ipa_temp.amount%TYPE;

Line 58: from ar_interim_cash_receipts a,

54: cv_org_id ar_batches.org_id%TYPE) is
55: /*
56: select distinct(decode(a.customer_trx_id,null,b.customer_trx_id,
57: a.customer_trx_id)) customer_trx_id
58: from ar_interim_cash_receipts a,
59: ar_interim_cash_rcpt_lines_all b
60: where a.batch_id = cv_batch_id
61: and a.cash_receipt_id = b.cash_receipt_id (+)
62: and(a.customer_trx_id is not null or b.customer_trx_id is not null);

Line 65: from ar_interim_cash_receipts

61: and a.cash_receipt_id = b.cash_receipt_id (+)
62: and(a.customer_trx_id is not null or b.customer_trx_id is not null);
63: */
64: select distinct(customer_trx_id) customer_trx_id
65: from ar_interim_cash_receipts
66: where batch_id = cv_batch_id
67: and customer_trx_id is not null
68: union
69: select distinct(customer_trx_id) customer_trx_id

Line 91: cv_org_id ar_interim_cash_receipts.org_id%TYPE) is

87: and aps.amount_due_remaining > 0
88: order by fcc.priority ;
89:
90: cursor c_receipt_dms(cv_batch_id ar_batches.batch_id%TYPE,
91: cv_org_id ar_interim_cash_receipts.org_id%TYPE) is
92: select sum(amount) amount,
93: aicr.customer_trx_id,
94: aicr.payment_schedule_id
95: from ar_interim_cash_receipts aicr,

Line 95: from ar_interim_cash_receipts aicr,

91: cv_org_id ar_interim_cash_receipts.org_id%TYPE) is
92: select sum(amount) amount,
93: aicr.customer_trx_id,
94: aicr.payment_schedule_id
95: from ar_interim_cash_receipts aicr,
96: ra_customer_trx rct,
97: fv_finance_charge_controls fcc
98: where aicr.batch_id = cv_batch_id
99: and aicr.customer_trx_id is not null

Line 121: cv_org_id ar_interim_cash_receipts.org_id%TYPE) is

117: group by aicrl.customer_trx_id, aicrl.payment_schedule_id;
118:
119:
120: cursor c_receipt_details(cv_batch_id ar_batches.batch_id%TYPE,
121: cv_org_id ar_interim_cash_receipts.org_id%TYPE) is
122: select customer_trx_id, aicr.amount amount, 'R' origin,
123: cash_receipt_id, 0 cash_receipt_line_id, payment_schedule_id,
124: 0 sold_to_customer, ussgl_transaction_code
125: from ar_interim_cash_receipts aicr

Line 125: from ar_interim_cash_receipts aicr

121: cv_org_id ar_interim_cash_receipts.org_id%TYPE) is
122: select customer_trx_id, aicr.amount amount, 'R' origin,
123: cash_receipt_id, 0 cash_receipt_line_id, payment_schedule_id,
124: 0 sold_to_customer, ussgl_transaction_code
125: from ar_interim_cash_receipts aicr
126: where batch_id = cv_batch_id
127: and customer_trx_id is not null
128: and exists (select 'x' from fv_lockbox_ipa_temp f
129: where f.invoice_id = aicr.customer_trx_id

Line 389: -- when a receipt comes from ar_interim_cash_receipts table

385: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'AMT REMAIN < DM AMT');
386: END IF;
387:
388: IF v_origin = 'R' THEN
389: -- when a receipt comes from ar_interim_cash_receipts table
390: -- and we want to update it and apply it to a debit memo, because
391: -- of form validation we must instead do the following:
392: -- move the invoice appl record to the interim lines table and
393: -- update the original record so that it is 'MULTIPLE' and not

Line 400: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');

396: insert_cash_receipt(v_appl_dm_id, v_dm_pay_sch_id,
397: v_appl_amt_remain, null);
398:
399: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
400: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');
401: END IF;
402: update ar_interim_cash_receipts
403: set customer_trx_id = null,
404: payment_schedule_id = null,

Line 402: update ar_interim_cash_receipts

398:
399: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
400: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');
401: END IF;
402: update ar_interim_cash_receipts
403: set customer_trx_id = null,
404: payment_schedule_id = null,
405: special_type = 'MULTIPLE',
406: amount_applied = null,

Line 451: -- when a receipt comes from ar_interim_cash_receipts table

447: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'3RD BRANCH');
448: END IF;
449:
450: IF v_origin = 'R' THEN
451: -- when a receipt comes from ar_interim_cash_receipts table
452: -- and we want to update it and apply it to a debit memo, because
453: -- of form validation we must instead do the following:
454: -- move the invoice appl record to the interim lines table and
455: -- update the original record so that it is 'MULTIPLE' and not

Line 462: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');

458: insert_cash_receipt(v_appl_inv_id, v_appl_inv_ps_id,
459: v_appl_amt_remain, v_transaction_code);
460:
461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
462: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');
463: END IF;
464: update ar_interim_cash_receipts
465: set customer_trx_id = null,
466: payment_schedule_id = null,

Line 464: update ar_interim_cash_receipts

460:
461: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
462: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'UPDATE AR_INTERIM_CASH_RECEIPTS TO MULTIPLE');
463: END IF;
464: update ar_interim_cash_receipts
465: set customer_trx_id = null,
466: payment_schedule_id = null,
467: special_type = 'MULTIPLE',
468: amount_applied = null,

Line 619: -- record is in ar_interim_cash_receipts or a 'L' if the receipt record

615: -- amount (meaning we have paid off some portion of debit memo(s), then
616: -- the orginal application receipt record must be updated with the amount
617: -- remaining on the receipt and the debit memo being paid off.
618: -- V_table will contain a 'R' if the receipt
619: -- record is in ar_interim_cash_receipts or a 'L' if the receipt record
620: -- is in ar_interim_cash_rcpt_lines_all.
621: -- ------------------------------------------------------------------------
622:
623: PROCEDURE update_interim_table(v_table IN VARCHAR2,