APPS.ARP_XLA_EVENTS dependencies on AR_ADJUSTMENTS

Line 830: ' ar_adjustments' || l_all_clause || ' adj ' || CRLF;

826:
827: l_from_clause :=
828: ' FROM ra_cust_trx_types' || l_all_clause || ' tty, ' || CRLF ||
829: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
830: ' ar_adjustments' || l_all_clause || ' adj ' || CRLF;
831:
832: ----------------------------------------------------------------------------------
833: --A script to denormalize the BR_ADJUSTMENT_ID on adjustment table may be written
834: --Open issue - Should Invoice against Deposit, Guarantee, shadow adjustments for

Line 880: ' ar_adjustments' || l_all_clause || ' adj ' || CRLF;

876:
877: l_from_clause :=
878: ' FROM xla_events' || ' ev1, ' || CRLF ||
879: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
880: ' ar_adjustments' || l_all_clause || ' adj ' || CRLF;
881:
882: l_where_clause :=
883: ' WHERE adj.event_id IS NULL
884: AND evn.entity_code = ''ADJUSTMENTS''

Line 2580: ar_adjustments_all adj

2576: and ae2.event_id IN
2577: ( select MAX( ae.event_id )
2578: from xla_events ae,
2579: xla_transaction_entities_upg xt,
2580: ar_adjustments_all adj
2581: where adj.adjustment_id = ev_rec.trx_id(i)
2582: and NVL(xt.source_id_int_1,-99) = adj.adjustment_id
2583: and xt.entity_code = 'ADJUSTMENTS'
2584: and xt.ledger_id = adj.set_of_books_id

Line 3392: UPDATE ar_adjustments

3388: WHERE event_id = p_event_id;
3389:
3390: ELSIF p_xla_doc = 'ADJ' THEN
3391:
3392: UPDATE ar_adjustments
3393: SET event_id = NULL
3394: WHERE event_id = p_event_id;
3395:
3396: ELSIF p_xla_doc IN ('CRHAPP', 'APP') THEN

Line 3627: UPDATE ar_adjustments_all adj

3623:
3624: IF p_xla_ev_rec.xla_doc_table = 'ADJ' AND test_flag = 'N' THEN
3625: log('Bulk Updating Adjustments ');
3626: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3627: UPDATE ar_adjustments_all adj
3628: SET adj.event_id = ev_rec.dist_event_id(m),
3629: adj.last_update_date = TRUNC(SYSDATE),
3630: adj.last_update_login = l_last_update_login,
3631: adj.last_updated_by = l_last_updated_by

Line 4308: FROM ar_adjustments

4304: WHERE receivable_application_id = p_document_id;
4305:
4306: CURSOR c_adj IS
4307: SELECT event_id
4308: FROM ar_adjustments
4309: WHERE adjustment_id = p_document_id;
4310:
4311: CURSOR c_crh IS
4312: SELECT event_id