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 RA_CUSTOMER_TRX

Line 2892: from ra_customer_trx_lines line,

2888: into
2889: l_line_number,
2890: l_line_amount_remaining,
2891: l_line_tax_remaining
2892: from ra_customer_trx_lines line,
2893: (select link_to_cust_trx_line_id,
2894: line_type,
2895: sum(nvl(amount_due_original,0)) amount_due_original,
2896: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 2897: from ra_customer_trx_lines

2893: (select link_to_cust_trx_line_id,
2894: line_type,
2895: sum(nvl(amount_due_original,0)) amount_due_original,
2896: sum(nvl(amount_due_remaining,0)) amount_due_remaining
2897: from ra_customer_trx_lines
2898: where customer_trx_id = sp_lines_row.customer_trx_id -- Bug 7241703 Added condition
2899: and nvl(line_type,'TAX') = 'TAX'
2900: group by link_to_cust_trx_line_id,line_type
2901: ) tax

Line 3533: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

3529: raise;
3530: END Default_disc_and_amt_applied;
3531:
3532: FUNCTION Get_trx_Line_amount(
3533: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3534: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3535: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
3536: p_return_status OUT NOCOPY VARCHAR2
3537: ) RETURN NUMBER IS

Line 3535: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,

3531:
3532: FUNCTION Get_trx_Line_amount(
3533: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3534: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3535: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
3536: p_return_status OUT NOCOPY VARCHAR2
3537: ) RETURN NUMBER IS
3538:
3539: l_trx_line_amount NUMBER;

Line 3548: FROM ra_customer_trx_lines ctl ,

3544:
3545: SELECT ctl.extended_amount *
3546: nvl(tl.relative_amount,1)/ nvl(t.base_amount,1)
3547: INTO l_trx_line_amount
3548: FROM ra_customer_trx_lines ctl ,
3549: ra_terms t ,
3550: ra_terms_lines tl ,
3551: ar_payment_schedules ps
3552: WHERE ps.payment_schedule_id = p_payment_schedule_id and

Line 3579: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

3575: END Get_trx_Line_amount;
3576:
3577:
3578: PROCEDURE Default_Trx_Info(
3579: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3580: p_customer_trx_line_id IN NUMBER,
3581: p_show_closed_invoices IN VARCHAR2,
3582: p_cr_gl_date IN DATE,
3583: p_cr_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,

Line 3589: p_cust_trx_type_id OUT NOCOPY ra_customer_trx.cust_trx_type_id%TYPE ,

3585: p_cr_payment_schedule_id IN NUMBER,
3586: p_cr_date IN DATE,
3587: p_called_from IN VARCHAR2,
3588: p_customer_id OUT NOCOPY NUMBER, --customer on transaction
3589: p_cust_trx_type_id OUT NOCOPY ra_customer_trx.cust_trx_type_id%TYPE ,
3590: p_trx_due_date OUT NOCOPY DATE,
3591: p_trx_currency_code OUT NOCOPY VARCHAR2,
3592: p_trx_exchange_rate OUT NOCOPY NUMBER,
3593: p_trx_date OUT NOCOPY DATE,

Line 3731: ra_customer_trx ct

3727: p_rec_charges_charged,
3728: p_rec_charges_remaining,
3729: l_location
3730: FROM
3731: ra_customer_trx ct
3732: , ra_cust_trx_types ctt
3733: , hz_cust_site_uses su
3734: , ra_batch_sources bs
3735: , ar_lookups lu

Line 3828: ra_customer_trx ct

3824: p_rec_charges_charged,
3825: p_rec_charges_remaining,
3826: l_location
3827: FROM
3828: ra_customer_trx ct
3829: , ra_cust_trx_types ctt
3830: , hz_cust_site_uses su
3831: , ra_batch_sources bs
3832: , ar_lookups lu

Line 4423: FROM ra_customer_trx

4419: IF p_trx_number IS NOT NULL THEN
4420: BEGIN
4421: SELECT customer_trx_id
4422: INTO p_customer_trx_id
4423: FROM ra_customer_trx
4424: WHERE trx_number = p_trx_number;
4425: EXCEPTION
4426: WHEN no_data_found THEN
4427: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_INVALID');

Line 4470: from ra_customer_trx_lines line

4466: p_return_status := FND_API.G_RET_STS_SUCCESS;
4467:
4468: select count(1)
4469: into l_count
4470: from ra_customer_trx_lines line
4471: where line.customer_Trx_id = p_customer_trx_id
4472: and line.line_type = 'LINE'
4473: and line.source_data_key4 = p_group_id
4474: and rownum = 1;

Line 4526: FROM ra_customer_trx_lines

4522: IF p_line_number IS NOT NULL THEN
4523: BEGIN
4524: SELECT customer_trx_line_id
4525: INTO p_customer_trx_line_id
4526: FROM ra_customer_trx_lines
4527: WHERE customer_trx_id = p_customer_trx_id
4528: AND line_number = p_line_number
4529: AND line_type = 'LINE';
4530: EXCEPTION

Line 4545: FROM ra_customer_trx_lines

4541: IF p_customer_trx_line_id IS NOT NULL THEN
4542: BEGIN
4543: SELECT customer_trx_id
4544: INTO p_customer_trx_id
4545: FROM ra_customer_trx_lines
4546: WHERE customer_trx_line_id = p_customer_trx_line_id
4547: AND line_type = 'LINE';
4548: EXCEPTION
4549: WHEN no_data_found THEN

Line 4575: FROM ra_customer_trx_lines

4571: Then
4572: BEGIN
4573: SELECT customer_trx_line_id
4574: INTO l_cust_trx_line_id
4575: FROM ra_customer_trx_lines
4576: WHERE customer_trx_id = p_customer_trx_id
4577: AND line_number = i.line_number
4578: AND line_type = 'LINE';
4579:

Line 4600: FROM ra_customer_trx_lines

4596: Else
4597: BEGIN
4598: SELECT customer_trx_line_id
4599: INTO l_cust_trx_line_id
4600: FROM ra_customer_trx_lines
4601: WHERE customer_trx_id = p_customer_trx_id
4602: AND customer_trx_line_id = i.customer_trx_line_id
4603: AND line_type = 'LINE';
4604: EXCEPTION

Line 4863: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

4859: p_cr_date OUT NOCOPY DATE,
4860: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4861: p_cr_unapp_amount OUT NOCOPY NUMBER,
4862: p_cr_currency_code OUT NOCOPY VARCHAR2,
4863: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
4864: p_installment IN OUT NOCOPY NUMBER,
4865: p_show_closed_invoices IN VARCHAR2,
4866: p_customer_trx_line_id IN NUMBER,
4867: p_trx_due_date OUT NOCOPY DATE,

Line 5328: FROM ra_customer_trx ct,

5324: IF p_installment IS NOT NULL THEN
5325: BEGIN
5326: SELECT ps.payment_schedule_id
5327: INTO l_trx_ps_id
5328: FROM ra_customer_trx ct,
5329: ar_payment_schedules ps
5330: WHERE ct.customer_trx_id = p_customer_trx_id
5331: AND ct.customer_trx_id = ps.customer_trx_id
5332: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')

Line 5356: FROM ra_customer_trx ct,

5352: --has only one installment, get the ps_id for that installment
5353: BEGIN
5354: SELECT ps.payment_schedule_id
5355: INTO l_trx_ps_id
5356: FROM ra_customer_trx ct,
5357: ar_payment_schedules ps
5358: WHERE ct.customer_trx_id = p_customer_trx_id
5359: AND ct.customer_trx_id = ps.customer_trx_id
5360: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')

Line 5381: FROM ra_customer_trx ct,

5377: IF p_installment IS NOT NULL THEN
5378: BEGIN
5379: SELECT ps.payment_schedule_id
5380: INTO l_trx_ps_id
5381: FROM ra_customer_trx ct,
5382: ar_payment_schedules ps
5383: WHERE ct.customer_trx_id = p_customer_trx_id
5384: AND ct.customer_trx_id = ps.customer_trx_id
5385: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')

Line 5410: FROM ra_customer_trx ct,

5406: --has only one installment, get the ps_id for that installment
5407: BEGIN
5408: SELECT ps.payment_schedule_id
5409: INTO l_trx_ps_id
5410: FROM ra_customer_trx ct,
5411: ar_payment_schedules ps
5412: WHERE ct.customer_trx_id = p_customer_trx_id
5413: AND ct.customer_trx_id = ps.customer_trx_id
5414: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')

Line 5629: l_ra_customer_trx_id NUMBER;

5625: p_apply_gl_date OUT NOCOPY DATE,
5626: p_return_status OUT NOCOPY VARCHAR2
5627: ) IS
5628: l_customer_trx_id NUMBER;
5629: l_ra_customer_trx_id NUMBER;
5630: l_installment NUMBER(15);
5631: l_ra_app_ps_id NUMBER;
5632: l_applied_payment_schedule_id NUMBER;
5633: l_receivable_application_id NUMBER;

Line 6864: p_trx_number IN ra_customer_trx.trx_number%TYPE,

6860:
6861: /* modified for tca uptake */
6862: PROCEDURE Derive_cust_info_from_trx(
6863: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
6864: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6865: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6866: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6867: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6868: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,

Line 8198: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE

8194: END get_legal_entity;
8195:
8196: PROCEDURE default_refund_attributes (
8197: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
8198: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
8199: ,p_currency_code IN fnd_currencies.currency_code%TYPE
8200: ,p_amount IN NUMBER
8201: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
8202: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE

Line 8274: FROM ra_customer_trx

8270: x_exchange_date,
8271: l_org_id,
8272: l_cust_acct_id,
8273: l_site_use_id
8274: FROM ra_customer_trx
8275: WHERE customer_trx_id = p_customer_trx_id;
8276: END IF;
8277: IF p_party_id IS NULL THEN
8278: BEGIN