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 1608: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd, ' ||

1604: ct.legal_entity_id LEGAL_ENTITY_ID ' || CRLF;
1605:
1606: l_from_clause :=
1607: ' FROM ar_receivable_applications' || l_all_clause || ' app, ' ||
1608: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd, ' ||
1609: ' ra_customer_trx' || l_all_clause || ' ct ' || CRLF ;
1610:
1611: l_where_clause :=
1612: ' WHERE app.application_type = ''CM''

Line 3380: UPDATE ra_cust_trx_line_gl_dist

3376: END IF;
3377:
3378: IF p_xla_doc IN ('CT','CTCMAPP','CTNORCM') THEN
3379:
3380: UPDATE ra_cust_trx_line_gl_dist
3381: SET event_id = NULL
3382: WHERE event_id = p_event_id;
3383:
3384: ELSIF p_xla_doc IN ('CRH', 'CRHMCD', 'CRHAPP') THEN

Line 3615: UPDATE ra_cust_trx_line_gl_dist_all ctlgd

3611: log('Bulk Updating Transactions');
3612:
3613: FORALL m IN ev_rec.dist_row_id.FIRST .. ev_rec.dist_row_id.LAST
3614: --6785758
3615: UPDATE ra_cust_trx_line_gl_dist_all ctlgd
3616: SET ctlgd.event_id = ev_rec.dist_event_id(m),
3617: ctlgd.last_update_date = TRUNC(SYSDATE),
3618: ctlgd.last_update_login = l_last_update_login,
3619: ctlgd.last_updated_by = l_last_updated_by

Line 4298: FROM ra_cust_trx_line_gl_dist

4294: and xe.event_status_code = 'I' ;
4295:
4296: CURSOR c_ct IS
4297: SELECT event_id
4298: FROM ra_cust_trx_line_gl_dist
4299: WHERE customer_trx_id = p_document_id;
4300:
4301: CURSOR c_app IS
4302: SELECT event_id

Line 4415: FROM ra_cust_trx_line_gl_dist gld

4411:
4412:
4413: CURSOR c_ct IS
4414: SELECT distinct event_id event_id
4415: FROM ra_cust_trx_line_gl_dist gld
4416: WHERE customer_trx_id = p_document_id
4417: and account_set_flag = 'N'
4418: AND event_id is not null
4419: and EXISTS

Line 4420: ( select 'x' FROM ra_cust_trx_line_gl_dist gldin

4416: WHERE customer_trx_id = p_document_id
4417: and account_set_flag = 'N'
4418: AND event_id is not null
4419: and EXISTS
4420: ( select 'x' FROM ra_cust_trx_line_gl_dist gldin
4421: WHERE customer_trx_id = p_document_id
4422: and account_class='REC'
4423: and latest_rec_flag='Y'
4424: AND event_id IS NOT NULL