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_BAL_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 59: FROM ra_customer_trx_lines

55: IF ( p_extended_amount IS NULL )
56: THEN
57: SELECT extended_amount
58: INTO l_original_amount
59: FROM ra_customer_trx_lines
60: WHERE customer_trx_line_id = p_customer_trx_line_id;
61: ELSE l_original_amount := p_extended_amount;
62: END IF;
63: */

Line 69: FROM ra_customer_trx_lines

65: SELECT DECODE(line_type, 'LINE',
66: NVL(gross_extended_amount, extended_amount),
67: extended_amount)
68: INTO l_original_amount
69: FROM ra_customer_trx_lines
70: WHERE customer_trx_line_id = p_customer_trx_line_id;
71:
72:
73: /*-----------------------------------------------------+

Line 96: ra_customer_trx_lines ctl

92: ), 0
93: )
94: INTO l_net_amount
95: FROM ra_customer_trx ct,
96: ra_customer_trx_lines ctl
97: WHERE ctl.previous_customer_trx_line_id = p_customer_trx_line_id
98: AND ctl.customer_trx_id = ct.customer_trx_id;
99:
100: RETURN(l_net_amount);

Line 151: FROM ra_customer_trx_lines

147: SELECT NVL(
148: SUM( extended_amount ), 0
149: )
150: INTO l_credit_amount
151: FROM ra_customer_trx_lines
152: WHERE previous_customer_trx_line_id = p_prev_customer_trx_line_id;
153:
154: RETURN(l_credit_amount);
155: END IF;

Line 203: FROM ra_customer_trx_lines

199: IF (UPPER(p_return_null_flag)='Y')
200: THEN
201: SELECT SUM(extended_amount)
202: INTO l_credit_amount
203: FROM ra_customer_trx_lines
204: WHERE previous_customer_trx_line_id = p_prev_customer_trx_line_id;
205: ELSE
206: SELECT NVL(
207: SUM( extended_amount ), 0

Line 210: FROM ra_customer_trx_lines

206: SELECT NVL(
207: SUM( extended_amount ), 0
208: )
209: INTO l_credit_amount
210: FROM ra_customer_trx_lines
211: WHERE previous_customer_trx_line_id = p_prev_customer_trx_line_id;
212: END IF;
213: RETURN(l_credit_amount);
214: END IF;

Line 713: FROM ra_customer_trx_lines ctl,

709: ) -- freight_credited
710: INTO l_line_credits1,
711: l_tax_credits1,
712: l_freight_credits1
713: FROM ra_customer_trx_lines ctl,
714: ra_cust_trx_line_gl_dist rec,
715: ra_customer_trx ct
716: WHERE ct.customer_trx_id = ctl.customer_trx_id
717: AND ct.customer_trx_id = rec.customer_trx_id

Line 1099: ra_customer_trx_lines orig_ctl,

1095: l_freight_credits,
1096: l_total_credits,
1097: l_base_total_original
1098: FROM ra_cust_trx_line_gl_dist lgd,
1099: ra_customer_trx_lines orig_ctl,
1100: ra_customer_trx_lines ctl,
1101: ra_customer_trx ct
1102: WHERE (
1103: ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id

Line 1100: ra_customer_trx_lines ctl,

1096: l_total_credits,
1097: l_base_total_original
1098: FROM ra_cust_trx_line_gl_dist lgd,
1099: ra_customer_trx_lines orig_ctl,
1100: ra_customer_trx_lines ctl,
1101: ra_customer_trx ct
1102: WHERE (
1103: ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
1104: OR

Line 1991: ra_customer_trx_lines lines,

1987: l_currency_code,
1988: l_sub_inv_trx_type_id,
1989: l_allocate_t_f
1990: FROM hz_cust_accounts cust_acct,
1991: ra_customer_trx_lines lines,
1992: ra_customer_trx trx,
1993: ra_cust_trx_types type
1994: WHERE trx.customer_trx_id = p_customer_trx_id
1995: AND trx.cust_trx_type_id = type.cust_trx_type_id

Line 2045: ra_customer_trx_lines l

2041: NVL( SUM(NVL(i.promised_commitment_amount,
2042: i.amount)), 0)
2043: INTO l_commitment_bal
2044: FROM ra_interface_lines i,
2045: ra_customer_trx_lines l
2046: WHERE NVL(interface_status,
2047: 'A') <> 'P'
2048: AND (i.line_type = 'LINE'
2049: OR i.line_type = DECODE(l_allocate_t_f,'Y','FREIGHT','LINE'))

Line 2113: ra_customer_trx_lines line

2109: 0
2110: )
2111: INTO l_commitment_bal
2112: FROM ra_customer_trx trx,
2113: ra_customer_trx_lines line
2114: WHERE trx.customer_trx_id = line.customer_trx_id
2115: AND trx.previous_customer_trx_id = p_customer_trx_id
2116: AND trx.complete_flag = 'Y';
2117:

Line 2360: FROM RA_CUSTOMER_TRX_LINES

2356: INTO l_count
2357: from ar_activity_details
2358: WHERE customer_trx_line_id in
2359: (SELECT customer_trx_line_id
2360: FROM RA_CUSTOMER_TRX_LINES
2361: WHERE customer_trx_id = p_customer_trx_id)
2362: and nvl(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'; -- bug 7241111
2363:
2364: IF ( l_count > 0) THEN

Line 2521: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;

2517: l_base_curr_code fnd_currencies.currency_code%type;
2518: l_base_precision fnd_currencies.precision%type;
2519: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2520:
2521: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;
2522: BEGIN
2523:
2524: /* initialize the items */
2525:

Line 2555: from ra_customer_Trx_lines

2551: IF (p_line_num IS NOT NULL) THEN
2552:
2553: select customer_Trx_line_id
2554: into l_customer_trx_line_id
2555: from ra_customer_Trx_lines
2556: where line_number = p_line_num
2557: and line_type = 'LINE'
2558: and customer_trx_id = p_customer_trx_id;
2559:

Line 2580: ra_customer_trx_lines lines

2576: INTO l_line_original,
2577: l_tax_original,
2578: l_freight_original
2579: from ra_customer_trx ct,
2580: ra_customer_trx_lines lines
2581: where (lines.customer_Trx_line_id = l_customer_trx_line_id or
2582: lines.link_to_cust_trx_line_id = l_customer_trx_line_id)
2583: and ct.customer_Trx_id = lines.customer_trx_id
2584: and ct.customer_trx_id = p_customer_trx_id;

Line 2635: ra_customer_trx_lines line

2631: INTO
2632: l_charges_receipts,
2633: l_freight_discount
2634: FROM AR_ACTIVITY_DETAILS act,
2635: ra_customer_trx_lines line
2636: WHERE line.customer_Trx_id = p_customer_trx_id
2637: and line.line_number = p_line_num
2638: and line.line_type = 'LINE'
2639: and nvl(act.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- bug 7241111

Line 2649: ra_customer_trx_lines ctl

2645: INTO
2646: l_freight_receipts,
2647: l_base_freight_receipts
2648: FROM ar_distributions ard,
2649: ra_customer_trx_lines ctl
2650: WHERE ard.source_table = 'RA'
2651: AND ard.source_id in (select receivable_application_id
2652: from ar_receivable_applications
2653: where status = 'APP' and

Line 2752: ra_customer_trx_lines lines

2748: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2749: INTO l_tax_adjustments,
2750: l_base_tax_adjustments
2751: from ar_distributions dist,
2752: ra_customer_trx_lines lines
2753: where lines.link_to_cust_trx_line_id = l_customer_trx_line_id
2754: and lines.line_type = 'TAX'
2755: and dist.ref_customer_trx_line_id = lines.customer_trx_line_id
2756: and dist.source_table = 'ADJ'

Line 2765: ra_customer_trx_lines lines

2761: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2762: INTO l_freight_adjustments,
2763: l_base_freight_adjustments
2764: from ar_distributions dist,
2765: ra_customer_trx_lines lines
2766: where lines.link_to_cust_trx_line_id = l_customer_trx_line_id
2767: and dist.ref_customer_trx_line_id = lines.link_to_cust_trx_line_id
2768: and lines.line_type = 'FREIGHT'
2769: and dist.source_table = 'ADJ'