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 2159: l_customer_trx ra_customer_trx%rowtype;

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

Line 2613: FROM ra_customer_trx

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

Line 2645: FROM ra_customer_trx_lines TL,ra_customer_trx T

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

Line 2688: FROM ra_customer_trx trx,

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

Line 2689: ra_customer_trx_lines lines,

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

Line 2703: FROM ra_customer_trx trx,

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

Line 2704: ra_customer_trx_lines lines,

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

Line 2751: from ra_customer_trx_lines TL

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

Line 2761: from ra_customer_trx_lines TL

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

Line 2764: from ra_customer_trx_lines l

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

Line 2775: FROM ra_customer_trx_lines TL

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

Line 2783: FROM ra_customer_trx_lines TL

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

Line 3375: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,

3371: | |
3372: | 28-Jul-07 vpusulur Created. |
3373: +===========================================================================*/
3374: PROCEDURE insert_interim_line_details(
3375: p_customer_trx_id IN ra_customer_trx.customer_trx_id%type,
3376: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%type,
3377: p_cash_receipt_line_id IN NUMBER,
3378: p_trans_req_id IN ar_payments_interface.transmission_request_id%type,
3379: p_return_status OUT NOCOPY varchar2

Line 3420: from ra_customer_trx_lines

3416:
3417: cursor frgt_chrg_prorate(ct_id in number,app_to in varchar2) is
3418: select customer_trx_line_id,
3419: amount_due_remaining
3420: from ra_customer_trx_lines
3421: where customer_trx_id = ct_id
3422: and line_type = app_to;
3423:
3424: status_count number := 0;

Line 3425: inv_number ra_customer_trx.trx_number%type;

3421: where customer_trx_id = ct_id
3422: and line_type = app_to;
3423:
3424: status_count number := 0;
3425: inv_number ra_customer_trx.trx_number%type;
3426: l_line_id number;
3427: tot_frgt_chrg_amt number := 0;
3428: prorated_frgt_chrg_amt number := 0;
3429: prorated_frgt_chrg_amt_frm number := 0;

Line 3443: from ra_customer_trx

3439: debug1('insert_interim_line_details()+ ' ||p_cash_receipt_line_id );
3440:
3441: select trx_number
3442: into inv_number
3443: from ra_customer_trx
3444: where customer_trx_id = p_customer_trx_id;
3445:
3446: select currency_code
3447: into l_currency_code

Line 3566: from ra_customer_trx_lines l

3562: null,
3563: 1,
3564: 'ARLPLB',
3565: l_line_id
3566: from ra_customer_trx_lines l
3567: where l.customer_trx_id = p_customer_trx_id
3568: and l.line_type = 'LINE'
3569: and l.line_number = det_line.apply_to;
3570: else

Line 3573: from ra_customer_trx_lines

3569: and l.line_number = det_line.apply_to;
3570: else
3571: Select sum(nvl(amount_due_remaining,0))
3572: into tot_frgt_chrg_amt
3573: from ra_customer_trx_lines
3574: where customer_trx_id = p_customer_trx_id
3575: and line_type = det_line.apply_to;
3576:
3577: SELECT invoice_currency_code,

Line 3944: ' ra_customer_trx rct, ' ||

3940: ' ra_cust_trx_types rctt, ' ||
3941: ' hz_customer_profiles cpc, ' ||
3942: ' hz_customer_profiles cps, ' ||
3943: ' ar_payment_schedules ps, ' ||
3944: ' ra_customer_trx rct, ' ||
3945: ' ra_customer_trx_lines rctl ' ;
3946: --
3947: -- Constructing where clause
3948: g_cursor_string := g_cursor_string ||

Line 3945: ' ra_customer_trx_lines rctl ' ;

3941: ' hz_customer_profiles cpc, ' ||
3942: ' hz_customer_profiles cps, ' ||
3943: ' ar_payment_schedules ps, ' ||
3944: ' ra_customer_trx rct, ' ||
3945: ' ra_customer_trx_lines rctl ' ;
3946: --
3947: -- Constructing where clause
3948: g_cursor_string := g_cursor_string ||
3949: ' where ' ||

Line 4040: ' ra_customer_trx rct ' ;

4036: ' ra_cust_trx_types rctt, ' ||
4037: ' hz_customer_profiles cpc, ' ||
4038: ' hz_customer_profiles cps, ' ||
4039: ' ar_payment_schedules ps, ' ||
4040: ' ra_customer_trx rct ' ;
4041: --
4042: -- Constructing WHERE clause
4043: g_cursor_string := g_cursor_string ||
4044: ' where ' ||