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

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 95: FROM ra_customer_trx ct,

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

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 354: l_exchange_rate ra_customer_trx.exchange_rate%type;

350: p_base_atotal_adjustments OUT NOCOPY NUMBER
351: ) IS
352:
353: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
354: l_exchange_rate ra_customer_trx.exchange_rate%type;
355: l_base_curr_code fnd_currencies.currency_code%type;
356: l_base_precision fnd_currencies.precision%type;
357: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
358:

Line 492: ra_customer_trx ct

488: INTO l_open_receivables_flag,
489: l_exchange_rate,
490: l_trx_type
491: FROM ra_cust_trx_types ctt,
492: ra_customer_trx ct
493: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
494: AND ct.customer_trx_id = p_customer_trx_id;
495: ELSE
496: /* 07-AUG-2000 J Rautiainen BR Implementation

Line 503: ra_customer_trx ct

499: * instead of ra_cust_trx_line_gl_dist for BR */
500: SELECT ctt.type
501: INTO l_trx_type
502: FROM ra_cust_trx_types ctt,
503: ra_customer_trx ct
504: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
505: AND ct.customer_trx_id = p_customer_trx_id;
506:
507: l_open_receivables_flag := p_open_receivables_flag;

Line 545: ra_customer_trx ct

541: /* bug2324069 added nvl */
542: SELECT nvl(SUM( acctd_amount ),0)
543: INTO l_base_total_credits1
544: FROM ra_cust_trx_line_gl_dist lgd,
545: ra_customer_trx ct
546: WHERE ct.customer_trx_id = lgd.customer_trx_id
547: AND lgd.account_class = 'REC'
548: AND lgd.latest_rec_flag = 'Y'
549: AND ct.previous_customer_trx_id = p_customer_trx_id;

Line 556: ra_customer_trx trx

552: -- Fix for bug 931292
553: select nvl(sum(rec.acctd_amount_applied_from),0)*(-1)
554: into l_base_total_credits2
555: from ar_receivable_applications rec,
556: ra_customer_trx trx
557: where rec.applied_customer_trx_id = p_customer_trx_id
558: and rec.customer_trx_id = trx.customer_trx_id
559: and rec.status = 'APP'
560: and rec.application_type = 'CM'

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 715: ra_customer_trx ct

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
718: AND rec.account_class = 'REC'
719: AND rec.latest_rec_flag = 'Y'

Line 731: ra_customer_trx trx

727: into l_line_credits2,
728: l_tax_credits2,
729: l_freight_credits2
730: from ar_receivable_applications rec,
731: ra_customer_trx trx
732: where rec.applied_customer_trx_id = p_customer_trx_id
733: and rec.customer_trx_id = trx.customer_trx_id
734: and rec.status = 'APP'
735: and rec.application_type = 'CM'

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 1101: ra_customer_trx ct

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
1105: ctl.previous_customer_trx_line_id

Line 1120: select nvl(PREVIOUS_CUSTOMER_TRX_ID,0) into l_previous_customer_trx_id from ra_customer_trx where customer_trx_id=p_customer_trx_id;

1116: nvl(l_base_total_credits,0);
1117:
1118: /* bug 9453136 , set the balance of regular CM to 0, since it will always be 0 */
1119: if NVL(l_trx_type,'INV')='CM' THEN
1120: select nvl(PREVIOUS_CUSTOMER_TRX_ID,0) into l_previous_customer_trx_id from ra_customer_trx where customer_trx_id=p_customer_trx_id;
1121: IF l_previous_customer_trx_id <> 0 THEN
1122: l_total_remaining:=0;
1123: l_line_remaining:=0;
1124: l_tax_remaining:=0;

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 1992: ra_customer_trx trx,

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
1996: AND trx.customer_trx_id = lines.customer_trx_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 2082: FROM ra_customer_trx trx,

2078: 0
2079: ) * -1
2080: )
2081: INTO l_commitment_bal
2082: FROM ra_customer_trx trx,
2083: ra_cust_trx_types type,
2084: ar_adjustments adj
2085: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
2086: AND trx.initial_customer_trx_id = p_customer_trx_id

Line 2112: FROM ra_customer_trx trx,

2108: ),
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';

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 2242: FROM ra_customer_trx t,

2238: SELECT NVL(SUM(amount),0),
2239: NVL(SUM(acctd_amount),0)
2240: INTO l_actual_amount1,
2241: l_acctd_amount1
2242: FROM ra_customer_trx t,
2243: ra_cust_trx_types ty,
2244: ar_adjustments a
2245: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2246: and t.customer_trx_id = a.customer_trx_id

Line 2258: FROM ra_customer_trx t,

2254: SELECT NVL(SUM(amount),0),
2255: NVL(SUM(acctd_amount),0)
2256: INTO l_actual_amount1,
2257: l_acctd_amount1
2258: FROM ra_customer_trx t,
2259: ra_cust_trx_types ty,
2260: ar_adjustments a
2261: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2262: and t.customer_trx_id = a.subsequent_trx_id

Line 2274: FROM ra_customer_trx t,

2270: SELECT NVL(SUM(amount),0),
2271: NVL(SUM(acctd_amount),0)
2272: INTO l_actual_amount1,
2273: l_acctd_amount1
2274: FROM ra_customer_trx t,
2275: ra_cust_trx_types ty,
2276: ar_adjustments a
2277: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2278: and a.subsequent_trx_id IN

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 2395: IN RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE DEFAULT NULL,

2391: | |
2392: +===========================================================================*/
2393: PROCEDURE trx_line_balances (
2394: p_customer_trx_id
2395: IN RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE DEFAULT NULL,
2396: p_line_num IN NUMBER DEFAULT NULL,
2397: p_group_id IN NUMBER DEFAULT NULL,
2398: p_exchange_rate IN NUMBER,
2399: p_line_original OUT NOCOPY NUMBER,

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 2579: from ra_customer_trx ct,

2575: lines.extended_amount)) -- freight_original
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

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'