APPS.ARP_XLA_EVENTS dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 654: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd1, ' || CRLF ||

650:
651: l_from_clause :=
652: ' FROM ra_cust_trx_types' || l_all_clause || ' tty, ' || CRLF ||
653: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
654: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd1, ' || CRLF ||
655: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd ' || CRLF;
656:
657: --note that the ctlgd1 fragment can be made dynamic for batch processes
658: --since none of the distributions will be posted.

Line 655: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd ' || CRLF;

651: l_from_clause :=
652: ' FROM ra_cust_trx_types' || l_all_clause || ' tty, ' || CRLF ||
653: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
654: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd1, ' || CRLF ||
655: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd ' || CRLF;
656:
657: --note that the ctlgd1 fragment can be made dynamic for batch processes
658: --since none of the distributions will be posted.
659:

Line 739: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd ' || CRLF;

735:
736: l_from_clause :=
737: ' FROM xla_events' || ' ev1, ' || CRLF ||
738: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
739: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd ' || CRLF;
740:
741: --{BUG#5131345 suggested by perf team
742:
743: l_where_clause :=

Line 1616: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd, ' ||

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 :=
1620: ' WHERE app.application_type = ''CM''

Line 3392: UPDATE ra_cust_trx_line_gl_dist

3388: END IF;
3389:
3390: IF p_xla_doc IN ('CT','CTCMAPP','CTNORCM') THEN
3391:
3392: UPDATE ra_cust_trx_line_gl_dist
3393: SET event_id = NULL
3394: WHERE event_id = p_event_id;
3395:
3396: ELSIF p_xla_doc IN ('CRH', 'CRHMCD', 'CRHAPP') THEN

Line 3627: UPDATE ra_cust_trx_line_gl_dist_all ctlgd

3623: log('Bulk Updating Transactions');
3624:
3625: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3626: --6785758
3627: UPDATE ra_cust_trx_line_gl_dist_all ctlgd
3628: SET ctlgd.event_id = ev_rec.dist_event_id(m),
3629: ctlgd.last_update_date = SYSDATE,
3630: ctlgd.last_update_login = l_last_update_login,
3631: ctlgd.last_updated_by = l_last_updated_by

Line 4310: FROM ra_cust_trx_line_gl_dist

4306: and xe.event_status_code = 'I' ;
4307:
4308: CURSOR c_ct IS
4309: SELECT event_id
4310: FROM ra_cust_trx_line_gl_dist
4311: WHERE customer_trx_id = p_document_id;
4312:
4313: CURSOR c_app IS
4314: SELECT event_id

Line 4427: FROM ra_cust_trx_line_gl_dist gld

4423:
4424:
4425: CURSOR c_ct IS
4426: SELECT distinct event_id event_id
4427: FROM ra_cust_trx_line_gl_dist gld
4428: WHERE customer_trx_id = p_document_id
4429: and account_set_flag = 'N'
4430: AND event_id is not null
4431: and EXISTS

Line 4432: ( select 'x' FROM ra_cust_trx_line_gl_dist gldin

4428: WHERE customer_trx_id = p_document_id
4429: and account_set_flag = 'N'
4430: AND event_id is not null
4431: and EXISTS
4432: ( select 'x' FROM ra_cust_trx_line_gl_dist gldin
4433: WHERE customer_trx_id = p_document_id
4434: and account_class='REC'
4435: and latest_rec_flag='Y'
4436: AND event_id IS NOT NULL