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.ARP_AUTO_ACCOUNTING dependencies on RA_CUSTOMER_TRX

Line 1652: ra_customer_trx t,

1648:
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

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 2557: ra_customer_trx was resulting in incorrect GL_DATE on

2553: IF p_request_id > 0
2554: THEN
2555:
2556: /* 5169215 - a cartesian join between ra_interface_lines and
2557: ra_customer_trx was resulting in incorrect GL_DATE on
2558: REC distributions. This relates to bug 4483951, but the fix
2559: for that does not entirely resolve the problem */
2560: l_interface_table_pred := CRLF ||
2561: 'AND ril.rowid = (SELECT /*+ no_unnest */ min(ril2.rowid)

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 2702: ra_customer_trx ct

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
2706: || l_prevent_dup_rec_pred

Line 4847: FROM ra_customer_trx ct

4843: l_ctid_pred := CRLF ||
4844: 'AND customer_trx_id in
4845: (
4846: SELECT customer_trx_id
4847: FROM ra_customer_trx ct
4848: WHERE (ct.customer_trx_id = '
4849: || to_char( p_customer_trx_id ) || CRLF ||
4850: ' AND nvl(ct.invoicing_rule_id,-10) = -2 )' || CRLF ||
4851: ')';

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 4930: FROM ra_customer_trx ct

4926: || CRLF ||
4927: 'AND account_set_flag = (SELECT decode(ct.invoicing_rule_id,
4928: NULL, ''N'',
4929: ''Y'')
4930: FROM ra_customer_trx ct
4931: WHERE ct.customer_trx_id = gd.customer_trx_id)';
4932:
4933:
4934: debug( l_delete_stmt, MSG_LEVEL_DEBUG );

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 6602: l_invoicing_rule_id ra_customer_trx.invoicing_rule_id%type;

6598: l_no_rows_unbill BOOLEAN := FALSE;
6599: l_no_rows_unearn BOOLEAN := FALSE;
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:

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 6615: FROM ra_customer_trx t,

6611: SELECT invoicing_rule_id,
6612: create_clearing_flag
6613: INTO l_invoicing_rule_id,
6614: l_create_clearing_flag
6615: FROM ra_customer_trx t,
6616: ra_batch_sources b
6617: WHERE customer_trx_id = p_customer_trx_id
6618: AND t.batch_source_id = b.batch_source_id;
6619: END IF;

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

Line 7103: FROM ra_customer_trx t

7099: --
7100: IF ( p_customer_trx_id IS NOT NULL) THEN
7101: SELECT t.bill_to_site_use_id
7102: INTO l_bill_to_site_use_id
7103: FROM ra_customer_trx t
7104: WHERE t.customer_trx_id = p_customer_trx_id;
7105: END IF;
7106:
7107: --