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 361: ,xla_transaction_entities ent

357: ,evt.reference_date_2
358: ,evt.reference_date_3
359: ,evt.reference_date_4
360: FROM xla_events evt
361: ,xla_transaction_entities ent
362: ,xla_event_types_b xet
363: ,xla_event_class_attrs eca
364: WHERE evt.application_id = :1
365: AND evt.event_date <= :2

Line 463: ,xla_transaction_entities ent

459: ,evt.reference_date_2
460: ,evt.reference_date_3
461: ,evt.reference_date_4
462: FROM xla_events evt
463: ,xla_transaction_entities ent
464: ,xla_event_types_b xet
465: ,xla_event_class_attrs eca
466: WHERE evt.application_id = :1
467: AND evt.event_date <= :2

Line 485: ,xla_transaction_entities_upg ent2

481: (''U'', DECODE(:4, ''F'',''N'',''U''))
482: AND evt.event_number <
483: (SELECT NVL(MIN(evt2.event_number), evt.event_number + 1)
484: FROM xla_events evt2
485: ,xla_transaction_entities_upg ent2
486: ,xla_event_types_b xet2
487: ,xla_event_class_attrs eca2
488: WHERE evt2.application_id = evt.application_id
489: AND evt2.entity_id = evt.entity_id

Line 2869: FROM xla_transaction_entities xte

2865:
2866: CURSOR c_lock_entity_events IS
2867: SELECT /*+ LEADING (XAP) USE_NL (XAP XE XTE) */
2868: xe.event_id
2869: FROM xla_transaction_entities xte
2870: , xla_events xe
2871: , xla_acct_prog_events_gt xap
2872: WHERE xte.application_id = xe.application_id
2873: AND xte.entity_id = xe.entity_id

Line 3171: xla_transaction_entities,

3167: SELECT DISTINCT xla_evt_class_orders_gt.processing_order
3168: FROM xla_acct_prog_events_gt ,
3169: xla_events ,
3170: xla_event_types_b ,
3171: xla_transaction_entities,
3172: xla_evt_class_orders_gt
3173: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
3174: AND xla_events.application_id = p_application_id
3175: AND xla_transaction_entities.application_id = p_application_id

Line 3175: AND xla_transaction_entities.application_id = p_application_id

3171: xla_transaction_entities,
3172: xla_evt_class_orders_gt
3173: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
3174: AND xla_events.application_id = p_application_id
3175: AND xla_transaction_entities.application_id = p_application_id
3176: AND xla_events.entity_id = xla_transaction_entities.entity_id
3177: AND xla_event_types_b.application_id = p_application_id
3178: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
3179: AND xla_events.event_type_code = xla_event_types_b.event_type_code

Line 3176: AND xla_events.entity_id = xla_transaction_entities.entity_id

3172: xla_evt_class_orders_gt
3173: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
3174: AND xla_events.application_id = p_application_id
3175: AND xla_transaction_entities.application_id = p_application_id
3176: AND xla_events.entity_id = xla_transaction_entities.entity_id
3177: AND xla_event_types_b.application_id = p_application_id
3178: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
3179: AND xla_events.event_type_code = xla_event_types_b.event_type_code
3180: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code

Line 3178: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code

3174: AND xla_events.application_id = p_application_id
3175: AND xla_transaction_entities.application_id = p_application_id
3176: AND xla_events.entity_id = xla_transaction_entities.entity_id
3177: AND xla_event_types_b.application_id = p_application_id
3178: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
3179: AND xla_events.event_type_code = xla_event_types_b.event_type_code
3180: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
3181: AND xla_events.process_status_code <> 'P' --condition added, bug8680284
3182: ORDER BY xla_evt_class_orders_gt.processing_order ASC)

Line 3509: , xla_transaction_entities xte

3505:
3506: INSERT INTO xla_acct_prog_events_gt (event_id, ledger_id)
3507: SELECT xe.event_id, xte.ledger_id
3508: FROM xla_events xe
3509: , xla_transaction_entities xte
3510: WHERE xte.application_id = p_application_id
3511: AND xte.entity_id = p_entity_id
3512: AND xe.application_id = p_application_id
3513: AND xe.entity_id = p_entity_id

Line 4610: xla_transaction_entities ent,

4606: --bug6369888 changed cursor to merge into single query.
4607: l_cur_event_stmt :=
4608: 'SELECT /*+ index(evt,XLA_EVENTS_N3) */ MIN(nvl(xjc.processing_unit_size, :1))
4609: FROM xla_events evt,
4610: xla_transaction_entities ent,
4611: xla_event_types_b xet,
4612: xla_event_class_attrs eca,
4613: xla_evt_class_orders_gt xpo,
4614: xla_je_categories xjc

Line 4643: ,xla_transaction_entities ent

4639: l_cur_entity_stmt :=
4640: 'SELECT /*+ leading(evt) use_nl(ent) index(evt,XLA_EVENTS_N3) */ -- Bug 5529420 reverted bug6369888 modified hint bug9192859
4641: DISTINCT evt.entity_id
4642: FROM xla_events evt
4643: ,xla_transaction_entities ent
4644: ,xla_event_types_b xet
4645: ,xla_event_class_attrs eca
4646: ,xla_evt_class_orders_gt xpo
4647: WHERE ent.application_id = :1

Line 7438: xla_transaction_entities,

7434: SELECT xla_events.event_id
7435: FROM xla_acct_prog_events_gt ,
7436: xla_events ,
7437: xla_event_types_b ,
7438: xla_transaction_entities,
7439: xla_evt_class_orders_gt
7440: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7441: AND xla_events.application_id = g_application_id
7442: AND xla_transaction_entities.application_id = g_application_id

Line 7442: AND xla_transaction_entities.application_id = g_application_id

7438: xla_transaction_entities,
7439: xla_evt_class_orders_gt
7440: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7441: AND xla_events.application_id = g_application_id
7442: AND xla_transaction_entities.application_id = g_application_id
7443: AND xla_events.entity_id = xla_transaction_entities.entity_id
7444: AND xla_event_types_b.application_id = g_application_id
7445: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7446: AND xla_events.event_type_code = xla_event_types_b.event_type_code

Line 7443: AND xla_events.entity_id = xla_transaction_entities.entity_id

7439: xla_evt_class_orders_gt
7440: WHERE xla_events.event_id = xla_acct_prog_events_gt.event_id
7441: AND xla_events.application_id = g_application_id
7442: AND xla_transaction_entities.application_id = g_application_id
7443: AND xla_events.entity_id = xla_transaction_entities.entity_id
7444: AND xla_event_types_b.application_id = g_application_id
7445: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7446: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7447: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code

Line 7445: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code

7441: AND xla_events.application_id = g_application_id
7442: AND xla_transaction_entities.application_id = g_application_id
7443: AND xla_events.entity_id = xla_transaction_entities.entity_id
7444: AND xla_event_types_b.application_id = g_application_id
7445: AND xla_transaction_entities.entity_code = xla_event_types_b.entity_code
7446: AND xla_events.event_type_code = xla_event_types_b.event_type_code
7447: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code
7448: AND xla_events.process_status_code <> 'P' --condition added, bug8680284
7449: AND xla_evt_class_orders_gt.processing_order = l_processing_order