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 AR_PMTS_INTERFACE_LINES_GT

Line 2730: INSERT INTO ar_pmts_interface_lines_gt(

2726: AND rownum = 1;
2727:
2728: FOR cur_var1 in apply_to_rec(p_trans_req_id,
2729: cur_var.customer_trx_id) LOOP
2730: INSERT INTO ar_pmts_interface_lines_gt(
2731: transmission_request_id,
2732: customer_trx_id,
2733: currency_code,
2734: invoice_number,

Line 2750: UPDATE ar_pmts_interface_lines_gt lines

2746: );
2747: END LOOP;
2748: END LOOP;
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

Line 2760: UPDATE ar_pmts_interface_lines_gt lines

2756: and TL.line_type = 'LINE'
2757: )
2758: WHERE lines.apply_to NOT IN ('FREIGHT', 'CHARGES');
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 = (

Line 2774: UPDATE ar_pmts_interface_lines_gt lines

2770: and TL.line_type = 'TAX'
2771: )
2772: WHERE lines.apply_to NOT IN ('FREIGHT', 'CHARGES');
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

Line 2782: UPDATE ar_pmts_interface_lines_gt lines

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

Line 2795: FROM ar_pmts_interface_lines_gt

2791: SET status = 'AR_PLB_INVALID_APP'
2792: WHERE transmission_request_id = p_trans_req_id
2793: AND (customer_trx_id, apply_to) IN
2794: (SELECT customer_trx_id, apply_to
2795: FROM ar_pmts_interface_lines_gt
2796: WHERE nvl(line_amt_remaining, 0) = 0
2797: AND nvl(tax_remaining, 0) = 0
2798: AND apply_to NOT IN ('FREIGHT', 'CHARGES'));
2799:

Line 2805: FROM ar_pmts_interface_lines_gt

2801: SET status = 'AR_PLB_INVALID_APP'
2802: WHERE transmission_request_id = p_trans_req_id
2803: AND (customer_trx_id, apply_to) IN
2804: (SELECT customer_trx_id, apply_to
2805: FROM ar_pmts_interface_lines_gt
2806: WHERE freight_remaining = 0
2807: AND apply_to = 'FREIGHT');
2808:
2809: UPDATE ar_pmts_interface_line_details

Line 2814: FROM ar_pmts_interface_lines_gt

2810: SET status = 'AR_PLB_INVALID_APP'
2811: WHERE transmission_request_id = p_trans_req_id
2812: AND (customer_trx_id, apply_to) IN
2813: (SELECT customer_trx_id, apply_to
2814: FROM ar_pmts_interface_lines_gt
2815: WHERE charges_remaining = 0
2816: AND apply_to = 'CHARGES' );
2817:
2818: UPDATE ar_pmts_interface_header_gt header

Line 2888: FROM ar_pmts_interface_lines_gt

2884: SELECT line_amt_remaining,
2885: tax_remaining
2886: INTO l_line_amount_remaining,
2887: l_line_tax_remaining
2888: FROM ar_pmts_interface_lines_gt
2889: WHERE customer_trx_id = cur_var1.customer_trx_id
2890: AND transmission_request_id = p_trans_req_id
2891: AND apply_to = cur_var2.apply_to;
2892:

Line 3033: from ar_pmts_interface_lines_gt ld1,

3029: SET status = 'AR_PLB_EXCEED_LINE_AMT'
3030: WHERE transmission_request_id = p_trans_req_id
3031: AND (customer_trx_id, apply_to) IN
3032: ( select lines_gt.customer_trx_id, lines_gt.apply_to
3033: from ar_pmts_interface_lines_gt ld1,
3034: ( select customer_trx_id,
3035: apply_to,
3036: sum(lines.line_amount) tot_amt
3037: from ar_pmts_interface_line_details lines

Line 3051: from ar_pmts_interface_lines_gt ld1,

3047: SET status = 'AR_PLB_EXCEED_TAX_AMT'
3048: WHERE transmission_request_id = p_trans_req_id
3049: AND (customer_trx_id, apply_to) IN
3050: ( select lines_gt.customer_trx_id, lines_gt.apply_to
3051: from ar_pmts_interface_lines_gt ld1,
3052: ( select customer_trx_id,
3053: apply_to,
3054: sum(lines.tax) tot_amt
3055: from ar_pmts_interface_line_details lines

Line 3069: from ar_pmts_interface_lines_gt ld1,

3065: SET status = 'AR_PLB_EXCEED_FRGT_AMT'
3066: WHERE transmission_request_id = p_trans_req_id
3067: AND (customer_trx_id, apply_to) IN
3068: ( select ld1.customer_trx_id, ld1.apply_to
3069: from ar_pmts_interface_lines_gt ld1,
3070: ar_pmts_interface_line_details ld2
3071: where ld1.customer_trx_id = ld2.customer_trx_id
3072: and ld1.apply_to = ld2.apply_to
3073: and ld2.apply_to = 'FREIGHT'

Line 3083: from ar_pmts_interface_lines_gt ld1,

3079: SET status = 'AR_PLB_EXCEED_CHRG_AMT'
3080: WHERE transmission_request_id = p_trans_req_id
3081: AND (customer_trx_id, apply_to) IN
3082: ( select ld1.customer_trx_id, ld1.apply_to
3083: from ar_pmts_interface_lines_gt ld1,
3084: ar_pmts_interface_line_details ld2
3085: where ld1.customer_trx_id = ld2.customer_trx_id
3086: and ld1.apply_to = ld2.apply_to
3087: and ld2.transmission_request_id = p_trans_req_id