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.FUN_NET_ARAP_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 36: txn_curr_amt ra_customer_trx_lines.extended_amount%TYPE,

32: amt_remaining ar_payment_schedules.amount_due_remaining%TYPE,
33: txn_amt fun_net_ar_txns.transaction_amt%TYPE,
34: open_amt fun_net_ar_txns.open_amt%TYPE,
35: txn_curr_open_amt fun_net_ar_txns.txn_curr_open_amt%TYPE,
36: txn_curr_amt ra_customer_trx_lines.extended_amount%TYPE,
37: txn_curr_net_amt fun_net_ar_txns.txn_curr_net_amt%TYPE,
38: net_amt fun_net_ar_txns.netted_amt%TYPE,
39: invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE,
40: payment_type_code ar_receipt_methods.payment_type_code%TYPE);

Line 2325: ra_customer_trx_lines_all lines

2321: BEGIN
2322: SELECT sum(amount)
2323: INTO l_total_amount
2324: from ra_cust_trx_line_gl_dist dist,
2325: ra_customer_trx_lines_all lines
2326: Where lines.customer_trx_id = p_customer_trx_id
2327: And lines.customer_trx_line_id = dist.customer_trx_line_id
2328: And dist.account_class <> 'REC';
2329: RETURN l_total_amount;

Line 3598: RA_CUSTOMER_TRX_LINES trx_line,

3594: arm.name AS receipt_name,
3595: arm.payment_type_code AS payment_type_code
3596: FROM FUN_NET_AR_TXNS ftxn,
3597: RA_CUSTOMER_TRX trx,
3598: RA_CUSTOMER_TRX_LINES trx_line,
3599: AR_PAYMENT_SCHEDULES ARPS,
3600: AR_RECEIPT_METHODS arm
3601: WHERE ftxn.customer_trx_id = trx.customer_trx_id
3602: AND trx.customer_trx_id = trx_line.customer_trx_id

Line 3626: l_inv_amt ra_customer_trx_lines.extended_amount%TYPE;

3622: x_return_status OUT NOCOPY VARCHAR2
3623: )
3624: IS
3625: l_old_invoice ra_customer_trx.customer_trx_id%TYPE;
3626: l_inv_amt ra_customer_trx_lines.extended_amount%TYPE;
3627: l_path VARCHAR2(100);
3628: round_diff ra_customer_trx_lines.extended_amount%TYPE;
3629: l_count_test number;
3630: BEGIN

Line 3628: round_diff ra_customer_trx_lines.extended_amount%TYPE;

3624: IS
3625: l_old_invoice ra_customer_trx.customer_trx_id%TYPE;
3626: l_inv_amt ra_customer_trx_lines.extended_amount%TYPE;
3627: l_path VARCHAR2(100);
3628: round_diff ra_customer_trx_lines.extended_amount%TYPE;
3629: l_count_test number;
3630: BEGIN
3631: x_return_status := FND_API.G_TRUE;
3632: l_path := g_path || 'Validate AR Transactions';

Line 3871: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;

3867: (txnTable IN txnTblType,
3868: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3869: x_return_status OUT NOCOPY VARCHAR2)
3870: IS
3871: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3872: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3873: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3874: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3875: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;

Line 3872: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;

3868: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3869: x_return_status OUT NOCOPY VARCHAR2)
3870: IS
3871: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3872: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3873: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3874: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3875: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3876: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;

Line 3873: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;

3869: x_return_status OUT NOCOPY VARCHAR2)
3870: IS
3871: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3872: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3873: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3874: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3875: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3876: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;
3877: l_return_status VARCHAR2(1);

Line 3875: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;

3871: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3872: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3873: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3874: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3875: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3876: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;
3877: l_return_status VARCHAR2(1);
3878: l_exchange_rate_type varchar2(20);
3879: l_exchange_rate_date fun_net_batches.settlement_date%TYPE;

Line 3876: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;

3872: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3873: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3874: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3875: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3876: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;
3877: l_return_status VARCHAR2(1);
3878: l_exchange_rate_type varchar2(20);
3879: l_exchange_rate_date fun_net_batches.settlement_date%TYPE;
3880: l_msg_count NUMBER;

Line 3888: ra_customer_trx_lines trx_line,

3884: SELECT trx_line.customer_trx_line_id AS cust_trx_line_id,
3885: trx_line.extended_amount AS extended_amount,
3886: ps.payment_schedule_id AS pymt_schedule_id
3887: FROM fun_net_ar_txns ftxn,
3888: ra_customer_trx_lines trx_line,
3889: ar_payment_schedules ps
3890: WHERE ftxn.batch_id = g_batch_details.batch_id
3891: AND ftxn.customer_trx_id = p_cust_trx_id
3892: AND trx_line.customer_trx_id = ftxn.customer_trx_id

Line 3974: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;

3970: (txnTable IN txnTblType,
3971: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3972: x_return_status OUT NOCOPY VARCHAR2)
3973: IS
3974: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3975: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3976: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3977: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3978: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;

Line 3975: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;

3971: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3972: x_return_status OUT NOCOPY VARCHAR2)
3973: IS
3974: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3975: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3976: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3977: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3978: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3979: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 3976: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;

3972: x_return_status OUT NOCOPY VARCHAR2)
3973: IS
3974: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3975: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3976: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3977: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3978: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3979: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3980: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;

Line 3977: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;

3973: IS
3974: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3975: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3976: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3977: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3978: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3979: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3980: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3981: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;

Line 3978: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;

3974: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3975: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3976: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3977: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3978: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3979: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3980: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3981: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
3982: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;

Line 3980: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;

3976: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3977: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3978: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3979: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3980: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3981: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
3982: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;
3983: l_trans_to_func_rate fun_net_batches_all.exchange_rate%TYPE;
3984: l_func_to_trans_rate fun_net_batches_all.exchange_rate%TYPE;

Line 3982: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;

3978: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3979: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3980: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3981: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
3982: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;
3983: l_trans_to_func_rate fun_net_batches_all.exchange_rate%TYPE;
3984: l_func_to_trans_rate fun_net_batches_all.exchange_rate%TYPE;
3985: l_return_status VARCHAR2(1);
3986: l_exchange_rate_type varchar2(20);

Line 4023: FROM ra_customer_trx_lines trx_line

4019: SELECT trx_line.customer_trx_line_id AS cust_trx_line_id,
4020: trx_line.extended_amount AS extended_amount,
4021: trx_line.line_type AS line_type,
4022: trx_line.amount_due_remaining AS line_am_due_remaining
4023: FROM ra_customer_trx_lines trx_line
4024: WHERE trx_line.customer_trx_id = p_cust_trx_id
4025: AND trx_line.line_type IN ('LINE');
4026: BEGIN
4027: l_path := g_path || 'Apply Cash Receipt';

Line 4159: FROM ra_customer_trx_lines trx_line_tax

4155: SELECT trx_line.customer_trx_line_id AS cust_trx_line_id,
4156: trx_line.line_number AS line_number,'','',
4157: round(((((nvl(trx_line.amount_due_remaining,trx_line.extended_amount)/current_amt_due)*l_applied_amt) +
4158: ( select nvl((sum( nvl(trx_line_tax.amount_due_remaining,trx_line_tax.extended_amount) )/current_amt_due)*l_applied_amt,0)
4159: FROM ra_customer_trx_lines trx_line_tax
4160: WHERE trx_line_tax.link_to_cust_trx_line_id = trx_line.customer_trx_line_id
4161: AND trx_line_tax.customer_trx_id = trx_line.customer_trx_id
4162: AND trx_line_tax.line_type IN ('TAX') ))),l_precision) AS amount_applied,'',
4163: round(nvl(((nvl(trx_line.amount_due_remaining,trx_line.extended_amount)/current_amt_due)*l_discount_amount),0),l_precision) AS line_discount,

Line 4166: FROM ra_customer_trx_lines trx_line

4162: AND trx_line_tax.line_type IN ('TAX') ))),l_precision) AS amount_applied,'',
4163: round(nvl(((nvl(trx_line.amount_due_remaining,trx_line.extended_amount)/current_amt_due)*l_discount_amount),0),l_precision) AS line_discount,
4164: '','','','','','','','','','','','','','','','',''
4165: BULK COLLECT INTO llca_def_trx_lines_tbl
4166: FROM ra_customer_trx_lines trx_line
4167: WHERE trx_line.customer_trx_id = txnTable(i).customer_trx_id
4168: AND trx_line.line_type IN ('LINE')
4169: AND nvl(trx_line.amount_due_remaining,trx_line.extended_amount) <> 0 ;
4170: EXCEPTION

Line 4180: FROM ra_customer_trx_lines trx_line_tax

4176: SELECT trx_line.customer_trx_line_id AS cust_trx_line_id,
4177: trx_line.line_number AS line_number,'','',
4178: round(((((nvl(trx_line.amount_due_remaining,trx_line.extended_amount)/current_amt_due)*l_applied_amt) +
4179: ( select nvl((sum( nvl(trx_line_tax.amount_due_remaining,trx_line_tax.extended_amount) )/current_amt_due)*l_applied_amt,0)
4180: FROM ra_customer_trx_lines trx_line_tax
4181: WHERE trx_line_tax.link_to_cust_trx_line_id = trx_line.customer_trx_line_id
4182: AND trx_line_tax.customer_trx_id = trx_line.customer_trx_id
4183: AND trx_line_tax.line_type IN ('TAX') ))),l_precision) AS amount_applied,'','','','','','','','','','','','','','','','','','',''
4184: BULK COLLECT INTO llca_def_trx_lines_tbl

Line 4185: FROM ra_customer_trx_lines trx_line

4181: WHERE trx_line_tax.link_to_cust_trx_line_id = trx_line.customer_trx_line_id
4182: AND trx_line_tax.customer_trx_id = trx_line.customer_trx_id
4183: AND trx_line_tax.line_type IN ('TAX') ))),l_precision) AS amount_applied,'','','','','','','','','','','','','','','','','','',''
4184: BULK COLLECT INTO llca_def_trx_lines_tbl
4185: FROM ra_customer_trx_lines trx_line
4186: WHERE trx_line.customer_trx_id = txnTable(i).customer_trx_id
4187: AND trx_line.line_type IN ('LINE')
4188: AND nvl(trx_line.amount_due_remaining,trx_line.extended_amount) <> 0 ;
4189: EXCEPTION

Line 4198: FROM ra_customer_trx_lines trx_line

4194: -- get the freight amount
4195: SELECT round(SUM((nvl(trx_line.amount_due_remaining,trx_line.extended_amount)
4196: /current_amt_due)*l_applied_amt),l_precision)
4197: INTO l_freight_amount
4198: FROM ra_customer_trx_lines trx_line
4199: WHERE trx_line.customer_trx_id = txnTable(i).customer_trx_id
4200: AND trx_line.line_type IN ('FREIGHT')
4201: AND nvl(trx_line.amount_due_remaining,trx_line.extended_amount) <> 0 ;
4202: fun_net_util.Log_String(g_event_level,l_path