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_XLA_EVENTS dependencies on RA_CUSTOMER_TRX

Line 20: TYPE line_tbl_type IS TABLE OF ra_customer_trx_lines.customer_trx_line_id%TYPE

16: bld_dml_flag DBMS_SQL.VARCHAR2_TABLE,--insert,update,delete
17: bld_temp_event_id DBMS_SQL.VARCHAR2_TABLE
18: );
19:
20: TYPE line_tbl_type IS TABLE OF ra_customer_trx_lines.customer_trx_line_id%TYPE
21: INDEX BY BINARY_INTEGER;
22:
23: /*-----------------------------------------------------------------------+
24: | Default bulk fetch size, and starting index |

Line 653: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||

649: ct.legal_entity_id LEGAL_ENTITY_ID ' || CRLF;
650:
651: l_from_clause :=
652: ' FROM ra_cust_trx_types' || l_all_clause || ' tty, ' || CRLF ||
653: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
654: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd1, ' || CRLF ||
655: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd ' || CRLF;
656:
657: --note that the ctlgd1 fragment can be made dynamic for batch processes

Line 829: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||

825: ct.legal_entity_id LEGAL_ENTITY_ID' || CRLF;
826:
827: l_from_clause :=
828: ' FROM ra_cust_trx_types' || l_all_clause || ' tty, ' || CRLF ||
829: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
830: ' ar_adjustments' || l_all_clause || ' adj ' || CRLF;
831:
832: ----------------------------------------------------------------------------------
833: --A script to denormalize the BR_ADJUSTMENT_ID on adjustment table may be written

Line 1617: ' ra_customer_trx' || l_all_clause || ' ct ' || CRLF ;

1613:
1614: l_from_clause :=
1615: ' FROM ar_receivable_applications' || l_all_clause || ' app, ' ||
1616: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd, ' ||
1617: ' ra_customer_trx' || l_all_clause || ' ct ' || CRLF ;
1618:
1619: l_where_clause :=
1620: ' WHERE app.application_type = ''CM''
1621: AND app.status IN (''APP'',''ACTIVITY'') --HYU

Line 1798: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||

1794:
1795: l_from_clause :=
1796: ' FROM ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||
1797: ' ar_transaction_history' || l_all_clause || ' trh1, ' || CRLF ||
1798: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
1799: ' ra_cust_trx_types' || l_all_clause || ' tty ' || CRLF;
1800:
1801: l_where_clause := ' where ct.customer_trx_id = trh.customer_trx_id ' || CRLF ||
1802: ' and ct.cust_trx_type_id = tty.cust_trx_type_id ' || CRLF ||

Line 1886: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||

1882: l_from_clause :=
1883: ' FROM xla_events' || ' ev1, ' || CRLF ||
1884: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1885: ' ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||
1886: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
1887: ' ra_cust_trx_types' || l_all_clause || ' tty ' || CRLF;
1888:
1889: l_where_clause :=
1890: ' WHERE ct.customer_trx_id = trh.customer_trx_id ' || CRLF ||

Line 2264: prev_trx_id ra_customer_trx.customer_trx_id%TYPE;

2260: l_change_matrix VARCHAR2(30);
2261:
2262: temp_event_id BINARY_INTEGER := 0;
2263:
2264: prev_trx_id ra_customer_trx.customer_trx_id%TYPE;
2265:
2266: l_type VARCHAR2(30);
2267: l_build_ctr BINARY_INTEGER;
2268: l_ev_type VARCHAR2(20);

Line 2492: ra_customer_trx_all trx

2488: and ae2.event_id IN
2489: ( select MAX( ae.event_id )
2490: from xla_events ae,
2491: xla_transaction_entities_upg xt,
2492: ra_customer_trx_all trx
2493: where trx.customer_trx_id = ev_rec.trx_id(i)
2494: and NVL(xt.source_id_int_1,-99) = trx.customer_trx_id
2495: and xt.entity_code = 'TRANSACTIONS'
2496: and xt.ledger_id = trx.set_of_books_id

Line 2526: ra_customer_trx_all trx

2522: and ae2.event_id IN
2523: ( select MAX( ae.event_id )
2524: from xla_events ae,
2525: xla_transaction_entities_upg xt,
2526: ra_customer_trx_all trx
2527: where trx.customer_trx_id = ev_rec.trx_id(i)
2528: and NVL(xt.source_id_int_1,-99) = trx.customer_trx_id
2529: and xt.entity_code = 'BILLS_RECEIVABLE'
2530: and xt.ledger_id = trx.set_of_books_id

Line 3480: FROM ra_customer_trx_lines ctl

3476: IS
3477:
3478: CURSOR cu_is_rev_rec_run IS
3479: SELECT 'Y'
3480: FROM ra_customer_trx_lines ctl
3481: WHERE ctl.customer_trx_id = p_invoice_id
3482: AND ctl.line_type = 'LINE'
3483: AND NVL(ctl.autorule_complete_flag,'Y') <> 'N';
3484:

Line 4295: ra_customer_trx ct,

4291:
4292: /*7229913 */
4293: CURSOR c_ct_rules is
4294: select xe.event_id event_id from
4295: ra_customer_trx ct,
4296: xla_transaction_entities_upg xte,
4297: xla_events xe
4298: where ct.customer_trx_id = p_document_id
4299: and ct.invoicing_rule_id in (-2,-3)

Line 4342: select invoicing_rule_id into l_invoicing_rule_id from ra_customer_trx

4338: FETCH c_ct INTO l_event_id;
4339: CLOSE c_ct;
4340:
4341: /*7229913*/
4342: select invoicing_rule_id into l_invoicing_rule_id from ra_customer_trx
4343: where customer_trx_id = p_document_id;
4344:
4345: IF l_invoicing_rule_id in (-2,-3) then
4346: OPEN c_ct_rules ;

Line 4560: FROM ra_customer_trx_all

4556: AND l_ar_xla_period_close_evt_tab(i).ENTITY_CODE IN ('TRANSACTIONS', 'BILLS_RECEIVABLE') THEN
4557: BEGIN
4558: SELECT
4559: count(*) into l_trx_cnt
4560: FROM ra_customer_trx_all
4561: WHERE customer_trx_id = l_ar_xla_period_close_evt_tab(i).SOURCE_ID_INT_1 /* The trx id stored in XLA entities table */
4562: AND org_id = l_ar_xla_period_close_evt_tab(i).SECURITY_ID_INT_1 /* The Org_ID stored in XLA entities table */
4563: AND complete_flag = 'N'; /* Incomplete Transaction */
4564: