APPS.ARP_PROCESS_LOCKBOX dependencies on RA_CUSTOMER_TRX_LINES

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 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 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 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 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 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 ' ||