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 1226: ' ar_cash_receipt_history' || l_all_clause || ' crh ' || CRLF;

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

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

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

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

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

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

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

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

Line 3386: UPDATE ar_cash_receipt_history

3382: WHERE event_id = p_event_id;
3383:
3384: ELSIF p_xla_doc IN ('CRH', 'CRHMCD', 'CRHAPP') THEN
3385:
3386: UPDATE ar_cash_receipt_history
3387: SET event_id = NULL
3388: WHERE event_id = p_event_id;
3389:
3390: ELSIF p_xla_doc = 'ADJ' THEN

Line 3639: UPDATE ar_cash_receipt_history_all crh

3635: IF p_xla_ev_rec.xla_doc_table = 'CRH' AND test_flag = 'N' THEN
3636: log('Bulk Updating Cash Receipt History');
3637: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3638: --6785758
3639: UPDATE ar_cash_receipt_history_all crh
3640: SET crh.event_id = ev_rec.dist_event_id(m),
3641: crh.last_update_date = TRUNC(SYSDATE),
3642: crh.last_update_login = l_last_update_login,
3643: crh.last_updated_by = l_last_updated_by

Line 4313: FROM ar_cash_receipt_history

4309: WHERE adjustment_id = p_document_id;
4310:
4311: CURSOR c_crh IS
4312: SELECT event_id
4313: FROM ar_cash_receipt_history
4314: WHERE cash_receipt_id = p_document_id;
4315:
4316: CURSOR c_trh IS
4317: SELECT event_id, customer_trx_id