APPS.ARP_XLA_EVENTS dependencies on AR_TRANSACTION_HISTORY

Line 1787: ' FROM ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||

1783: ct.trx_date TRANSACTION_DATE,
1784: ct.legal_entity_id LEGAL_ENTITY_ID ';
1785:
1786: l_from_clause :=
1787: ' FROM ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||
1788: ' ar_transaction_history' || l_all_clause || ' trh1, ' || CRLF ||
1789: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
1790: ' ra_cust_trx_types' || l_all_clause || ' tty ' || CRLF;
1791:

Line 1788: ' ar_transaction_history' || l_all_clause || ' trh1, ' || CRLF ||

1784: ct.legal_entity_id LEGAL_ENTITY_ID ';
1785:
1786: l_from_clause :=
1787: ' FROM ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||
1788: ' ar_transaction_history' || l_all_clause || ' trh1, ' || CRLF ||
1789: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
1790: ' ra_cust_trx_types' || l_all_clause || ' tty ' || CRLF;
1791:
1792: l_where_clause := ' where ct.customer_trx_id = trh.customer_trx_id ' || CRLF ||

Line 1876: ' ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||

1872:
1873: l_from_clause :=
1874: ' FROM xla_events' || ' ev1, ' || CRLF ||
1875: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1876: ' ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||
1877: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
1878: ' ra_cust_trx_types' || l_all_clause || ' tty ' || CRLF;
1879:
1880: l_where_clause :=

Line 3410: UPDATE ar_transaction_history

3406: WHERE event_id = p_event_id;
3407:
3408: ELSIF p_xla_doc = 'TRH' THEN
3409:
3410: UPDATE ar_transaction_history
3411: SET event_id = NULL
3412: WHERE event_id = p_event_id;
3413:
3414: END IF;

Line 3677: UPDATE ar_transaction_history_all trh

3673: IF p_xla_ev_rec.xla_doc_table = 'TRH' AND test_flag = 'N' THEN
3674: log('Bulk Updating Bills Receivable transaction history ');
3675: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3676: --6785758
3677: UPDATE ar_transaction_history_all trh
3678: SET trh.event_id = ev_rec.dist_event_id(m),
3679: trh.last_update_date = TRUNC(SYSDATE),
3680: trh.last_update_login = l_last_update_login,
3681: trh.last_updated_by = l_last_updated_by

Line 4318: FROM ar_transaction_history

4314: WHERE cash_receipt_id = p_document_id;
4315:
4316: CURSOR c_trh IS
4317: SELECT event_id, customer_trx_id
4318: FROM ar_transaction_history
4319: WHERE transaction_history_id = p_document_id;
4320:
4321: BEGIN
4322: log('arp_xla_events.delete_event ()+');