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_CUST_TRX_TYPES

Line 295: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;

291: p_base_acharges_adjustments OUT NOCOPY NUMBER,
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;

Line 392: l_trx_type ra_cust_trx_types.type%TYPE; /* 07-AUG-2000 J Rautiainen BR Implementation */

388: l_freight_credits1 NUMBER;
389: l_line_credits2 NUMBER;
390: l_tax_credits2 NUMBER;
391: l_freight_credits2 NUMBER;
392: l_trx_type ra_cust_trx_types.type%TYPE; /* 07-AUG-2000 J Rautiainen BR Implementation */
393: /*Bug 2319665*/
394: l_run_adj_tot NUMBER;
395: l_base_run_adj_tot NUMBER;
396:

Line 427: FROM ra_cust_trx_types ctt,

423: ctt.type
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

Line 438: FROM ra_cust_trx_types ctt,

434: * the accounting is stored in ar_distributions
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:

Line 1870: l_commitment_class ra_cust_trx_types.type%type;

1866: p_so_source_code IN varchar2 )
1867: RETURN NUMBER IS
1868:
1869: l_commitment_bal number;
1870: l_commitment_class ra_cust_trx_types.type%type;
1871: l_currency_code fnd_currencies.currency_code%type;
1872: /* 1580737 - holds subsequent_trx_type_id */
1873: l_sub_inv_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
1874: /* 1483656 - holds the allocation flag */

Line 1873: l_sub_inv_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;

1869: l_commitment_bal number;
1870: l_commitment_class ra_cust_trx_types.type%type;
1871: l_currency_code fnd_currencies.currency_code%type;
1872: /* 1580737 - holds subsequent_trx_type_id */
1873: l_sub_inv_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
1874: /* 1483656 - holds the allocation flag */
1875: l_allocate_t_f ra_cust_trx_types.allocate_tax_freight%type;
1876:
1877: BEGIN

Line 1875: l_allocate_t_f ra_cust_trx_types.allocate_tax_freight%type;

1871: l_currency_code fnd_currencies.currency_code%type;
1872: /* 1580737 - holds subsequent_trx_type_id */
1873: l_sub_inv_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
1874: /* 1483656 - holds the allocation flag */
1875: l_allocate_t_f ra_cust_trx_types.allocate_tax_freight%type;
1876:
1877: BEGIN
1878:
1879: IF (

Line 1906: ra_cust_trx_types type

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
1910: AND trx.bill_to_customer_id = cust_acct.cust_account_id

Line 1968: from ra_cust_trx_types ty

1964: AND l.customer_trx_id = p_customer_trx_id
1965: AND i.interface_line_context = p_so_source_code
1966: AND (EXISTS
1967: ( select 'valid_trx_type'
1968: from ra_cust_trx_types ty
1969: where (i.cust_trx_type_name = ty.name OR
1970: i.cust_trx_type_id = ty.cust_trx_type_id)
1971: AND ty.type = 'INV')
1972: OR (i.cust_trx_type_name is null AND

Line 1996: ra_cust_trx_types type,

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
2000: AND trx.complete_flag = 'Y'

Line 2156: ra_cust_trx_types ty,

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
2160: and ty.type not in ('DEP', 'GUAR')

Line 2172: ra_cust_trx_types ty,

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
2176: and ty.type not in ('DEP', 'GUAR')

Line 2188: ra_cust_trx_types ty,

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
2192: (select cma.customer_trx_id