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 269: ,xla_event_types_b xet

265: '
266: SELECT /*+ leading(tab,evt) use_nl(evt) */
267: evt.event_id
268: FROM xla_events evt
269: ,xla_event_types_b xet
270: ,TABLE(CAST(:1 AS xla_array_number_type)) tab
271: WHERE evt.application_id = :2
272: AND evt.event_date <= :3
273: AND evt.entity_id = tab.column_value

Line 362: ,xla_event_types_b xet

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
366: AND evt.event_id = :3

Line 464: ,xla_event_types_b xet

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
468: AND evt.event_id = :3

Line 486: ,xla_event_types_b xet2

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
490: AND evt2.event_date = :5

Line 3170: xla_event_types_b ,

3166: FOR x IN (
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

Line 3177: AND xla_event_types_b.application_id = p_application_id

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
3181: AND xla_events.process_status_code <> 'P' --condition added, bug8680284

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 3179: AND xla_events.event_type_code = xla_event_types_b.event_type_code

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

Line 3180: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code

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)
3183: LOOP
3184:

Line 4611: xla_event_types_b xet,

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
4615: WHERE ent.application_id = :3

Line 4644: ,xla_event_types_b xet

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
4648: AND ent.ledger_id = :2

Line 7437: xla_event_types_b ,

7433: AND xap.event_id IN (
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

Line 7444: AND xla_event_types_b.application_id = g_application_id

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
7448: AND xla_events.process_status_code <> 'P' --condition added, bug8680284

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

Line 7446: AND xla_events.event_type_code = xla_event_types_b.event_type_code

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

Line 7447: AND xla_event_types_b.event_class_code = xla_evt_class_orders_gt.event_class_code

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
7450: )
7451: ORDER BY xev.entity_id, xev.event_number;

Line 8075: ,xla_event_types_b xetb

8071: FROM gl_ledgers glg
8072: ,xla_acctg_methods_b xam
8073: ,xla_acctg_method_rules xamr
8074: ,xla_prod_acct_headers xpah
8075: ,xla_event_types_b xetb
8076: ,xla_aad_line_defn_assgns xald
8077: ,xla_line_definitions_b xldb
8078: ,xla_ledger_relationships_v xlr
8079: ,xla_ledger_options xlo