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.

[Home] [Help]

APPS.ARP_PROCESS_LOCKBOX dependencies on AR_PMTS_INTERFACE_LINES_GT

Line 2728: INSERT INTO ar_pmts_interface_lines_gt(

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

Line 2748: UPDATE ar_pmts_interface_lines_gt lines

2744: );
2745: END LOOP;
2746: END LOOP;
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

Line 2758: UPDATE ar_pmts_interface_lines_gt lines

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

Line 2772: UPDATE ar_pmts_interface_lines_gt lines

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

Line 2780: UPDATE ar_pmts_interface_lines_gt lines

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

Line 2793: FROM ar_pmts_interface_lines_gt

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

Line 2803: FROM ar_pmts_interface_lines_gt

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

Line 2812: FROM ar_pmts_interface_lines_gt

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

Line 2886: FROM ar_pmts_interface_lines_gt

2882: SELECT line_amt_remaining,
2883: tax_remaining
2884: INTO l_line_amount_remaining,
2885: l_line_tax_remaining
2886: FROM ar_pmts_interface_lines_gt
2887: WHERE customer_trx_id = cur_var1.customer_trx_id
2888: AND transmission_request_id = p_trans_req_id
2889: AND apply_to = cur_var2.apply_to;
2890: fnd_file.put_line(fnd_file.LOG, 'Apply_to' || cur_var2.apply_to);

Line 3023: from ar_pmts_interface_lines_gt ld1,

3019: SET status = 'AR_PLB_EXCEED_LINE_AMT'
3020: WHERE transmission_request_id = p_trans_req_id
3021: AND (customer_trx_id, apply_to) IN
3022: ( select lines_gt.customer_trx_id, lines_gt.apply_to
3023: from ar_pmts_interface_lines_gt ld1,
3024: ( select customer_trx_id,
3025: apply_to,
3026: sum(lines.line_amount) tot_amt
3027: from ar_pmts_interface_line_details lines

Line 3041: from ar_pmts_interface_lines_gt ld1,

3037: SET status = 'AR_PLB_EXCEED_TAX_AMT'
3038: WHERE transmission_request_id = p_trans_req_id
3039: AND (customer_trx_id, apply_to) IN
3040: ( select lines_gt.customer_trx_id, lines_gt.apply_to
3041: from ar_pmts_interface_lines_gt ld1,
3042: ( select customer_trx_id,
3043: apply_to,
3044: sum(lines.tax) tot_amt
3045: from ar_pmts_interface_line_details lines

Line 3059: from ar_pmts_interface_lines_gt ld1,

3055: SET status = 'AR_PLB_EXCEED_FRGT_AMT'
3056: WHERE transmission_request_id = p_trans_req_id
3057: AND (customer_trx_id, apply_to) IN
3058: ( select ld1.customer_trx_id, ld1.apply_to
3059: from ar_pmts_interface_lines_gt ld1,
3060: ar_pmts_interface_line_details ld2
3061: where ld1.customer_trx_id = ld2.customer_trx_id
3062: and ld1.apply_to = ld2.apply_to
3063: and ld2.apply_to = 'FREIGHT'

Line 3073: from ar_pmts_interface_lines_gt ld1,

3069: SET status = 'AR_PLB_EXCEED_CHRG_AMT'
3070: WHERE transmission_request_id = p_trans_req_id
3071: AND (customer_trx_id, apply_to) IN
3072: ( select ld1.customer_trx_id, ld1.apply_to
3073: from ar_pmts_interface_lines_gt ld1,
3074: ar_pmts_interface_line_details ld2
3075: where ld1.customer_trx_id = ld2.customer_trx_id
3076: and ld1.apply_to = ld2.apply_to
3077: and ld2.transmission_request_id = p_trans_req_id