eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_ACCOUNTING_PKG dependencies on XLA_EVENT_TYPES_B

Line 262: ,xla_event_types_b xet

258: '
259: SELECT /*+ leading(tab,evt) use_nl(evt) */
260: evt.event_id
261: FROM xla_events evt
262: ,xla_event_types_b xet
263: ,TABLE(CAST(:1 AS xla_array_number_type)) tab
264: WHERE evt.application_id = :2
265: AND evt.event_date <= :3
266: AND evt.entity_id = tab.column_value

Line 353: ,xla_event_types_b xet

349: ,evt.reference_date_3
350: ,evt.reference_date_4
351: FROM xla_events evt
352: ,xla_transaction_entities ent
353: ,xla_event_types_b xet
354: ,xla_event_class_attrs eca
355: WHERE evt.application_id = :1
356: AND evt.event_date <= :2
357: AND evt.event_id = :3

Line 453: ,xla_event_types_b xet

449: ,evt.reference_date_3
450: ,evt.reference_date_4
451: FROM xla_events evt
452: ,xla_transaction_entities ent
453: ,xla_event_types_b xet
454: ,xla_event_class_attrs eca
455: WHERE evt.application_id = :1
456: AND evt.event_date <= :2
457: AND evt.event_id = :3

Line 474: ,xla_event_types_b xet2

470: AND evt.event_number <
471: (SELECT NVL(MIN(evt2.event_number), evt.event_number + 1)
472: FROM xla_events evt2
473: ,xla_transaction_entities_upg ent2
474: ,xla_event_types_b xet2
475: ,xla_event_class_attrs eca2
476: WHERE evt2.application_id = evt.application_id
477: AND evt2.entity_id = evt.entity_id
478: AND evt2.event_date = :5

Line 2948: xla_event_types_b ,

2944: FOR x IN (
2945: SELECT DISTINCT xla_evt_class_orders_gt.processing_order
2946: FROM xla_acct_prog_events_gt ,
2947: xla_events ,
2948: xla_event_types_b ,
2949: xla_transaction_entities,
2950: xla_evt_class_orders_gt
2951: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
2952: AND xla_events.application_id = p_application_id

Line 2955: AND xla_event_types_b.application_id = p_application_id

2951: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
2952: AND xla_events.application_id = p_application_id
2953: AND xla_transaction_entities.application_id = p_application_id
2954: AND xla_events.entity_id = xla_transaction_entities.entity_id
2955: AND xla_event_types_b.application_id = p_application_id
2956: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
2957: AND xla_events.event_type_code = xla_event_types_b.event_type_code
2958: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
2959: ORDER BY xla_evt_class_orders_gt.processing_order ASC)

Line 2956: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code

2952: AND xla_events.application_id = p_application_id
2953: AND xla_transaction_entities.application_id = p_application_id
2954: AND xla_events.entity_id = xla_transaction_entities.entity_id
2955: AND xla_event_types_b.application_id = p_application_id
2956: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
2957: AND xla_events.event_type_code = xla_event_types_b.event_type_code
2958: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
2959: ORDER BY xla_evt_class_orders_gt.processing_order ASC)
2960: LOOP

Line 2957: AND xla_events.event_type_code = xla_event_types_b.event_type_code

2953: AND xla_transaction_entities.application_id = p_application_id
2954: AND xla_events.entity_id = xla_transaction_entities.entity_id
2955: AND xla_event_types_b.application_id = p_application_id
2956: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
2957: AND xla_events.event_type_code = xla_event_types_b.event_type_code
2958: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
2959: ORDER BY xla_evt_class_orders_gt.processing_order ASC)
2960: LOOP
2961:

Line 2958: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code

2954: AND xla_events.entity_id = xla_transaction_entities.entity_id
2955: AND xla_event_types_b.application_id = p_application_id
2956: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
2957: AND xla_events.event_type_code = xla_event_types_b.event_type_code
2958: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
2959: ORDER BY xla_evt_class_orders_gt.processing_order ASC)
2960: LOOP
2961:
2962: IF (C_LEVEL_EVENT >= g_log_level) THEN

Line 4341: xla_event_types_b xet,

4337: l_cur_event_stmt :=
4338: 'SELECT /*+ index(evt,XLA_EVENTS_N3) */ MIN(nvl(xjc.processing_unit_size, :1))
4339: FROM xla_events evt,
4340: xla_transaction_entities ent,
4341: xla_event_types_b xet,
4342: xla_event_class_attrs eca,
4343: xla_evt_class_orders_gt xpo,
4344: xla_je_categories xjc
4345: WHERE ent.application_id = :3

Line 4374: ,xla_event_types_b xet

4370: 'SELECT /*+ index(evt,XLA_EVENTS_N3) */ -- Bug 5529420 reverted bug6369888
4371: DISTINCT evt.entity_id
4372: FROM xla_events evt
4373: ,xla_transaction_entities ent
4374: ,xla_event_types_b xet
4375: ,xla_event_class_attrs eca
4376: ,xla_evt_class_orders_gt xpo
4377: WHERE ent.application_id = :1
4378: AND ent.ledger_id = :2

Line 7059: xla_event_types_b ,

7055: AND xap.event_id IN (
7056: SELECT xla_events.event_id
7057: FROM xla_acct_prog_events_gt ,
7058: xla_events ,
7059: xla_event_types_b ,
7060: xla_transaction_entities,
7061: xla_evt_class_orders_gt
7062: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7063: AND xla_events.application_id = g_application_id

Line 7066: AND xla_event_types_b.application_id = g_application_id

7062: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7063: AND xla_events.application_id = g_application_id
7064: AND xla_transaction_entities.application_id = g_application_id
7065: AND xla_events.entity_id = xla_transaction_entities.entity_id
7066: AND xla_event_types_b.application_id = g_application_id
7067: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7068: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7069: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
7070: AND xla_evt_class_orders_gt.processing_order = l_processing_order

Line 7067: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code

7063: AND xla_events.application_id = g_application_id
7064: AND xla_transaction_entities.application_id = g_application_id
7065: AND xla_events.entity_id = xla_transaction_entities.entity_id
7066: AND xla_event_types_b.application_id = g_application_id
7067: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7068: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7069: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
7070: AND xla_evt_class_orders_gt.processing_order = l_processing_order
7071: )

Line 7068: AND xla_events.event_type_code = xla_event_types_b.event_type_code

7064: AND xla_transaction_entities.application_id = g_application_id
7065: AND xla_events.entity_id = xla_transaction_entities.entity_id
7066: AND xla_event_types_b.application_id = g_application_id
7067: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7068: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7069: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
7070: AND xla_evt_class_orders_gt.processing_order = l_processing_order
7071: )
7072: ORDER BY xev.entity_id, xev.event_number;

Line 7069: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code

7065: AND xla_events.entity_id = xla_transaction_entities.entity_id
7066: AND xla_event_types_b.application_id = g_application_id
7067: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7068: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7069: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
7070: AND xla_evt_class_orders_gt.processing_order = l_processing_order
7071: )
7072: ORDER BY xev.entity_id, xev.event_number;
7073: