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.ARP_PROCESS_LOCKBOX dependencies on RA_CUSTOMER_TRX

Line 2162: l_customer_trx ra_customer_trx%rowtype;

2158: l_default_by VARCHAR2(20);
2159: l_line_amount_remaining NUMBER;
2160: l_line_tax_remaining NUMBER;
2161: line_amt_due_original NUMBER;
2162: l_customer_trx ra_customer_trx%rowtype;
2163: ll_leg_app varchar2(1);
2164: ll_mfar_app varchar2(1);
2165: ll_leg_adj varchar2(1);
2166: ll_mfar_adj varchar2(1);

Line 2615: FROM ra_customer_trx

2611:
2612: /* We may need to handle duplicate invoices in future, here */
2613: UPDATE ar_pmts_interface_header_gt gt
2614: SET (customer_trx_id) = ( SELECT customer_trx_id
2615: FROM ra_customer_trx
2616: WHERE trx_number = gt.invoice_number ) ;
2617:
2618: UPDATE ar_pmts_interface_line_details ld
2619: SET customer_trx_id = (SELECT customer_trx_id

Line 2647: FROM ra_customer_trx_lines TL,ra_customer_trx T

2643: For cur_var in customer_trx_cursor(p_trans_req_id) LOOP
2644:
2645: SELECT amount_due_original
2646: INTO line_amt_due_original
2647: FROM ra_customer_trx_lines TL,ra_customer_trx T
2648: WHERE T.customer_trx_id = TL.customer_trx_id
2649: AND T.customer_trx_id = cur_var.customer_trx_id
2650: AND TL.line_type = 'LINE'
2651: AND rownum = 1;

Line 2690: FROM ra_customer_trx trx,

2686: SET status = 'AR_PLB_INVALID_LINE_NUM'
2687: WHERE transmission_request_id = p_trans_req_id
2688: AND apply_to NOT in ('FREIGHT','CHARGES')
2689: AND NOT EXISTS ( select 'x'
2690: FROM ra_customer_trx trx,
2691: ra_customer_trx_lines lines,
2692: ar_pmts_interface_header_gt header
2693: WHERE trx.customer_trx_id = lines.customer_trx_id
2694: AND header.invoice_number = line_details.invoice_number

Line 2691: ra_customer_trx_lines lines,

2687: WHERE transmission_request_id = p_trans_req_id
2688: AND apply_to NOT in ('FREIGHT','CHARGES')
2689: AND NOT EXISTS ( select 'x'
2690: FROM ra_customer_trx trx,
2691: ra_customer_trx_lines lines,
2692: ar_pmts_interface_header_gt header
2693: WHERE trx.customer_trx_id = lines.customer_trx_id
2694: AND header.invoice_number = line_details.invoice_number
2695: AND header.transmission_record_id = line_details.transmission_record_id

Line 2705: FROM ra_customer_trx trx,

2701: SET status = 'AR_PLB_INVALID_LINE_NUM'
2702: WHERE transmission_request_id = p_trans_req_id
2703: AND apply_to IN ('FREIGHT', 'CHARGES')
2704: AND NOT EXISTS ( select 'x'
2705: FROM ra_customer_trx trx,
2706: ra_customer_trx_lines lines,
2707: ar_pmts_interface_header_gt header
2708: WHERE trx.customer_trx_id = lines.customer_trx_id
2709: AND header.invoice_number = line_details.invoice_number

Line 2706: ra_customer_trx_lines lines,

2702: WHERE transmission_request_id = p_trans_req_id
2703: AND apply_to IN ('FREIGHT', 'CHARGES')
2704: AND NOT EXISTS ( select 'x'
2705: FROM ra_customer_trx trx,
2706: ra_customer_trx_lines lines,
2707: ar_pmts_interface_header_gt header
2708: WHERE trx.customer_trx_id = lines.customer_trx_id
2709: AND header.invoice_number = line_details.invoice_number
2710: AND header.transmission_record_id = line_details.transmission_record_id

Line 2753: from ra_customer_trx_lines TL

2749:
2750: UPDATE ar_pmts_interface_lines_gt lines
2751: SET line_amt_remaining
2752: = (select sum(nvl(TL.amount_due_remaining,0))
2753: from ra_customer_trx_lines TL
2754: where TL.customer_trx_id = lines.customer_trx_id
2755: and TL.line_number = lines.apply_to
2756: and TL.line_type = 'LINE'
2757: )

Line 2763: from ra_customer_trx_lines TL

2759:
2760: UPDATE ar_pmts_interface_lines_gt lines
2761: SET tax_remaining
2762: = (select sum(nvl(TL.amount_due_remaining,0))
2763: from ra_customer_trx_lines TL
2764: where TL.link_to_cust_trx_line_id = (
2765: select l.customer_trx_line_id
2766: from ra_customer_trx_lines l
2767: where l.customer_trx_id = lines.customer_trx_id

Line 2766: from ra_customer_trx_lines l

2762: = (select sum(nvl(TL.amount_due_remaining,0))
2763: from ra_customer_trx_lines TL
2764: where TL.link_to_cust_trx_line_id = (
2765: select l.customer_trx_line_id
2766: from ra_customer_trx_lines l
2767: where l.customer_trx_id = lines.customer_trx_id
2768: and l.line_type = 'LINE'
2769: and l.line_number = lines.apply_to)
2770: and TL.line_type = 'TAX'

Line 2777: FROM ra_customer_trx_lines TL

2773:
2774: UPDATE ar_pmts_interface_lines_gt lines
2775: SET freight_remaining
2776: = ( SELECT sum(nvl(TL.amount_due_remaining,0))
2777: FROM ra_customer_trx_lines TL
2778: WHERE TL.customer_trx_id = lines.customer_trx_id
2779: AND TL.line_type = lines.apply_to)
2780: WHERE lines.apply_to = 'FREIGHT';
2781:

Line 2785: FROM ra_customer_trx_lines TL

2781:
2782: UPDATE ar_pmts_interface_lines_gt lines
2783: SET charges_remaining
2784: = ( SELECT sum(nvl(TL.amount_due_remaining,0))
2785: FROM ra_customer_trx_lines TL
2786: WHERE TL.customer_trx_id = lines.customer_trx_id
2787: AND TL.line_type = lines.apply_to)
2788: WHERE lines.apply_to = 'CHARGES';
2789:

Line 3384: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

3380: | |
3381: | 28-Jul-07 vpusulur Created. |
3382: +===========================================================================*/
3383: PROCEDURE insert_interim_line_details(
3384: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3385: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%type,
3386: p_cash_receipt_line_id IN NUMBER,
3387: p_trans_req_id IN ar_payments_interface.transmission_request_id%type,
3388: p_batch_name IN ar_payments_interface.batch_name%type,

Line 3395: inv_number ra_customer_trx.trx_number%type;

3391: )
3392: IS
3393:
3394: status_count number := 0;
3395: inv_number ra_customer_trx.trx_number%type;
3396: l_line_id number;
3397: tot_frgt_chrg_amt number := 0;
3398: prorated_frgt_chrg_amt number := 0;
3399: prorated_frgt_chrg_amt_frm number := 0;

Line 3450: from ra_customer_trx_lines

3446:
3447: cursor frgt_chrg_prorate(ct_id in number,app_to in varchar2) is
3448: select customer_trx_line_id,
3449: amount_due_remaining
3450: from ra_customer_trx_lines
3451: where customer_trx_id = ct_id
3452: and line_type = app_to;
3453:
3454: BEGIN

Line 3462: from ra_customer_trx

3458:
3459:
3460: select trx_number
3461: into inv_number
3462: from ra_customer_trx
3463: where customer_trx_id = p_customer_trx_id;
3464:
3465: select currency_code
3466: into l_currency_code

Line 3585: from ra_customer_trx_lines l

3581: null,
3582: 1,
3583: 'ARLPLB',
3584: l_line_id
3585: from ra_customer_trx_lines l
3586: where l.customer_trx_id = p_customer_trx_id
3587: and l.line_type = 'LINE'
3588: and l.line_number = det_line.apply_to;
3589: else

Line 3592: from ra_customer_trx_lines

3588: and l.line_number = det_line.apply_to;
3589: else
3590: Select sum(nvl(amount_due_remaining,0))
3591: into tot_frgt_chrg_amt
3592: from ra_customer_trx_lines
3593: where customer_trx_id = p_customer_trx_id
3594: and line_type = det_line.apply_to;
3595:
3596: SELECT invoice_currency_code,

Line 4023: ' ra_customer_trx rct, ' ||

4019: ' ra_cust_trx_types rctt, ' ||
4020: ' hz_customer_profiles cpc, ' ||
4021: ' hz_customer_profiles cps, ' ||
4022: ' ar_payment_schedules ps, ' ||
4023: ' ra_customer_trx rct, ' ||
4024: ' ra_customer_trx_lines rctl ' ;
4025: --
4026: -- Constructing where clause
4027: g_cursor_string := g_cursor_string ||

Line 4024: ' ra_customer_trx_lines rctl ' ;

4020: ' hz_customer_profiles cpc, ' ||
4021: ' hz_customer_profiles cps, ' ||
4022: ' ar_payment_schedules ps, ' ||
4023: ' ra_customer_trx rct, ' ||
4024: ' ra_customer_trx_lines rctl ' ;
4025: --
4026: -- Constructing where clause
4027: g_cursor_string := g_cursor_string ||
4028: ' where ' ||

Line 4139: ' ra_customer_trx rct ' ;

4135: ' ra_cust_trx_types rctt, ' ||
4136: ' hz_customer_profiles cpc, ' ||
4137: ' hz_customer_profiles cps, ' ||
4138: ' ar_payment_schedules ps, ' ||
4139: ' ra_customer_trx rct ' ;
4140: --
4141: -- Constructing WHERE clause
4142: g_cursor_string := g_cursor_string ||
4143: ' where ' ||