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_TRANSACTION_ENTITIES

Line 352: ,xla_transaction_entities ent

348: ,evt.reference_date_2
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

Line 452: ,xla_transaction_entities ent

448: ,evt.reference_date_2
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

Line 473: ,xla_transaction_entities_upg ent2

469: (''U'', DECODE(:4, ''F'',''N'',''U''))
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

Line 2649: FROM xla_transaction_entities xte

2645:
2646: CURSOR c_lock_entity_events IS
2647: SELECT /*+ LEADING (XAP) USE_NL (XAP XE XTE) */
2648: xe.event_id
2649: FROM xla_transaction_entities xte
2650: , xla_events xe
2651: , xla_acct_prog_events_gt xap
2652: WHERE xte.application_id = xe.application_id
2653: AND xte.entity_id = xe.entity_id

Line 2949: xla_transaction_entities,

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
2953: AND xla_transaction_entities.application_id = p_application_id

Line 2953: AND xla_transaction_entities.application_id = p_application_id

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
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

Line 2954: AND xla_events.entity_id = xla_transaction_entities.entity_id

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
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

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 3272: , xla_transaction_entities xte

3268:
3269: INSERT INTO xla_acct_prog_events_gt (event_id, ledger_id)
3270: SELECT xe.event_id, xte.ledger_id
3271: FROM xla_events xe
3272: , xla_transaction_entities xte
3273: WHERE xte.application_id = p_application_id
3274: AND xte.entity_id = p_entity_id
3275: AND xe.application_id = p_application_id
3276: AND xe.entity_id = p_entity_id

Line 4340: xla_transaction_entities ent,

4336: --bug6369888 changed cursor to merge into single query.
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

Line 4373: ,xla_transaction_entities ent

4369: l_cur_entity_stmt :=
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

Line 7060: xla_transaction_entities,

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
7064: AND xla_transaction_entities.application_id = g_application_id

Line 7064: AND xla_transaction_entities.application_id = g_application_id

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
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

Line 7065: AND xla_events.entity_id = xla_transaction_entities.entity_id

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
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

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: )