APPS.ARP_PROCESS_LOCKBOX dependencies on RA_CUSTOMER_TRX_LINES

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