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 41: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,

37: TYPE pymt_sch_tab IS TABLE OF pymt_sch_rec INDEX BY BINARY_INTEGER;
38:
39: TYPE txnRecType IS RECORD
40: (
41: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
42: exchange_rate ra_customer_trx.exchange_rate%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,

Line 42: exchange_rate ra_customer_trx.exchange_rate%TYPE,

38:
39: TYPE txnRecType IS RECORD
40: (
41: customer_trx_id ra_customer_trx.customer_trx_id%TYPE,
42: exchange_rate ra_customer_trx.exchange_rate%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,

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 50: invoice_currency_code ra_customer_trx.invoice_currency_code%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);
52:
53: TYPE txnTblType IS TABLE OF txnRecType INDEX BY BINARY_INTEGER;
54: TYPE arReceiptRecType IS RECORD

Line 58: exchange_rate ra_customer_trx.exchange_rate%TYPE,

54: TYPE arReceiptRecType IS RECORD
55: (
56: currency_code fun_net_batches.batch_currency%TYPE,
57: exchange_rate_type fun_net_batches.exchange_rate_type%TYPE,
58: exchange_rate ra_customer_trx.exchange_rate%TYPE,
59: exchange_rate_date ra_customer_trx.exchange_date%TYPE,
60: amount fun_net_batches.total_netted_amt%TYPE,
61: factor_discount_amount fun_net_batches.total_netted_amt%TYPE,
62: receipt_number ar_cash_receipts.receipt_number%TYPE,

Line 59: exchange_rate_date ra_customer_trx.exchange_date%TYPE,

55: (
56: currency_code fun_net_batches.batch_currency%TYPE,
57: exchange_rate_type fun_net_batches.exchange_rate_type%TYPE,
58: exchange_rate ra_customer_trx.exchange_rate%TYPE,
59: exchange_rate_date ra_customer_trx.exchange_date%TYPE,
60: amount fun_net_batches.total_netted_amt%TYPE,
61: factor_discount_amount fun_net_batches.total_netted_amt%TYPE,
62: receipt_number ar_cash_receipts.receipt_number%TYPE,
63: receipt_date ar_cash_receipts.receipt_date%TYPE,

Line 322: ' FROM ra_customer_trx_all rct,

318: sum(arps.amount_due_remaining) AS open_amount ' ;
319: fun_net_util.Log_String(g_state_level,l_path,'SELECT : '||l_trx_select_clause);
320:
321: l_trx_from_clause :=
322: ' FROM ra_customer_trx_all rct,
323: ar_payment_schedules_all arps,
324: ra_cust_trx_types_all rctt,
325: fun_net_customers_all fnc ';
326: fun_net_util.Log_String(g_state_level,l_path,'FROM : '||l_trx_from_clause);

Line 1402: FROM ra_customer_trx_all rct, fun_net_ar_txns_all fnart

1398: WHERE api.invoice_id = fnapi.invoice_id
1399: AND fnapi.batch_id = g_batch_id
1400: UNION
1401: SELECT INVOICE_CURRENCY_CODE
1402: FROM ra_customer_trx_all rct, fun_net_ar_txns_all fnart
1403: WHERE rct.customer_trx_id = fnart.customer_trx_id
1404: AND fnart.batch_id = g_batch_id;
1405:
1406: l_count NUMBER;

Line 1547: FROM ra_customer_trx_all rct, fnd_currencies fc

1543: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);
1544: ELSIF p_appln = 'AR' THEN
1545: SELECT fc.currency_code,fc.precision
1546: INTO l_inv_currency,l_precision
1547: FROM ra_customer_trx_all rct, fnd_currencies fc
1548: WHERE rct.customer_trx_id = l_trx_id(i)
1549: AND rct.invoice_currency_code = fc.currency_code;
1550:
1551: l_inv_curr_net_amt(i) := l_amt_to_net * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);

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

1898: elsif (g_net_currency_rule = 'WITHIN_CURRENCY') then
1899:
1900: SELECT count (DISTINCT rac.invoice_currency_code)
1901: into l_count
1902: FROM ra_customer_trx_all rac,fun_net_ar_txns_all fnar
1903: WHERE rac.customer_trx_id = fnar.customer_trx_id
1904: AND fnar.batch_id = g_batch_id
1905: AND rac.invoice_currency_code <> g_func_currency;
1906:

Line 2892: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,

2888: /* Calculates the Total Open Amount for an AR Transaction based on the
2889: Due date of the batch */
2890:
2891: FUNCTION Calculate_AR_Txn_Open_Amt(
2892: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
2893: p_inv_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
2894: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE)
2895: RETURN NUMBER
2896: IS

Line 2893: p_inv_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,

2889: Due date of the batch */
2890:
2891: FUNCTION Calculate_AR_Txn_Open_Amt(
2892: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
2893: p_inv_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
2894: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE)
2895: RETURN NUMBER
2896: IS
2897: l_amount ar_payment_schedules.amount_due_remaining%TYPE;

Line 2894: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE)

2890:
2891: FUNCTION Calculate_AR_Txn_Open_Amt(
2892: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
2893: p_inv_currency_code IN ra_customer_trx.invoice_currency_code%TYPE,
2894: p_exchange_rate IN ra_customer_trx.exchange_rate%TYPE)
2895: RETURN NUMBER
2896: IS
2897: l_amount ar_payment_schedules.amount_due_remaining%TYPE;
2898: BEGIN

Line 2944: RA_CUSTOMER_TRX trx,

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

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

2971: x_return_status OUT NOCOPY VARCHAR2
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;

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

2996: trx.invoice_currency_code AS invoice_currency_code,
2997: arm.payment_type_code AS payment_type_code
2998: BULK COLLECT INTO txnTable
2999: FROM FUN_NET_AR_TXNS ftxn,
3000: RA_CUSTOMER_TRX trx,
3001: AR_PAYMENT_SCHEDULES ARPS,
3002: AR_RECEIPT_METHODS arm,
3003: RA_CUST_TRX_TYPES ctype
3004: WHERE ftxn.customer_trx_id = trx.customer_trx_id

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:

Line 3590: FROM ra_batch_sources bs, ra_customer_trx ct

3586:
3587: */ -- Commented this for issue no : 7368248
3588:
3589: SELECT count(*) into l_line_or_header
3590: FROM ra_batch_sources bs, ra_customer_trx ct
3591: WHERE ct.customer_trx_id = txnTable(i).customer_trx_id AND
3592: ct.batch_Source_id = bs.batch_source_id AND
3593: NVL(gen_line_level_bal_flag,'Y') = 'Y';
3594: