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

292: p_base_atotal_adjustments OUT NOCOPY NUMBER
293: ) IS
294:
295: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
296: l_exchange_rate ra_customer_trx.exchange_rate%type;
297: l_base_curr_code fnd_currencies.currency_code%type;
298: l_base_precision fnd_currencies.precision%type;
299: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
300:

Line 428: ra_customer_trx ct

424: INTO l_open_receivables_flag,
425: l_exchange_rate,
426: l_trx_type
427: FROM ra_cust_trx_types ctt,
428: ra_customer_trx ct
429: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
430: AND ct.customer_trx_id = p_customer_trx_id;
431: ELSE
432: /* 07-AUG-2000 J Rautiainen BR Implementation

Line 439: ra_customer_trx ct

435: * instead of ra_cust_trx_line_gl_dist for BR */
436: SELECT ctt.type
437: INTO l_trx_type
438: FROM ra_cust_trx_types ctt,
439: ra_customer_trx ct
440: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
441: AND ct.customer_trx_id = p_customer_trx_id;
442:
443: l_open_receivables_flag := p_open_receivables_flag;

Line 481: ra_customer_trx ct

477: /* bug2324069 added nvl */
478: SELECT nvl(SUM( acctd_amount ),0)
479: INTO l_base_total_credits1
480: FROM ra_cust_trx_line_gl_dist lgd,
481: ra_customer_trx ct
482: WHERE ct.customer_trx_id = lgd.customer_trx_id
483: AND lgd.account_class = 'REC'
484: AND lgd.latest_rec_flag = 'Y'
485: AND ct.previous_customer_trx_id = p_customer_trx_id;

Line 492: ra_customer_trx trx

488: -- Fix for bug 931292
489: select nvl(sum(rec.acctd_amount_applied_from),0)*(-1)
490: into l_base_total_credits2
491: from ar_receivable_applications rec,
492: ra_customer_trx trx
493: where rec.applied_customer_trx_id = p_customer_trx_id
494: and rec.customer_trx_id = trx.customer_trx_id
495: and rec.status = 'APP'
496: and rec.application_type = 'CM'

Line 649: FROM ra_customer_trx_lines ctl,

645: ) -- freight_credited
646: INTO l_line_credits1,
647: l_tax_credits1,
648: l_freight_credits1
649: FROM ra_customer_trx_lines ctl,
650: ra_cust_trx_line_gl_dist rec,
651: ra_customer_trx ct
652: WHERE ct.customer_trx_id = ctl.customer_trx_id
653: AND ct.customer_trx_id = rec.customer_trx_id

Line 651: ra_customer_trx ct

647: l_tax_credits1,
648: l_freight_credits1
649: FROM ra_customer_trx_lines ctl,
650: ra_cust_trx_line_gl_dist rec,
651: ra_customer_trx ct
652: WHERE ct.customer_trx_id = ctl.customer_trx_id
653: AND ct.customer_trx_id = rec.customer_trx_id
654: AND rec.account_class = 'REC'
655: AND rec.latest_rec_flag = 'Y'

Line 667: ra_customer_trx trx

663: into l_line_credits2,
664: l_tax_credits2,
665: l_freight_credits2
666: from ar_receivable_applications rec,
667: ra_customer_trx trx
668: where rec.applied_customer_trx_id = p_customer_trx_id
669: and rec.customer_trx_id = trx.customer_trx_id
670: and rec.status = 'APP'
671: and rec.application_type = 'CM'

Line 1025: ra_customer_trx_lines orig_ctl,

1021: l_freight_credits,
1022: l_total_credits,
1023: l_base_total_original
1024: FROM ra_cust_trx_line_gl_dist lgd,
1025: ra_customer_trx_lines orig_ctl,
1026: ra_customer_trx_lines ctl,
1027: ra_customer_trx ct
1028: WHERE (
1029: ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id

Line 1026: ra_customer_trx_lines ctl,

1022: l_total_credits,
1023: l_base_total_original
1024: FROM ra_cust_trx_line_gl_dist lgd,
1025: ra_customer_trx_lines orig_ctl,
1026: ra_customer_trx_lines ctl,
1027: ra_customer_trx ct
1028: WHERE (
1029: ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
1030: OR

Line 1027: ra_customer_trx ct

1023: l_base_total_original
1024: FROM ra_cust_trx_line_gl_dist lgd,
1025: ra_customer_trx_lines orig_ctl,
1026: ra_customer_trx_lines ctl,
1027: ra_customer_trx ct
1028: WHERE (
1029: ctl.customer_trx_line_id = orig_ctl.customer_trx_line_id
1030: OR
1031: ctl.previous_customer_trx_line_id

Line 1904: ra_customer_trx_lines lines,

1900: l_currency_code,
1901: l_sub_inv_trx_type_id,
1902: l_allocate_t_f
1903: FROM hz_cust_accounts cust_acct,
1904: ra_customer_trx_lines lines,
1905: ra_customer_trx trx,
1906: ra_cust_trx_types type
1907: WHERE trx.customer_trx_id = p_customer_trx_id
1908: AND trx.cust_trx_type_id = type.cust_trx_type_id

Line 1905: ra_customer_trx trx,

1901: l_sub_inv_trx_type_id,
1902: l_allocate_t_f
1903: FROM hz_cust_accounts cust_acct,
1904: ra_customer_trx_lines lines,
1905: ra_customer_trx trx,
1906: ra_cust_trx_types type
1907: WHERE trx.customer_trx_id = p_customer_trx_id
1908: AND trx.cust_trx_type_id = type.cust_trx_type_id
1909: AND trx.customer_trx_id = lines.customer_trx_id

Line 1958: ra_customer_trx_lines l

1954: NVL( SUM(NVL(i.promised_commitment_amount,
1955: i.amount)), 0)
1956: INTO l_commitment_bal
1957: FROM ra_interface_lines i,
1958: ra_customer_trx_lines l
1959: WHERE NVL(interface_status,
1960: 'A') <> 'P'
1961: AND (i.line_type = 'LINE'
1962: OR i.line_type = DECODE(l_allocate_t_f,'Y','FREIGHT','LINE'))

Line 1995: FROM ra_customer_trx trx,

1991: 0
1992: ) * -1
1993: )
1994: INTO l_commitment_bal
1995: FROM ra_customer_trx trx,
1996: ra_cust_trx_types type,
1997: ar_adjustments adj
1998: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
1999: AND trx.initial_customer_trx_id = p_customer_trx_id

Line 2025: FROM ra_customer_trx trx,

2021: ),
2022: 0
2023: )
2024: INTO l_commitment_bal
2025: FROM ra_customer_trx trx,
2026: ra_customer_trx_lines line
2027: WHERE trx.customer_trx_id = line.customer_trx_id
2028: AND trx.previous_customer_trx_id = p_customer_trx_id
2029: AND trx.complete_flag = 'Y';

Line 2026: ra_customer_trx_lines line

2022: 0
2023: )
2024: INTO l_commitment_bal
2025: FROM ra_customer_trx trx,
2026: ra_customer_trx_lines line
2027: WHERE trx.customer_trx_id = line.customer_trx_id
2028: AND trx.previous_customer_trx_id = p_customer_trx_id
2029: AND trx.complete_flag = 'Y';
2030:

Line 2155: FROM ra_customer_trx t,

2151: SELECT NVL(SUM(amount),0),
2152: NVL(SUM(acctd_amount),0)
2153: INTO l_actual_amount1,
2154: l_acctd_amount1
2155: FROM ra_customer_trx t,
2156: ra_cust_trx_types ty,
2157: ar_adjustments a
2158: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2159: and t.customer_trx_id = a.customer_trx_id

Line 2171: FROM ra_customer_trx t,

2167: SELECT NVL(SUM(amount),0),
2168: NVL(SUM(acctd_amount),0)
2169: INTO l_actual_amount1,
2170: l_acctd_amount1
2171: FROM ra_customer_trx t,
2172: ra_cust_trx_types ty,
2173: ar_adjustments a
2174: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2175: and t.customer_trx_id = a.subsequent_trx_id

Line 2187: FROM ra_customer_trx t,

2183: SELECT NVL(SUM(amount),0),
2184: NVL(SUM(acctd_amount),0)
2185: INTO l_actual_amount1,
2186: l_acctd_amount1
2187: FROM ra_customer_trx t,
2188: ra_cust_trx_types ty,
2189: ar_adjustments a
2190: WHERE t.cust_trx_type_id = ty.cust_trx_type_id
2191: and a.subsequent_trx_id IN

Line 2273: FROM RA_CUSTOMER_TRX_LINES

2269: INTO l_count
2270: from ar_activity_details
2271: WHERE customer_trx_line_id in
2272: (SELECT customer_trx_line_id
2273: FROM RA_CUSTOMER_TRX_LINES
2274: WHERE customer_trx_id = p_customer_trx_id)
2275: and nvl(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y'; -- bug 7241111
2276:
2277: IF ( l_count > 0) THEN

Line 2308: IN RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE DEFAULT NULL,

2304: | |
2305: +===========================================================================*/
2306: PROCEDURE trx_line_balances (
2307: p_customer_trx_id
2308: IN RA_CUSTOMER_TRX.CUSTOMER_TRX_ID%TYPE DEFAULT NULL,
2309: p_line_num IN NUMBER DEFAULT NULL,
2310: p_group_id IN NUMBER DEFAULT NULL,
2311: p_exchange_rate IN NUMBER,
2312: p_line_original OUT NOCOPY NUMBER,

Line 2434: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;

2430: l_base_curr_code fnd_currencies.currency_code%type;
2431: l_base_precision fnd_currencies.precision%type;
2432: l_base_min_acc_unit fnd_currencies.minimum_accountable_unit%type;
2433:
2434: l_customer_Trx_line_id ra_customer_Trx_lines.customer_Trx_line_id%type;
2435: BEGIN
2436:
2437: /* initialize the items */
2438:

Line 2468: from ra_customer_Trx_lines

2464: IF (p_line_num IS NOT NULL) THEN
2465:
2466: select customer_Trx_line_id
2467: into l_customer_trx_line_id
2468: from ra_customer_Trx_lines
2469: where line_number = p_line_num
2470: and line_type = 'LINE'
2471: and customer_trx_id = p_customer_trx_id;
2472:

Line 2492: from ra_customer_trx ct,

2488: lines.extended_amount)) -- freight_original
2489: INTO l_line_original,
2490: l_tax_original,
2491: l_freight_original
2492: from ra_customer_trx ct,
2493: ra_customer_trx_lines lines
2494: where (lines.customer_Trx_line_id = l_customer_trx_line_id or
2495: lines.link_to_cust_trx_line_id = l_customer_trx_line_id)
2496: and ct.customer_Trx_id = lines.customer_trx_id

Line 2493: ra_customer_trx_lines lines

2489: INTO l_line_original,
2490: l_tax_original,
2491: l_freight_original
2492: from ra_customer_trx ct,
2493: ra_customer_trx_lines lines
2494: where (lines.customer_Trx_line_id = l_customer_trx_line_id or
2495: lines.link_to_cust_trx_line_id = l_customer_trx_line_id)
2496: and ct.customer_Trx_id = lines.customer_trx_id
2497: and ct.customer_trx_id = p_customer_trx_id;

Line 2548: ra_customer_trx_lines line

2544: INTO
2545: l_charges_receipts,
2546: l_freight_discount
2547: FROM AR_ACTIVITY_DETAILS act,
2548: ra_customer_trx_lines line
2549: WHERE line.customer_Trx_id = p_customer_trx_id
2550: and line.line_number = p_line_num
2551: and line.line_type = 'LINE'
2552: and nvl(act.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- bug 7241111

Line 2562: ra_customer_trx_lines ctl

2558: INTO
2559: l_freight_receipts,
2560: l_base_freight_receipts
2561: FROM ar_distributions ard,
2562: ra_customer_trx_lines ctl
2563: WHERE ard.source_table = 'RA'
2564: AND ard.source_id in (select receivable_application_id
2565: from ar_receivable_applications
2566: where status = 'APP' and

Line 2663: ra_customer_trx_lines lines

2659: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2660: INTO l_tax_adjustments,
2661: l_base_tax_adjustments
2662: from ar_distributions dist,
2663: ra_customer_trx_lines lines
2664: where lines.link_to_cust_trx_line_id = l_customer_trx_line_id
2665: and lines.line_type = 'TAX'
2666: and dist.ref_customer_trx_line_id = lines.customer_trx_line_id
2667: and dist.source_table = 'ADJ'

Line 2676: ra_customer_trx_lines lines

2672: NVL(sum(NVL(acctd_amount_cr,0) - NVL(acctd_amount_dr,0)),0)
2673: INTO l_freight_adjustments,
2674: l_base_freight_adjustments
2675: from ar_distributions dist,
2676: ra_customer_trx_lines lines
2677: where lines.link_to_cust_trx_line_id = l_customer_trx_line_id
2678: and dist.ref_customer_trx_line_id = lines.link_to_cust_trx_line_id
2679: and lines.line_type = 'FREIGHT'
2680: and dist.source_table = 'ADJ'