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

Line 30: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,

26: max_payment_num ap_payment_schedules_all.payment_num%TYPE);
27: TYPE pymt_sch_tab IS TABLE OF pymt_sch_rec INDEX BY BINARY_INTEGER;
28: TYPE txnRecType IS RECORD
29: (
30: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
31: exchange_rate ra_customer_trx.exchange_rate%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,

Line 31: exchange_rate ra_customer_trx.exchange_rate%TYPE,

27: TYPE pymt_sch_tab IS TABLE OF pymt_sch_rec INDEX BY BINARY_INTEGER;
28: TYPE txnRecType IS RECORD
29: (
30: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
31: exchange_rate ra_customer_trx.exchange_rate%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,

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 39: invoice_currency_code ra_customer_trx.invoice_currency_code%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);
41: TYPE txnTblType IS TABLE OF txnRecType INDEX BY BINARY_INTEGER;
42: TYPE arReceiptRecType IS RECORD
43: (

Line 46: exchange_rate ra_customer_trx.exchange_rate%TYPE,

42: TYPE arReceiptRecType IS RECORD
43: (
44: currency_code fun_net_batches.batch_currency%TYPE,
45: exchange_rate_type fun_net_batches.exchange_rate_type%TYPE,
46: exchange_rate ra_customer_trx.exchange_rate%TYPE,
47: exchange_rate_date ra_customer_trx.exchange_date%TYPE,
48: amount fun_net_batches.total_netted_amt%TYPE,
49: factor_discount_amount fun_net_batches.total_netted_amt%TYPE,
50: receipt_number ar_cash_receipts.receipt_number%TYPE,

Line 47: exchange_rate_date ra_customer_trx.exchange_date%TYPE,

43: (
44: currency_code fun_net_batches.batch_currency%TYPE,
45: exchange_rate_type fun_net_batches.exchange_rate_type%TYPE,
46: exchange_rate ra_customer_trx.exchange_rate%TYPE,
47: exchange_rate_date ra_customer_trx.exchange_date%TYPE,
48: amount fun_net_batches.total_netted_amt%TYPE,
49: factor_discount_amount fun_net_batches.total_netted_amt%TYPE,
50: receipt_number ar_cash_receipts.receipt_number%TYPE,
51: receipt_date ar_cash_receipts.receipt_date%TYPE,

Line 121: FROM ra_customer_trx_all rct, fnd_currencies fc

117: AND api.invoice_currency_code = fc.currency_code;
118: ELSE
119: SELECT fc.currency_code,fc.precision
120: INTO l_inv_currency,l_precision
121: FROM ra_customer_trx_all rct, fnd_currencies fc
122: WHERE rct.customer_trx_id = p_trx_id
123: AND rct.invoice_currency_code = fc.currency_code;
124: END IF;
125: SELECT BATCH_CURRENCY,SETTLEMENT_DATE,EXCHANGE_RATE_TYPE,EXCHANGE_RATE,ORG_ID

Line 245: l_invoice_currency_code RA_CUSTOMER_TRX_ALL.INVOICE_CURRENCY_CODE%TYPE;

241: l_org_id NUMBER;
242: l_settlement_date DATE;
243: l_currency_code fun_net_batches.batch_currency%TYPE;
244: l_exchange_rate_type fun_net_batches.exchange_rate_type%TYPE;
245: l_invoice_currency_code RA_CUSTOMER_TRX_ALL.INVOICE_CURRENCY_CODE%TYPE;
246: l_path VARCHAR2(100);
247: BEGIN
248: l_path := g_path||'get_ar_discount';
249: l_amt_to_net := p_amt_to_net;

Line 290: from RA_CUSTOMER_TRX_ALL

286: fun_net_util.Log_String(g_state_level,l_path,'l_applieddisc :'|| l_applieddisc);
287: IF(l_net_currency_rule_code = 'ACCOUNTING_CURRENCY' and l_applieddisc > 0) THEN
288: select INVOICE_CURRENCY_CODE
289: into l_invoice_currency_code
290: from RA_CUSTOMER_TRX_ALL
291: where CUSTOMER_TRX_ID = p_cust_txn_id;
292: l_applieddisc := gl_currency_api.convert_amount_sql(l_invoice_currency_code,
293: l_currency_code,
294: trunc(l_settlement_date),

Line 502: ' FROM ra_customer_trx_all rct,

498: sum(arps.amount_due_remaining - ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)) AS OPEN_AMOUNT_AFTERDISC'; -- ADDED FOR ESD ENABLED AGREEMENTS
499: END IF;
500: fun_net_util.Log_String(g_state_level,l_path,'SELECT : '||l_trx_select_clause);
501: l_trx_from_clause :=
502: ' FROM ra_customer_trx_all rct,
503: ar_payment_schedules_all arps,
504: ra_cust_trx_types_all rctt,
505: fun_net_customers_all fnc ';
506: fun_net_util.Log_String(g_state_level,l_path,'FROM : '||l_trx_from_clause);

Line 1713: FROM ra_customer_trx_all rct, fnd_currencies fc

1709: AND api.invoice_currency_code = fc.currency_code;
1710: ELSE
1711: SELECT fc.currency_code,fc.precision
1712: INTO l_inv_currency,l_precision
1713: FROM ra_customer_trx_all rct, fnd_currencies fc
1714: WHERE rct.customer_trx_id = l_trx_id(i)
1715: AND rct.invoice_currency_code = fc.currency_code;
1716: END IF;
1717: l_amt_to_net := round(l_amt_to_net * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency),l_precision);

Line 1782: FROM ra_customer_trx_all rct, fnd_currencies fc

1778: AND api.invoice_currency_code = fc.currency_code;
1779: ELSE
1780: SELECT fc.currency_code,fc.precision
1781: INTO l_inv_currency,l_precision
1782: FROM ra_customer_trx_all rct, fnd_currencies fc
1783: WHERE rct.customer_trx_id = l_trx_id(i)
1784: AND rct.invoice_currency_code = fc.currency_code;
1785: END IF;
1786: l_applieddisc(i):=round(l_applieddisc(i) * Derive_Net_Exchg_Rate(l_inv_currency,g_func_currency),l_precision); -- from ACC CUR t BATCH CUR

Line 1804: FROM ra_customer_trx_all rct, fnd_currencies fc

1800: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);
1801: ELSIF p_appln = 'AR' THEN
1802: SELECT fc.currency_code,fc.precision
1803: INTO l_inv_currency,l_precision
1804: FROM ra_customer_trx_all rct, fnd_currencies fc
1805: WHERE rct.customer_trx_id = l_trx_id(i)
1806: AND rct.invoice_currency_code = fc.currency_code;
1807: l_inv_curr_net_amt(i) := l_net_amt(i) * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
1808: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);

Line 2170: FROM ra_customer_trx_all rct, fun_net_ar_txns_all fnart

2166: WHERE api.invoice_id = fnapi.invoice_id
2167: AND fnapi.batch_id = g_batch_id
2168: UNION
2169: SELECT INVOICE_CURRENCY_CODE
2170: FROM ra_customer_trx_all rct, fun_net_ar_txns_all fnart
2171: WHERE rct.customer_trx_id = fnart.customer_trx_id
2172: AND fnart.batch_id = g_batch_id;
2173: l_count NUMBER;
2174: l_exc_rate NUMBER;

Line 2275: FROM ra_customer_trx_all rct, fnd_currencies fc

2271: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);
2272: ELSIF p_appln = 'AR' THEN
2273: SELECT fc.currency_code,fc.precision
2274: INTO l_inv_currency,l_precision
2275: FROM ra_customer_trx_all rct, fnd_currencies fc
2276: WHERE rct.customer_trx_id = l_trx_id(i)
2277: AND rct.invoice_currency_code = fc.currency_code;
2278: l_inv_curr_net_amt(i) := l_amt_to_net * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
2279: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);

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 2598: FROM ra_customer_trx_all rac,fun_net_ar_txns_all fnar

2594: end if;
2595: elsif (g_net_currency_rule = 'WITHIN_CURRENCY') then
2596: SELECT count (DISTINCT rac.invoice_currency_code)
2597: into l_count
2598: FROM ra_customer_trx_all rac,fun_net_ar_txns_all fnar
2599: WHERE rac.customer_trx_id = fnar.customer_trx_id
2600: AND fnar.batch_id = g_batch_id
2601: AND rac.invoice_currency_code <> g_func_currency;
2602: end if;

Line 3081: ra_customer_trx ract,

3077: --Bug:12982007
3078: SELECT min(cust_account_id), cust_priority
3079: INTO p_cust_acct_id, l_cust_priority
3080: FROM fun_net_customers ca,
3081: ra_customer_trx ract,
3082: fun_net_ar_txns fnar
3083: WHERE ca.agreement_id = g_agreement_id
3084: AND ca.cust_account_id = ract.bill_to_customer_id
3085: AND fnar.customer_trx_id = ract.customer_trx_id

Line 3550: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

3546: END;
3547: /* Calculates the Total Open Amount for an AR Transaction based on the
3548: Due date of the batch */
3549: FUNCTION Calculate_AR_Txn_Open_Amt(
3550: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3551: p_inv_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
3552: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE)
3553: RETURN NUMBER
3554: IS

Line 3551: p_inv_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,

3547: /* Calculates the Total Open Amount for an AR Transaction based on the
3548: Due date of the batch */
3549: FUNCTION Calculate_AR_Txn_Open_Amt(
3550: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3551: p_inv_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
3552: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE)
3553: RETURN NUMBER
3554: IS
3555: l_amount ar_payment_schedules.amount_due_remaining%TYPE;

Line 3552: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE)

3548: Due date of the batch */
3549: FUNCTION Calculate_AR_Txn_Open_Amt(
3550: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
3551: p_inv_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
3552: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE)
3553: RETURN NUMBER
3554: IS
3555: l_amount ar_payment_schedules.amount_due_remaining%TYPE;
3556: BEGIN

Line 3597: RA_CUSTOMER_TRX trx,

3593: trx.invoice_currency_code) receipt_trans_rate,
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

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 3625: l_old_invoice ra_customer_trx.customer_trx_id%TYPE;

3621: txnTable OUT NOCOPY TxnTblType,
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;

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 3650: RA_CUSTOMER_TRX trx,

3646: trx.invoice_currency_code AS invoice_currency_code,
3647: arm.payment_type_code AS payment_type_code
3648: BULK COLLECT INTO txnTable
3649: FROM FUN_NET_AR_TXNS ftxn,
3650: RA_CUSTOMER_TRX trx,
3651: AR_PAYMENT_SCHEDULES ARPS,
3652: AR_RECEIPT_METHODS arm,
3653: RA_CUST_TRX_TYPES ctype
3654: WHERE ftxn.customer_trx_id = trx.customer_trx_id

Line 3699: RA_CUSTOMER_TRX trx,

3695: trx.invoice_currency_code AS invoice_currency_code,
3696: arm.payment_type_code AS payment_type_code
3697: BULK COLLECT INTO txnTable
3698: FROM FUN_NET_AR_TXNS ftxn,
3699: RA_CUSTOMER_TRX trx,
3700: AR_PAYMENT_SCHEDULES ARPS,
3701: AR_RECEIPT_METHODS arm,
3702: RA_CUST_TRX_TYPES ctype
3703: WHERE ftxn.customer_trx_id = trx.customer_trx_id

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

Line 4222: FROM ra_batch_sources bs, ra_customer_trx ct

4218: END LOOP;
4219: */ -- Commented this for issue no : 7368248
4220: fun_net_util.Log_String(g_event_level,l_path,'Before calling select for count');
4221: SELECT count(*) into l_line_or_header
4222: FROM ra_batch_sources bs, ra_customer_trx ct
4223: WHERE ct.customer_trx_id = txnTable(i).customer_trx_id AND
4224: ct.batch_Source_id = bs.batch_source_id AND
4225: NVL(gen_line_level_bal_flag,'Y') = 'Y';
4226: fun_net_util.Log_String(g_event_level,l_path,'After calling select for count l_line_or_header = ' || l_line_or_header);

Line 4463: RA_CUSTOMER_TRX trx,

4459: trx.invoice_currency_code AS invoice_currency_code,
4460: arm.payment_type_code AS payment_type_code
4461: BULK COLLECT INTO txnTable2
4462: FROM FUN_NET_AR_TXNS ftxn,
4463: RA_CUSTOMER_TRX trx,
4464: AR_PAYMENT_SCHEDULES ARPS,
4465: AR_RECEIPT_METHODS arm,
4466: RA_CUST_TRX_TYPES ctype
4467: WHERE ftxn.customer_trx_id = trx.customer_trx_id

Line 4512: RA_CUSTOMER_TRX trx,

4508: trx.invoice_currency_code AS invoice_currency_code,
4509: arm.payment_type_code AS payment_type_code
4510: BULK COLLECT INTO txnTable2
4511: FROM FUN_NET_AR_TXNS ftxn,
4512: RA_CUSTOMER_TRX trx,
4513: AR_PAYMENT_SCHEDULES ARPS,
4514: AR_RECEIPT_METHODS arm,
4515: RA_CUST_TRX_TYPES ctype
4516: WHERE ftxn.customer_trx_id = trx.customer_trx_id