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_EVT_CLASS_ORDERS_GT

Line 3167: SELECT DISTINCT xla_evt_class_orders_gt.processing_order

3163:
3164: -- 7193986 start
3165:
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,

Line 3172: xla_evt_class_orders_gt

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
3176: AND xla_events.entity_id = xla_transaction_entities.entity_id

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 3182: ORDER BY xla_evt_class_orders_gt.processing_order ASC)

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:
3185: IF (C_LEVEL_EVENT >= g_log_level) THEN
3186: trace

Line 3533: INSERT INTO xla_evt_class_orders_gt

3529: ,p_module => l_log_module);
3530: END IF;
3531:
3532:
3533: INSERT INTO xla_evt_class_orders_gt
3534: (event_class_code
3535: ,processing_order
3536: )
3537: SELECT xec.event_class_code

Line 3559: (p_msg => 'Number of rows inserted into xla_evt_class_orders_gt = '||SQL%ROWCOUNT

3555:
3556:
3557: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3558: trace
3559: (p_msg => 'Number of rows inserted into xla_evt_class_orders_gt = '||SQL%ROWCOUNT
3560: ,p_level => C_LEVEL_STATEMENT
3561: ,p_module => l_log_module);
3562: END IF;
3563:

Line 4613: xla_evt_class_orders_gt xpo,

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
4616: AND ent.ledger_id = :4
4617: AND evt.application_id = :5

Line 4646: ,xla_evt_class_orders_gt xpo

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
4649: AND evt.application_id = :3
4650: AND evt.entity_id = ent.entity_id

Line 4701: FROM xla_evt_class_orders_gt xpo

4697: FROM xla_je_categories xjc,
4698: (
4699: SELECT
4700: xpo.event_class_code
4701: FROM xla_evt_class_orders_gt xpo
4702: WHERE xpo.processing_order = p_processing_order
4703: ) tab1
4704: WHERE xjc.application_id = g_application_id
4705: AND xjc.ledger_id = g_ledger_id

Line 5069: INSERT INTO xla_evt_class_orders_gt

5065: ,p_level => C_LEVEL_PROCEDURE
5066: ,p_module => l_log_module);
5067: END IF;
5068:
5069: INSERT INTO xla_evt_class_orders_gt
5070: (event_class_code
5071: ,processing_order
5072: )
5073: SELECT xec.event_class_code

Line 5094: FROM xla_evt_class_orders_gt;

5090: AND xec.event_class_code <> 'MANUAL';
5091:
5092: SELECT max(processing_order)
5093: INTO l_max_processing_order
5094: FROM xla_evt_class_orders_gt;
5095:
5096: IF (l_max_processing_order = -1) THEN
5097: l_num_level := 1;
5098: ELSE

Line 7439: xla_evt_class_orders_gt

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
7443: AND xla_events.entity_id = xla_transaction_entities.entity_id

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 7449: AND xla_evt_class_orders_gt.processing_order = l_processing_order

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;
7452:
7453:

Line 8748: FOR c IN (SELECT event_class_code FROM xla_evt_class_orders_gt WHERE processing_order = p_processing_order) LOOP

8744: --
8745: -- changes done for bug 5673550 to put filter based on process category
8746: --
8747: IF g_process_category IS NULL THEN
8748: FOR c IN (SELECT event_class_code FROM xla_evt_class_orders_gt WHERE processing_order = p_processing_order) LOOP
8749: IF l_concat_classes IS NULL THEN
8750: l_concat_classes := C_QUOTE;
8751: ELSE
8752: l_concat_classes := l_concat_classes || C_COMMA;

Line 8758: FROM xla_evt_class_orders_gt xec

8754: l_concat_classes := l_concat_classes || c.event_class_code;
8755: END LOOP;
8756: ELSE
8757: FOR c IN (SELECT xec.event_class_code
8758: FROM xla_evt_class_orders_gt xec
8759: ,xla_event_class_attrs xea
8760: WHERE xea.application_id = g_application_id
8761: AND xea.event_class_code = xec.event_class_code
8762: AND xea.event_class_group_code = g_process_category