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 2945: SELECT DISTINCT xla_evt_class_orders_gt.processing_order

2941:
2942: -- 7193986 start
2943:
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,

Line 2950: xla_evt_class_orders_gt

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

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

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
2963: trace

Line 3296: INSERT INTO xla_evt_class_orders_gt

3292: ,p_module => l_log_module);
3293: END IF;
3294:
3295:
3296: INSERT INTO xla_evt_class_orders_gt
3297: (event_class_code
3298: ,processing_order
3299: )
3300: SELECT xec.event_class_code

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

3318:
3319:
3320: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3321: trace
3322: (p_msg => 'Number of rows inserted into xla_evt_class_orders_gt = '||SQL%ROWCOUNT
3323: ,p_level => C_LEVEL_STATEMENT
3324: ,p_module => l_log_module);
3325: END IF;
3326:

Line 4343: xla_evt_class_orders_gt xpo,

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

Line 4376: ,xla_evt_class_orders_gt xpo

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

Line 4431: FROM xla_evt_class_orders_gt xpo

4427: FROM xla_je_categories xjc,
4428: (
4429: SELECT
4430: xpo.event_class_code
4431: FROM xla_evt_class_orders_gt xpo
4432: WHERE xpo.processing_order = p_processing_order
4433: ) tab1
4434: WHERE xjc.application_id = g_application_id
4435: AND xjc.ledger_id = g_ledger_id

Line 4798: INSERT INTO xla_evt_class_orders_gt

4794: ,p_level => C_LEVEL_PROCEDURE
4795: ,p_module => l_log_module);
4796: END IF;
4797:
4798: INSERT INTO xla_evt_class_orders_gt
4799: (event_class_code
4800: ,processing_order
4801: )
4802: SELECT xec.event_class_code

Line 4823: FROM xla_evt_class_orders_gt;

4819: AND xec.event_class_code <> 'MANUAL';
4820:
4821: SELECT max(processing_order)
4822: INTO l_max_processing_order
4823: FROM xla_evt_class_orders_gt;
4824:
4825: IF (l_max_processing_order = -1) THEN
4826: l_num_level := 1;
4827: ELSE

Line 7061: xla_evt_class_orders_gt

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

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:

Line 7070: AND xla_evt_class_orders_gt.processing_order = l_processing_order

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

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

8251: --
8252: -- changes done for bug 5673550 to put filter based on process category
8253: --
8254: IF g_process_category IS NULL THEN
8255: FOR c IN (SELECT event_class_code FROM xla_evt_class_orders_gt WHERE processing_order = p_processing_order) LOOP
8256: IF l_concat_classes IS NULL THEN
8257: l_concat_classes := C_QUOTE;
8258: ELSE
8259: l_concat_classes := l_concat_classes || C_COMMA;

Line 8265: FROM xla_evt_class_orders_gt xec

8261: l_concat_classes := l_concat_classes || c.event_class_code;
8262: END LOOP;
8263: ELSE
8264: FOR c IN (SELECT xec.event_class_code
8265: FROM xla_evt_class_orders_gt xec
8266: ,xla_event_class_attrs xea
8267: WHERE xea.application_id = g_application_id
8268: AND xea.event_class_code = xec.event_class_code
8269: AND xea.event_class_group_code = g_process_category