APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on XLA_POST_ACCTG_EVENTS_V

Line 8085: FROM xla_post_acctg_events_v ev

8081: WHERE posting_control_id = -3
8082: AND (cash_receipt_id, event_id) IN
8083: (SELECT /*+ cardinality(EV,1) unnest */ ev.source_id_int_1, ev.event_id
8084: /* added hint as suggest by the perf team thru bug 13702457 */
8085: FROM xla_post_acctg_events_v ev
8086: WHERE ev.application_id = p_application_id
8087: AND ev.process_status_code = 'P'
8088: AND ev.event_type_code IN
8089: ('RECP_CREATE' ,

Line 8107: FROM xla_post_acctg_events_v ev

8103: last_update_login = fnd_global.user_id
8104: WHERE posting_control_id = -3
8105: AND (cash_receipt_id, event_id) IN
8106: (SELECT ev.source_id_int_1, ev.event_id
8107: FROM xla_post_acctg_events_v ev
8108: WHERE ev.application_id = p_application_id
8109: AND ev.process_status_code = 'P'
8110: AND ev.event_type_code IN
8111: ('MISC_RECP_CREATE' ,

Line 8131: FROM xla_post_acctg_events_v ev

8127: last_update_login = fnd_global.user_id
8128: WHERE posting_control_id = -3
8129: AND (customer_trx_id, event_id) IN
8130: (SELECT ev.source_id_int_1, ev.event_id
8131: FROM xla_post_acctg_events_v ev
8132: WHERE ev.application_id = p_application_id
8133: AND ev.process_status_code = 'P'
8134: AND ev.event_type_code IN
8135: ('INV_CREATE' , 'INV_UPDATE' ,

Line 8156: FROM xla_post_acctg_events_v ev

8152: last_update_login = fnd_global.user_id
8153: WHERE posting_control_id = -3
8154: AND adjustment_id IN
8155: (SELECT ev.source_id_int_1
8156: FROM xla_post_acctg_events_v ev
8157: WHERE ev.application_id = p_application_id
8158: AND ev.process_status_code = 'P'
8159: AND ev.event_type_code = 'ADJ_CREATE');
8160:

Line 8175: FROM xla_post_acctg_events_v ev

8171: last_update_login = fnd_global.user_id
8172: WHERE posting_control_id = -3
8173: AND event_id IN
8174: (SELECT /*+ LEADING(ev) CARDINALITY(ev,1) */ ev.event_id -- Added hint for bug 14335425
8175: FROM xla_post_acctg_events_v ev
8176: WHERE ev.application_id = p_application_id
8177: AND ev.process_status_code = 'P'
8178: AND ev.event_type_code IN
8179: ('CM_CREATE' ,'CM_UPDATE' ,

Line 8199: FROM xla_post_acctg_events_v ev

8195: WHERE posting_control_id = -3
8196: AND postable_flag='Y'
8197: AND event_id IN
8198: (SELECT ev.event_id
8199: FROM xla_post_acctg_events_v ev
8200: WHERE ev.application_id = p_application_id
8201: AND ev.process_status_code = 'P'
8202: AND ev.event_type_code IN
8203: ( 'BILL_CREATE' ,