APPS.ARP_AUTO_ACCOUNTING dependencies on RA_CUSTOMER_TRX_LINES

Line 1649: ra_customer_trx_lines l,

1645: SELECT nvl(c.code_combination_id,-1)
1646: INTO p_ccid_rev
1647: FROM
1648: ra_customer_trx t,
1649: ra_customer_trx_lines l,
1650: mtl_item_categories i,
1651: so_agreements a,
1652: ra_account_combinations c
1653: WHERE t.customer_trx_id = l.customer_trx_id

Line 2387: 'ra_customer_trx_lines ctl_line,';

2383: IF( p_account_class in ( TAX, FREIGHT ) ) THEN
2384:
2385: /* 4558268 - Removed tax tables */
2386: l_tax_table := CRLF ||
2387: 'ra_customer_trx_lines ctl_line,';
2388:
2389: END IF;
2390:
2391: IF( p_account_class = REC ) THEN

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

2640: /* 7039838 - changed hints for FT tuning */
2641: IF p_request_id IS NOT NULL
2642: THEN
2643: l_select_stmt :=
2644: 'SELECT /*+ index(ct,RA_CUSTOMER_TRX_N15) index(ctl,RA_CUSTOMER_TRX_LINES_N4) use_hash(ctl) */ ' || CRLF;
2645: ELSE
2646: l_select_stmt := 'SELECT' || CRLF;
2647: END IF;
2648:

Line 2683: ra_customer_trx_lines ctl,

2679: 'fnd_currencies fc_foreign,'
2680: || l_gl_dist_table
2681: || CRLF ||
2682: 'ra_cust_trx_line_gl_dist rgd,
2683: ra_customer_trx_lines ctl,
2684: ra_customer_trx ct
2685: WHERE ct.customer_trx_id = ctl.customer_trx_id(+)
2686: AND ct.invoice_currency_code = fc_foreign.currency_code'
2687: || l_cm_module_pred

Line 4822: FROM ra_customer_trx_lines ctl

4818: l_ctlid_pred := CRLF ||
4819: 'AND customer_trx_line_id in
4820: (
4821: SELECT customer_trx_line_id
4822: FROM ra_customer_trx_lines ctl
4823: WHERE (ctl.customer_trx_line_id = '
4824: || to_char( p_customer_trx_line_id ) || CRLF ||
4825: ' or ctl.link_to_cust_trx_line_id = '
4826: || to_char( p_customer_trx_line_id ) || ')' || CRLF ||

Line 6496: l_line_type ra_customer_trx_lines.line_type%type;

6492: l_no_rows_suspense BOOLEAN := FALSE;
6493: l_no_rows_charges BOOLEAN := FALSE;
6494: l_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;
6495: l_create_clearing_flag ra_batch_sources.create_clearing_flag%type;
6496: l_line_type ra_customer_trx_lines.line_type%type;
6497: BEGIN
6498:
6499: debug( ' Processing ALL mode...', MSG_LEVEL_DEBUG );
6500:

Line 6517: FROM ra_customer_trx_lines

6513: IF ( p_customer_trx_line_id IS NOT NULL )
6514: THEN
6515: SELECT line_type
6516: INTO l_line_type
6517: FROM ra_customer_trx_lines
6518: WHERE customer_trx_line_id = p_customer_trx_line_id;
6519: END IF;
6520:
6521: BEGIN