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 2789: from ra_customer_trx_lines line,

2785: into
2786: l_line_number,
2787: l_line_amount_remaining,
2788: l_line_tax_remaining
2789: from ra_customer_trx_lines line,
2790: (select link_to_cust_trx_line_id,
2791: line_type,
2792: sum(nvl(amount_due_original,0)) amount_due_original,
2793: sum(nvl(amount_due_remaining,0)) amount_due_remaining

Line 2794: from ra_customer_trx_lines

2790: (select link_to_cust_trx_line_id,
2791: line_type,
2792: sum(nvl(amount_due_original,0)) amount_due_original,
2793: sum(nvl(amount_due_remaining,0)) amount_due_remaining
2794: from ra_customer_trx_lines
2795: where customer_trx_id = sp_lines_row.customer_trx_id -- Bug 7241703 Added condition
2796: and nvl(line_type,'TAX') = 'TAX'
2797: group by link_to_cust_trx_line_id,line_type
2798: ) tax

Line 3351: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

3347: raise;
3348: END Default_disc_and_amt_applied;
3349:
3350: FUNCTION Get_trx_Line_amount(
3351: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3352: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3353: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
3354: p_return_status OUT NOCOPY VARCHAR2
3355: ) RETURN NUMBER IS

Line 3353: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,

3349:
3350: FUNCTION Get_trx_Line_amount(
3351: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3352: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
3353: p_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
3354: p_return_status OUT NOCOPY VARCHAR2
3355: ) RETURN NUMBER IS
3356:
3357: l_trx_line_amount NUMBER;

Line 3366: FROM ra_customer_trx_lines ctl ,

3362:
3363: SELECT ctl.extended_amount *
3364: nvl(tl.relative_amount,1)/ nvl(t.base_amount,1)
3365: INTO l_trx_line_amount
3366: FROM ra_customer_trx_lines ctl ,
3367: ra_terms t ,
3368: ra_terms_lines tl ,
3369: ar_payment_schedules ps
3370: WHERE ps.payment_schedule_id = p_payment_schedule_id and

Line 3397: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

3393: END Get_trx_Line_amount;
3394:
3395:
3396: PROCEDURE Default_Trx_Info(
3397: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3398: p_customer_trx_line_id IN NUMBER,
3399: p_show_closed_invoices IN VARCHAR2,
3400: p_cr_gl_date IN DATE,
3401: p_cr_customer_id IN ar_cash_receipts.pay_from_customer%TYPE,

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

3403: p_cr_payment_schedule_id IN NUMBER,
3404: p_cr_date IN DATE,
3405: p_called_from IN VARCHAR2,
3406: p_customer_id OUT NOCOPY NUMBER, --customer on transaction
3407: p_cust_trx_type_id OUT NOCOPY ra_customer_trx.cust_trx_type_id%TYPE ,
3408: p_trx_due_date OUT NOCOPY DATE,
3409: p_trx_currency_code OUT NOCOPY VARCHAR2,
3410: p_trx_exchange_rate OUT NOCOPY NUMBER,
3411: p_trx_date OUT NOCOPY DATE,

Line 3546: ra_customer_trx ct

3542: p_rec_charges_charged,
3543: p_rec_charges_remaining,
3544: l_location
3545: FROM
3546: ra_customer_trx ct
3547: , ra_cust_trx_types ctt
3548: , hz_cust_site_uses su
3549: , ra_batch_sources bs
3550: , ar_lookups lu

Line 3643: ra_customer_trx ct

3639: p_rec_charges_charged,
3640: p_rec_charges_remaining,
3641: l_location
3642: FROM
3643: ra_customer_trx ct
3644: , ra_cust_trx_types ctt
3645: , hz_cust_site_uses su
3646: , ra_batch_sources bs
3647: , ar_lookups lu

Line 4194: FROM ra_customer_trx

4190: IF p_trx_number IS NOT NULL THEN
4191: BEGIN
4192: SELECT customer_trx_id
4193: INTO p_customer_trx_id
4194: FROM ra_customer_trx
4195: WHERE trx_number = p_trx_number;
4196: EXCEPTION
4197: WHEN no_data_found THEN
4198: FND_MESSAGE.SET_NAME('AR','AR_RAPI_TRX_NUM_INVALID');

Line 4241: from ra_customer_trx_lines line

4237: p_return_status := FND_API.G_RET_STS_SUCCESS;
4238:
4239: select count(1)
4240: into l_count
4241: from ra_customer_trx_lines line
4242: where line.customer_Trx_id = p_customer_trx_id
4243: and line.line_type = 'LINE'
4244: and line.source_data_key4 = p_group_id
4245: and rownum = 1;

Line 4297: FROM ra_customer_trx_lines

4293: IF p_line_number IS NOT NULL THEN
4294: BEGIN
4295: SELECT customer_trx_line_id
4296: INTO p_customer_trx_line_id
4297: FROM ra_customer_trx_lines
4298: WHERE customer_trx_id = p_customer_trx_id
4299: AND line_number = p_line_number
4300: AND line_type = 'LINE';
4301: EXCEPTION

Line 4316: FROM ra_customer_trx_lines

4312: IF p_customer_trx_line_id IS NOT NULL THEN
4313: BEGIN
4314: SELECT customer_trx_id
4315: INTO p_customer_trx_id
4316: FROM ra_customer_trx_lines
4317: WHERE customer_trx_line_id = p_customer_trx_line_id
4318: AND line_type = 'LINE';
4319: EXCEPTION
4320: WHEN no_data_found THEN

Line 4346: FROM ra_customer_trx_lines

4342: Then
4343: BEGIN
4344: SELECT customer_trx_line_id
4345: INTO l_cust_trx_line_id
4346: FROM ra_customer_trx_lines
4347: WHERE customer_trx_id = p_customer_trx_id
4348: AND line_number = i.line_number
4349: AND line_type = 'LINE';
4350:

Line 4371: FROM ra_customer_trx_lines

4367: Else
4368: BEGIN
4369: SELECT customer_trx_line_id
4370: INTO l_cust_trx_line_id
4371: FROM ra_customer_trx_lines
4372: WHERE customer_trx_id = p_customer_trx_id
4373: AND customer_trx_line_id = i.customer_trx_line_id
4374: AND line_type = 'LINE';
4375: EXCEPTION

Line 4634: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

4630: p_cr_date OUT NOCOPY DATE,
4631: p_cr_amount OUT NOCOPY ar_cash_receipts.amount%TYPE,
4632: p_cr_unapp_amount OUT NOCOPY NUMBER,
4633: p_cr_currency_code OUT NOCOPY VARCHAR2,
4634: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
4635: p_installment IN OUT NOCOPY NUMBER,
4636: p_show_closed_invoices IN VARCHAR2,
4637: p_customer_trx_line_id IN NUMBER,
4638: p_trx_due_date OUT NOCOPY DATE,

Line 5058: FROM ra_customer_trx ct,

5054: IF p_installment IS NOT NULL THEN
5055: BEGIN
5056: SELECT ps.payment_schedule_id
5057: INTO l_trx_ps_id
5058: FROM ra_customer_trx ct,
5059: ar_payment_schedules ps
5060: WHERE ct.customer_trx_id = p_customer_trx_id
5061: AND ct.customer_trx_id = ps.customer_trx_id
5062: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')

Line 5086: FROM ra_customer_trx ct,

5082: --has only one installment, get the ps_id for that installment
5083: BEGIN
5084: SELECT ps.payment_schedule_id
5085: INTO l_trx_ps_id
5086: FROM ra_customer_trx ct,
5087: ar_payment_schedules ps
5088: WHERE ct.customer_trx_id = p_customer_trx_id
5089: AND ct.customer_trx_id = ps.customer_trx_id
5090: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')

Line 5111: FROM ra_customer_trx ct,

5107: IF p_installment IS NOT NULL THEN
5108: BEGIN
5109: SELECT ps.payment_schedule_id
5110: INTO l_trx_ps_id
5111: FROM ra_customer_trx ct,
5112: ar_payment_schedules ps
5113: WHERE ct.customer_trx_id = p_customer_trx_id
5114: AND ct.customer_trx_id = ps.customer_trx_id
5115: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')

Line 5140: FROM ra_customer_trx ct,

5136: --has only one installment, get the ps_id for that installment
5137: BEGIN
5138: SELECT ps.payment_schedule_id
5139: INTO l_trx_ps_id
5140: FROM ra_customer_trx ct,
5141: ar_payment_schedules ps
5142: WHERE ct.customer_trx_id = p_customer_trx_id
5143: AND ct.customer_trx_id = ps.customer_trx_id
5144: AND ps.class IN ('CB','CM','DEP','DM','INV','BR')

Line 5359: l_ra_customer_trx_id NUMBER;

5355: p_apply_gl_date OUT NOCOPY DATE,
5356: p_return_status OUT NOCOPY VARCHAR2
5357: ) IS
5358: l_customer_trx_id NUMBER;
5359: l_ra_customer_trx_id NUMBER;
5360: l_installment NUMBER(15);
5361: l_ra_app_ps_id NUMBER;
5362: l_applied_payment_schedule_id NUMBER;
5363: l_receivable_application_id NUMBER;

Line 6576: p_trx_number IN ra_customer_trx.trx_number%TYPE,

6572:
6573: /* modified for tca uptake */
6574: PROCEDURE Derive_cust_info_from_trx(
6575: p_customer_trx_id IN ar_payment_schedules.customer_trx_id%TYPE,
6576: p_trx_number IN ra_customer_trx.trx_number%TYPE,
6577: p_installment IN ar_payment_schedules.terms_sequence_number%TYPE,
6578: p_applied_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE,
6579: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
6580: p_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,

Line 7899: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE

7895: END get_legal_entity;
7896:
7897: PROCEDURE default_refund_attributes (
7898: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
7899: ,p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE
7900: ,p_currency_code IN fnd_currencies.currency_code%TYPE
7901: ,p_amount IN NUMBER
7902: ,p_party_id IN OUT NOCOPY hz_parties.party_id%TYPE
7903: ,p_party_site_id IN OUT NOCOPY hz_party_sites.party_site_id%TYPE

Line 7975: FROM ra_customer_trx

7971: x_exchange_date,
7972: l_org_id,
7973: l_cust_acct_id,
7974: l_site_use_id
7975: FROM ra_customer_trx
7976: WHERE customer_trx_id = p_customer_trx_id;
7977: END IF;
7978: IF p_party_id IS NULL THEN
7979: BEGIN