APPS.ARP_AUTO_ACCOUNTING dependencies on RA_CUSTOMER_TRX_LINES

Line 1653: ra_customer_trx_lines l,

1649: SELECT nvl(c.code_combination_id,-1)
1650: INTO p_ccid_rev
1651: FROM
1652: ra_customer_trx t,
1653: ra_customer_trx_lines l,
1654: mtl_item_categories i,
1655: so_agreements a,
1656: ra_account_combinations c
1657: WHERE t.customer_trx_id = l.customer_trx_id

Line 2405: 'ra_customer_trx_lines ctl_line,';

2401: IF( p_account_class in ( TAX, FREIGHT ) ) THEN
2402:
2403: /* 4558268 - Removed tax tables */
2404: l_tax_table := CRLF ||
2405: 'ra_customer_trx_lines ctl_line,';
2406:
2407: END IF;
2408:
2409: IF( p_account_class = REC ) THEN

Line 2662: 'SELECT /*+ leading(ct) index(ct,RA_CUSTOMER_TRX_N15) index(ctl,RA_CUSTOMER_TRX_LINES_N4) use_hash(ctl) */ ' || CRLF;

2658: /* 7039838 - changed hints for FT tuning */
2659: IF p_request_id IS NOT NULL
2660: THEN
2661: l_select_stmt :=
2662: 'SELECT /*+ leading(ct) index(ct,RA_CUSTOMER_TRX_N15) index(ctl,RA_CUSTOMER_TRX_LINES_N4) use_hash(ctl) */ ' || CRLF;
2663: ELSE
2664: l_select_stmt := 'SELECT' || CRLF;
2665: END IF;
2666:

Line 2701: ra_customer_trx_lines ctl,

2697: 'fnd_currencies fc_foreign,'
2698: || l_gl_dist_table
2699: || CRLF ||
2700: 'ra_cust_trx_line_gl_dist rgd,
2701: ra_customer_trx_lines ctl,
2702: ra_customer_trx ct
2703: WHERE ct.customer_trx_id = ctl.customer_trx_id(+)
2704: AND ct.invoice_currency_code = fc_foreign.currency_code'
2705: || l_cm_module_pred

Line 4870: FROM ra_customer_trx_lines ctl, ra_customer_trx ct

4866: l_ctlid_pred := CRLF ||
4867: 'AND customer_trx_line_id in
4868: (
4869: SELECT customer_trx_line_id
4870: FROM ra_customer_trx_lines ctl, ra_customer_trx ct
4871: WHERE ct.customer_trx_id=ctl.customer_trx_id AND nvl(ct.invoicing_rule_id,-10) = -2 AND (ctl.customer_trx_line_id = '
4872: || to_char( p_customer_trx_line_id ) || CRLF ||
4873: ' or ctl.link_to_cust_trx_line_id = '
4874: || to_char( p_customer_trx_line_id ) || ')' || CRLF ||

Line 4883: FROM ra_customer_trx_lines ctl

4879: l_ctlid_pred := CRLF ||
4880: 'AND customer_trx_line_id in
4881: (
4882: SELECT customer_trx_line_id
4883: FROM ra_customer_trx_lines ctl
4884: WHERE (ctl.customer_trx_line_id = '
4885: || to_char( p_customer_trx_line_id ) || CRLF ||
4886: ' or ctl.link_to_cust_trx_line_id = '
4887: || to_char( p_customer_trx_line_id ) || ')' || CRLF ||

Line 5837: select customer_trx_line_id from ra_customer_trx_lines

5833:
5834: /*9112739*/
5835: l_collect ar_revenue_management_pvt.long_number_table;
5836: cursor c_trx_lines(p_customer_trx_id in number) IS
5837: select customer_trx_line_id from ra_customer_trx_lines
5838: where customer_trx_id = p_customer_trx_id
5839: and line_type = 'LINE';
5840:
5841: BEGIN

Line 6604: l_line_type ra_customer_trx_lines.line_type%type;

6600: l_no_rows_suspense BOOLEAN := FALSE;
6601: l_no_rows_charges BOOLEAN := FALSE;
6602: l_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
6603: l_create_clearing_flag ra_batch_sources.create_clearing_flag%type;
6604: l_line_type ra_customer_trx_lines.line_type%type;
6605: BEGIN
6606:
6607: debug( ' Processing ALL mode...', MSG_LEVEL_DEBUG );
6608:

Line 6625: FROM ra_customer_trx_lines

6621: IF ( p_customer_trx_line_id IS NOT NULL )
6622: THEN
6623: SELECT line_type
6624: INTO l_line_type
6625: FROM ra_customer_trx_lines
6626: WHERE customer_trx_line_id = p_customer_trx_line_id;
6627: END IF;
6628:
6629: BEGIN