APPS.ARP_XLA_EVENTS dependencies on AR_RECEIVABLE_APPLICATIONS

Line 1442: ' FROM ar_receivable_applications' || l_all_clause || ' app, ' || CRLF ||

1438: cr.receipt_date TRANSACTION_DATE,
1439: cr.legal_entity_id LEGAL_ENTITY_ID ' || CRLF;
1440:
1441: l_from_clause :=
1442: ' FROM ar_receivable_applications' || l_all_clause || ' app, ' || CRLF ||
1443: ' ar_cash_receipt_history' || l_all_clause || ' crh, ' || CRLF ||
1444: ' ar_cash_receipt_history' || l_all_clause || ' crh1, ' || CRLF ||
1445: ' ar_cash_receipts' || l_all_clause || ' cr ' || CRLF ;
1446:

Line 1521: ' ar_receivable_applications' || l_all_clause || ' app, ' || CRLF ||

1517:
1518: l_from_clause :=
1519: ' FROM xla_events' || ' ev1, ' || CRLF ||
1520: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1521: ' ar_receivable_applications' || l_all_clause || ' app, ' || CRLF ||
1522: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF ;
1523:
1524: log('l_from_clause ' || l_from_clause);
1525: --{

Line 1607: ' FROM ar_receivable_applications' || l_all_clause || ' app, ' ||

1603: ct.trx_date TRANSACTION_DATE,
1604: ct.legal_entity_id LEGAL_ENTITY_ID ' || CRLF;
1605:
1606: l_from_clause :=
1607: ' FROM ar_receivable_applications' || l_all_clause || ' app, ' ||
1608: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd, ' ||
1609: ' ra_customer_trx' || l_all_clause || ' ct ' || CRLF ;
1610:
1611: l_where_clause :=

Line 1669: ' ar_receivable_applications' || l_all_clause || ' app ' || CRLF ;

1665:
1666: l_from_clause :=
1667: ' FROM xla_events' || ' ev1, ' || CRLF ||
1668: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1669: ' ar_receivable_applications' || l_all_clause || ' app ' || CRLF ;
1670:
1671:
1672: --Use xla_transaction_entity_n1
1673: l_where_clause :=

Line 3398: UPDATE ar_receivable_applications

3394: WHERE event_id = p_event_id;
3395:
3396: ELSIF p_xla_doc IN ('CRHAPP', 'APP') THEN
3397:
3398: UPDATE ar_receivable_applications
3399: SET event_id = NULL
3400: WHERE event_id = p_event_id;
3401:
3402: ELSIF p_xla_doc IN ('CRHMCD', 'MCD') THEN

Line 3665: UPDATE ar_receivable_applications_all app

3661: AND test_flag = 'N' THEN
3662: log('Bulk Updating receivable applications');
3663: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3664: --6785758
3665: UPDATE ar_receivable_applications_all app
3666: SET app.event_id = ev_rec.dist_event_id(m),
3667: app.last_update_date = TRUNC(SYSDATE),
3668: app.last_update_login = l_last_update_login,
3669: app.last_updated_by = l_last_updated_by

Line 4303: FROM ar_receivable_applications

4299: WHERE customer_trx_id = p_document_id;
4300:
4301: CURSOR c_app IS
4302: SELECT event_id
4303: FROM ar_receivable_applications
4304: WHERE receivable_application_id = p_document_id;
4305:
4306: CURSOR c_adj IS
4307: SELECT event_id