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 47: txn_curr_amt ra_customer_trx_lines.extended_amount%TYPE,

43: amt_remaining ar_payment_schedules.amount_due_remaining%TYPE,
44: txn_amt fun_net_ar_txns.transaction_amt%TYPE,
45: open_amt fun_net_ar_txns.open_amt%TYPE,
46: txn_curr_open_amt fun_net_ar_txns.txn_curr_open_amt%TYPE,
47: txn_curr_amt ra_customer_trx_lines.extended_amount%TYPE,
48: txn_curr_net_amt fun_net_ar_txns.txn_curr_net_amt%TYPE,
49: net_amt fun_net_ar_txns.netted_amt%TYPE,
50: invoice_currency_code ra_customer_trx.invoice_currency_code%TYPE,
51: payment_type_code ar_receipt_methods.payment_type_code%TYPE);

Line 1605: ra_customer_trx_lines_all lines

1601:
1602: SELECT sum(amount)
1603: INTO l_total_amount
1604: from ra_cust_trx_line_gl_dist dist,
1605: ra_customer_trx_lines_all lines
1606: Where lines.customer_trx_id = p_customer_trx_id
1607: And lines.customer_trx_line_id = dist.customer_trx_line_id
1608: And dist.account_class <> 'REC';
1609: RETURN l_total_amount;

Line 2945: RA_CUSTOMER_TRX_LINES trx_line,

2941: arm.name AS receipt_name,
2942: arm.payment_type_code AS payment_type_code
2943: FROM FUN_NET_AR_TXNS ftxn,
2944: RA_CUSTOMER_TRX trx,
2945: RA_CUSTOMER_TRX_LINES trx_line,
2946: AR_PAYMENT_SCHEDULES ARPS,
2947: AR_RECEIPT_METHODS arm
2948: WHERE ftxn.customer_trx_id = trx.customer_trx_id
2949: AND trx.customer_trx_id = trx_line.customer_trx_id

Line 2976: l_inv_amt ra_customer_trx_lines.extended_amount%TYPE;

2972: )
2973: IS
2974:
2975: l_old_invoice ra_customer_trx.customer_trx_id%TYPE;
2976: l_inv_amt ra_customer_trx_lines.extended_amount%TYPE;
2977: l_path VARCHAR2(100);
2978: round_diff ra_customer_trx_lines.extended_amount%TYPE;
2979: l_count_test number;
2980:

Line 2978: round_diff ra_customer_trx_lines.extended_amount%TYPE;

2974:
2975: l_old_invoice ra_customer_trx.customer_trx_id%TYPE;
2976: l_inv_amt ra_customer_trx_lines.extended_amount%TYPE;
2977: l_path VARCHAR2(100);
2978: round_diff ra_customer_trx_lines.extended_amount%TYPE;
2979: l_count_test number;
2980:
2981: BEGIN
2982: x_return_status := FND_API.G_TRUE;

Line 3216: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;

3212: (txnTable IN txnTblType,
3213: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3214: x_return_status OUT NOCOPY VARCHAR2)
3215: IS
3216: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3217: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3218: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3219: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3220: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;

Line 3217: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;

3213: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3214: x_return_status OUT NOCOPY VARCHAR2)
3215: IS
3216: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3217: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3218: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3219: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3220: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3221: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;

Line 3218: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;

3214: x_return_status OUT NOCOPY VARCHAR2)
3215: IS
3216: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3217: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3218: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3219: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3220: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3221: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;
3222: l_return_status VARCHAR2(1);

Line 3220: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;

3216: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3217: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3218: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3219: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3220: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3221: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;
3222: l_return_status VARCHAR2(1);
3223:
3224: l_exchange_rate_type varchar2(20);

Line 3221: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;

3217: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3218: l_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3219: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3220: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3221: l_exchange_rate ra_customer_trx_lines.extended_amount%TYPE;
3222: l_return_status VARCHAR2(1);
3223:
3224: l_exchange_rate_type varchar2(20);
3225: l_exchange_rate_date fun_net_batches.settlement_date%TYPE;

Line 3235: ra_customer_trx_lines trx_line,

3231: SELECT trx_line.customer_trx_line_id AS cust_trx_line_id,
3232: trx_line.extended_amount AS extended_amount,
3233: ps.payment_schedule_id AS pymt_schedule_id
3234: FROM fun_net_ar_txns ftxn,
3235: ra_customer_trx_lines trx_line,
3236: ar_payment_schedules ps
3237: WHERE ftxn.batch_id = g_batch_details.batch_id
3238: AND ftxn.customer_trx_id = p_cust_trx_id
3239: AND trx_line.customer_trx_id = ftxn.customer_trx_id

Line 3345: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;

3341: (txnTable IN txnTblType,
3342: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3343: x_return_status OUT NOCOPY VARCHAR2)
3344: IS
3345: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3346: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3347: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3348: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3349: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;

Line 3346: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;

3342: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
3343: x_return_status OUT NOCOPY VARCHAR2)
3344: IS
3345: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3346: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3347: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3348: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3349: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3350: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;

Line 3347: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;

3343: x_return_status OUT NOCOPY VARCHAR2)
3344: IS
3345: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3346: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3347: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3348: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3349: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3350: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3351: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;

Line 3348: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;

3344: IS
3345: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3346: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3347: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3348: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3349: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3350: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3351: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3352: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;

Line 3349: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;

3345: l_applied_amt ra_customer_trx_lines.extended_amount%TYPE;
3346: l_applied_line_amt ra_customer_trx_lines.extended_amount%TYPE;
3347: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3348: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3349: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3350: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3351: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3352: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
3353: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;

Line 3351: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;

3347: l_tax_amount ra_customer_trx_lines.extended_amount%TYPE;
3348: l_open_amt ra_customer_trx_lines.extended_amount%TYPE;
3349: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3350: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3351: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3352: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
3353: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;
3354: l_trans_to_func_rate fun_net_batches_all.exchange_rate%TYPE;
3355: l_func_to_trans_rate fun_net_batches_all.exchange_rate%TYPE;

Line 3353: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;

3349: l_running_amt ra_customer_trx_lines.extended_amount%TYPE;
3350: current_amt_due AR_PAYMENT_SCHEDULES.amount_due_remaining%TYPE;
3351: l_applied_from ra_customer_trx_lines.extended_amount%TYPE;
3352: l_exchange_rate fun_net_batches_all.exchange_rate%TYPE;
3353: l_original_amt ra_customer_trx_lines.extended_amount%TYPE;
3354: l_trans_to_func_rate fun_net_batches_all.exchange_rate%TYPE;
3355: l_func_to_trans_rate fun_net_batches_all.exchange_rate%TYPE;
3356: l_return_status VARCHAR2(1);
3357:

Line 3387: FROM ra_customer_trx_lines trx_line

3383: SELECT trx_line.customer_trx_line_id AS cust_trx_line_id,
3384: trx_line.extended_amount AS extended_amount,
3385: trx_line.line_type AS line_type,
3386: trx_line.amount_due_remaining AS line_am_due_remaining
3387: FROM ra_customer_trx_lines trx_line
3388: WHERE trx_line.customer_trx_id = p_cust_trx_id
3389: AND trx_line.line_type IN ('LINE');
3390:
3391:

Line 3529: FROM ra_customer_trx_lines trx_line_tax

3525: SELECT trx_line.customer_trx_line_id AS cust_trx_line_id,
3526: trx_line.line_number AS line_number,'','',
3527: round(((((nvl(trx_line.amount_due_remaining,trx_line.extended_amount)/current_amt_due)*l_applied_amt) +
3528: ( select nvl((sum( nvl(trx_line_tax.amount_due_remaining,trx_line_tax.extended_amount) )/current_amt_due)*l_applied_amt,0)
3529: FROM ra_customer_trx_lines trx_line_tax
3530: WHERE trx_line_tax.link_to_cust_trx_line_id = trx_line.customer_trx_line_id
3531: AND trx_line_tax.customer_trx_id = trx_line.customer_trx_id
3532: AND trx_line_tax.line_type IN ('TAX') ))),l_precision) AS amount_applied,'','','','','','','','',''
3533: ,'','','','','','','','','',''

Line 3535: FROM ra_customer_trx_lines trx_line

3531: AND trx_line_tax.customer_trx_id = trx_line.customer_trx_id
3532: AND trx_line_tax.line_type IN ('TAX') ))),l_precision) AS amount_applied,'','','','','','','','',''
3533: ,'','','','','','','','','',''
3534: BULK COLLECT INTO llca_def_trx_lines_tbl
3535: FROM ra_customer_trx_lines trx_line
3536: WHERE trx_line.customer_trx_id = txnTable(i).customer_trx_id
3537: AND trx_line.line_type IN ('LINE')
3538: AND nvl(trx_line.amount_due_remaining,trx_line.extended_amount) <> 0 ;
3539: EXCEPTION

Line 3551: FROM ra_customer_trx_lines trx_line

3547:
3548: SELECT round(SUM((nvl(trx_line.amount_due_remaining,trx_line.extended_amount)
3549: /current_amt_due)*l_applied_amt),l_precision)
3550: INTO l_freight_amount
3551: FROM ra_customer_trx_lines trx_line
3552: WHERE trx_line.customer_trx_id = txnTable(i).customer_trx_id
3553: AND trx_line.line_type IN ('FREIGHT')
3554: AND nvl(trx_line.amount_due_remaining,trx_line.extended_amount) <> 0 ;
3555: