APPS.ARP_XLA_EVENTS dependencies on AR_CASH_RECEIPT_HISTORY

Line 1001: ' ar_cash_receipt_history' || l_all_clause || ' crh1, ' || CRLF ||

997: cr.legal_entity_id LEGAL_ENTITY_ID ' || CRLF;
998:
999: l_from_clause :=
1000: ' FROM ar_cash_receipts' || l_all_clause || ' cr, ' || CRLF ||
1001: ' ar_cash_receipt_history' || l_all_clause || ' crh1, ' || CRLF ||
1002: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF;
1003:
1004: l_where_clause := ' WHERE crh.cash_receipt_id = cr.cash_receipt_id ' || CRLF ||
1005: ' AND cr.cash_receipt_id = crh1.cash_receipt_id (+) ' || CRLF ||

Line 1002: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF;

998:
999: l_from_clause :=
1000: ' FROM ar_cash_receipts' || l_all_clause || ' cr, ' || CRLF ||
1001: ' ar_cash_receipt_history' || l_all_clause || ' crh1, ' || CRLF ||
1002: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF;
1003:
1004: l_where_clause := ' WHERE crh.cash_receipt_id = cr.cash_receipt_id ' || CRLF ||
1005: ' AND cr.cash_receipt_id = crh1.cash_receipt_id (+) ' || CRLF ||
1006: ' AND ''Y'' = crh1.first_posted_record_flag (+) ' || CRLF ||

Line 1100: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF ;

1096: l_from_clause :=
1097: ' FROM xla_events' || ' ev1, ' || CRLF ||
1098: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1099: ' ar_cash_receipts' || l_all_clause || ' cr, ' || CRLF ||
1100: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF ;
1101:
1102: l_where_clause :=
1103: ' WHERE
1104: decode(crh.created_from,

Line 1227: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF;

1223:
1224: l_from_clause :=
1225: ' FROM ar_misc_cash_distributions' || l_all_clause || ' mcd, ' || CRLF ||
1226: ' ar_cash_receipts' || l_all_clause || ' cr, ' || CRLF ||
1227: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF;
1228:
1229: log('l_from_clause ' || l_from_clause);
1230:
1231: l_where_clause := ' WHERE 1 = 1 ' || CRLF ||

Line 1293: ' ar_cash_receipt_history' || l_all_clause || ' crh, ' || CRLF ||

1289:
1290: l_from_clause :=
1291: ' FROM xla_events' || ' ev1, ' || CRLF ||
1292: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1293: ' ar_cash_receipt_history' || l_all_clause || ' crh, ' || CRLF ||
1294: ' ar_misc_cash_distributions' || l_all_clause || ' mcd ' || CRLF ;
1295:
1296: l_where_clause :=
1297: ' WHERE decode(crh.created_from,

Line 1446: ' ar_cash_receipt_history' || l_all_clause || ' crh, ' || CRLF ||

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:
1450: --{

Line 1447: ' ar_cash_receipt_history' || l_all_clause || ' crh1, ' || 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:
1450: --{
1451: -- The join to AND app.status IN (''APP'',''ACTIVITY'',''OTHER ACC'',''ACC'',''UNID'')

Line 1527: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF ;

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: --{
1531: -- The join to AND app.status IN (''APP'',''ACTIVITY'',''OTHER ACC'',''ACC'', ''UNID'')

Line 3398: UPDATE ar_cash_receipt_history

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

Line 3651: UPDATE ar_cash_receipt_history_all crh

3647: IF p_xla_ev_rec.xla_doc_table = 'CRH' AND test_flag = 'N' THEN
3648: log('Bulk Updating Cash Receipt History');
3649: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3650: --6785758
3651: UPDATE ar_cash_receipt_history_all crh
3652: SET crh.event_id = ev_rec.dist_event_id(m),
3653: crh.last_update_date = SYSDATE,
3654: crh.last_update_login = l_last_update_login,
3655: crh.last_updated_by = l_last_updated_by

Line 4325: FROM ar_cash_receipt_history

4321: WHERE adjustment_id = p_document_id;
4322:
4323: CURSOR c_crh IS
4324: SELECT event_id
4325: FROM ar_cash_receipt_history
4326: WHERE cash_receipt_id = p_document_id;
4327:
4328: CURSOR c_trh IS
4329: SELECT event_id, customer_trx_id