APPS.ARP_XLA_EVENTS dependencies on AR_RECEIVABLE_APPLICATIONS

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

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

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

1522:
1523: l_from_clause :=
1524: ' FROM xla_events' || ' ev1, ' || CRLF ||
1525: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1526: ' ar_receivable_applications' || l_all_clause || ' app, ' || CRLF ||
1527: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF ;
1528:
1529: log('l_from_clause ' || l_from_clause);
1530: --{

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

1611: ct.trx_date TRANSACTION_DATE,
1612: ct.legal_entity_id LEGAL_ENTITY_ID ' || 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 :=

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

1673:
1674: l_from_clause :=
1675: ' FROM xla_events' || ' ev1, ' || CRLF ||
1676: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1677: ' ar_receivable_applications' || l_all_clause || ' app ' || CRLF ;
1678:
1679:
1680: --Use xla_transaction_entity_n1
1681: l_where_clause :=

Line 3410: UPDATE ar_receivable_applications

3406: WHERE event_id = p_event_id;
3407:
3408: ELSIF p_xla_doc IN ('CRHAPP', 'APP') THEN
3409:
3410: UPDATE ar_receivable_applications
3411: SET event_id = NULL
3412: WHERE event_id = p_event_id;
3413:
3414: ELSIF p_xla_doc IN ('CRHMCD', 'MCD') THEN

Line 3677: UPDATE ar_receivable_applications_all app

3673: AND test_flag = 'N' THEN
3674: log('Bulk Updating receivable applications');
3675: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3676: --6785758
3677: UPDATE ar_receivable_applications_all app
3678: SET app.event_id = ev_rec.dist_event_id(m),
3679: app.last_update_date = SYSDATE,
3680: app.last_update_login = l_last_update_login,
3681: app.last_updated_by = l_last_updated_by

Line 4315: FROM ar_receivable_applications

4311: WHERE customer_trx_id = p_document_id;
4312:
4313: CURSOR c_app IS
4314: SELECT event_id
4315: FROM ar_receivable_applications
4316: WHERE receivable_application_id = p_document_id;
4317:
4318: CURSOR c_adj IS
4319: SELECT event_id