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 353: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;

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

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

450: l_line_act_credits NUMBER;
451: l_tax_act_credits NUMBER;
452: l_freight_act_credits NUMBER;
453:
454: l_trx_type ra_cust_trx_types.type%TYPE; /* 07-AUG-2000 J Rautiainen BR Implementation */
455: /*Bug 2319665*/
456: l_run_adj_tot NUMBER;
457: l_base_run_adj_tot NUMBER;
458:

Line 491: FROM ra_cust_trx_types ctt,

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

Line 502: FROM ra_cust_trx_types ctt,

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

Line 1957: l_commitment_class ra_cust_trx_types.type%type;

1953: p_so_source_code IN varchar2 )
1954: RETURN NUMBER IS
1955:
1956: l_commitment_bal number;
1957: l_commitment_class ra_cust_trx_types.type%type;
1958: l_currency_code fnd_currencies.currency_code%type;
1959: /* 1580737 - holds subsequent_trx_type_id */
1960: l_sub_inv_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
1961: /* 1483656 - holds the allocation flag */

Line 1960: l_sub_inv_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;

1956: l_commitment_bal number;
1957: l_commitment_class ra_cust_trx_types.type%type;
1958: l_currency_code fnd_currencies.currency_code%type;
1959: /* 1580737 - holds subsequent_trx_type_id */
1960: l_sub_inv_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
1961: /* 1483656 - holds the allocation flag */
1962: l_allocate_t_f ra_cust_trx_types.allocate_tax_freight%type;
1963:
1964: BEGIN

Line 1962: l_allocate_t_f ra_cust_trx_types.allocate_tax_freight%type;

1958: l_currency_code fnd_currencies.currency_code%type;
1959: /* 1580737 - holds subsequent_trx_type_id */
1960: l_sub_inv_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
1961: /* 1483656 - holds the allocation flag */
1962: l_allocate_t_f ra_cust_trx_types.allocate_tax_freight%type;
1963:
1964: BEGIN
1965:
1966: IF (

Line 1993: ra_cust_trx_types type

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

Line 2055: from ra_cust_trx_types ty

2051: AND l.customer_trx_id = p_customer_trx_id
2052: AND i.interface_line_context = p_so_source_code
2053: AND (EXISTS
2054: ( select 'valid_trx_type'
2055: from ra_cust_trx_types ty
2056: where (i.cust_trx_type_name = ty.name OR
2057: i.cust_trx_type_id = ty.cust_trx_type_id)
2058: AND ty.type = 'INV')
2059: OR (i.cust_trx_type_name is null AND

Line 2083: ra_cust_trx_types type,

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

Line 2243: ra_cust_trx_types ty,

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

Line 2259: ra_cust_trx_types ty,

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

Line 2275: ra_cust_trx_types ty,

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