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_TB_DATA_MANAGER_PVT dependencies on XLA_TB_USER_TRANS_VIEWS

Line 1784: DELETE xla_tb_user_trans_views

1780: END IF;
1781:
1782: IF g_je_source_name IS NULL THEN
1783:
1784: DELETE xla_tb_user_trans_views
1785: WHERE definition_code = p_definition_code;
1786:
1787: DELETE xla_tb_work_units
1788: WHERE definition_code = p_definition_code;

Line 1802: DELETE xla_tb_user_trans_views

1798: DELETE xla_tb_logs
1799: WHERE definition_code = p_definition_code
1800: AND je_source_name = g_je_source_name;
1801:
1802: DELETE xla_tb_user_trans_views
1803: WHERE definition_code = p_definition_code
1804: AND application_id = g_application_id;
1805:
1806: DELETE xla_trial_balances

Line 1879: DELETE xla_tb_user_trans_views

1875:
1876: DELETE xla_tb_defn_je_sources
1877: WHERE definition_code = p_definition_code;
1878:
1879: DELETE xla_tb_user_trans_views
1880: WHERE definition_code = p_definition_code;
1881:
1882: DELETE xla_tb_work_units
1883: WHERE definition_code = p_definition_code;

Line 1904: DELETE xla_tb_user_trans_views

1900: DELETE xla_tb_logs
1901: WHERE definition_code = p_definition_code
1902: AND je_source_name = g_je_source_name;
1903:
1904: DELETE xla_tb_user_trans_views
1905: WHERE definition_code = p_definition_code
1906: AND application_id = g_application_id;
1907:
1908: DELETE xla_trial_balances

Line 2481: FROM xla_tb_user_trans_views xut

2477: xut.application_id
2478: ,xec.entity_code
2479: ,xut.event_class_code
2480: ,xut.reporting_view_name
2481: FROM xla_tb_user_trans_views xut
2482: ,xla_event_classes_b xec
2483: WHERE xut.application_id = xec.application_id
2484: AND xut.event_class_code = xec.event_class_code
2485: AND xut.select_string = '###'

Line 2537: INSERT INTO xla_tb_user_trans_views

2533: IF p_definition_code IS NOT NULL THEN
2534:
2535: --perf imp 13-may-2008
2536:
2537: INSERT INTO xla_tb_user_trans_views
2538: (definition_code
2539: ,application_id
2540: ,event_class_code
2541: ,reporting_view_name

Line 2586: FROM xla_tb_user_trans_views xut

2582: AND xtb.source_application_id = xeca.application_id
2583: AND NOT EXISTS
2584: (
2585: SELECT 'x'
2586: FROM xla_tb_user_trans_views xut
2587: WHERE xut.definition_code = xtb.definition_code
2588: AND xut.application_id = xtb.source_application_id
2589: AND xtb.definition_code = p_definition_code
2590: AND xut.event_class_code = xtb.event_class_code

Line 2602: INSERT INTO xla_tb_user_trans_views

2598: -- p_definition_code is null (from gl_transfer)
2599: --
2600: IF p_group_id IS NOT NULL AND p_ledger_id IS NOT NULL
2601: THEN
2602: INSERT INTO xla_tb_user_trans_views
2603: (definition_code
2604: ,application_id
2605: ,event_class_code
2606: ,reporting_view_name

Line 2652: FROM xla_tb_user_trans_views xut

2648: AND xah.group_id = p_group_id
2649: AND NOT EXISTS
2650: (
2651: SELECT 'x'
2652: FROM xla_tb_user_trans_views xut
2653: WHERE xut.definition_code = xtd.definition_code
2654: AND xut.application_id = xah.application_id
2655: AND xut.event_class_code = xet.event_class_code
2656: AND xut.event_class_code = xeca.event_class_code

Line 2663: INSERT INTO xla_tb_user_trans_views

2659:
2660:
2661: ELSE
2662:
2663: INSERT INTO xla_tb_user_trans_views
2664: (definition_code
2665: ,application_id
2666: ,event_class_code
2667: ,reporting_view_name

Line 2710: FROM xla_tb_user_trans_views xut

2706: --AND xtb.ae_header_id
2707: --BETWEEN p_from_header_id AND p_to_header_id
2708: AND NOT EXISTS
2709: (SELECT 'x'
2710: FROM xla_tb_user_trans_views xut
2711: WHERE xut.definition_code = xtb.definition_code
2712: AND xut.application_id = xtb.source_application_id
2713: AND xut.event_class_code = xtb.event_class_code
2714: );

Line 2781: UPDATE xla_tb_user_trans_views

2777: ,l_Log_module);
2778:
2779: END IF;
2780:
2781: UPDATE xla_tb_user_trans_views
2782: SET select_string = l_select_string
2783: ,from_string = l_from_string
2784: ,where_string = l_where_string
2785: WHERE request_id = g_request_id

Line 5066: | - xla_tb_user_trans_views |

5062: | |
5063: | Deletes rows from the following tables: |
5064: | - xla_tb_logs |
5065: | - xla_tb_def_seg_ranges |
5066: | - xla_tb_user_trans_views |
5067: | - xla_tb_work_units |
5068: | |
5069: | For xla_trial_balances, call drop_partition separately |
5070: | Called from TbReportDefnsAMImpl.java. |

Line 5093: DELETE xla_tb_user_trans_views

5089:
5090: DELETE xla_tb_def_seg_ranges
5091: WHERE definition_code = p_definition_code;
5092:
5093: DELETE xla_tb_user_trans_views
5094: WHERE definition_code = p_definition_code;
5095:
5096: DELETE xla_tb_work_units
5097: WHERE definition_code = p_definition_code;