DBA Data[Home] [Help]

APPS.XLA_JELINES_RPT_PKG dependencies on XLA_EVENT_CLASS_ATTRS

Line 1311: FROM xla_event_class_attrs

1307: l_event_classes := l_event_classes||
1308: ' AND xet.event_class_code IN (NULL';
1309:
1310: FOR c1 in (SELECT DISTINCT event_class_code
1311: FROM xla_event_class_attrs
1312: WHERE application_id = g_je_source_application_id
1313: AND reporting_view_name = p_transaction_view
1314: )
1315: LOOP

Line 1328: FROM xla_event_class_attrs xeca, xla_event_types_b xet

1324: l_event_types := l_event_types||
1325: ' AND aeh.event_type_code IN (NULL';
1326:
1327: FOR c1 in (SELECT DISTINCT xet.event_type_code
1328: FROM xla_event_class_attrs xeca, xla_event_types_b xet
1329: WHERE xeca.application_id = g_je_source_application_id
1330: AND xeca.reporting_view_name = p_transaction_view
1331: AND xeca.event_class_code = xet.event_class_code
1332: AND xeca.entity_code = xet.entity_code

Line 1391: ,xla_event_class_attrs b

1387: ' AND xet.event_class_code IN (NULL';
1388:
1389: FOR c1 in (SELECT DISTINCT event_class_code
1390: FROM xla_event_class_grps_b a
1391: ,xla_event_class_attrs b
1392: WHERE a.application_id = b.application_id
1393: AND a.event_class_group_code = b.event_class_group_code
1394: AND a.rowid = p_process_category_rowid
1395: )

Line 1410: , xla_event_class_attrs xeca

1406: ' AND aeh.event_type_code IN (NULL';
1407:
1408: FOR c1 in (SELECT DISTINCT xet.event_type_code
1409: FROM xla_event_class_grps_b xecg
1410: , xla_event_class_attrs xeca
1411: , xla_event_types_b xet
1412: WHERE xecg.application_id = xeca.application_id
1413: AND xecg.event_class_group_code = xeca.event_class_group_code
1414: AND xecg.rowid = p_process_category_rowid

Line 2792: from xla_event_class_attrs

2788: FOR c1 IN (select user_sequence,column_name from xla_event_mappings_b
2789: where application_id = g_je_source_application_id
2790: and event_class_code in
2791: (select event_class_code
2792: from xla_event_class_attrs
2793: where application_id = g_je_source_application_id
2794: and reporting_view_name = p_transaction_view
2795: and rownum = 1
2796: )