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 1833: DELETE xla_tb_user_trans_views

1829: END IF;
1830:
1831: IF g_je_source_name IS NULL THEN
1832:
1833: DELETE xla_tb_user_trans_views
1834: WHERE definition_code = p_definition_code;
1835:
1836: DELETE xla_tb_work_units
1837: WHERE definition_code = p_definition_code;

Line 1851: DELETE xla_tb_user_trans_views

1847: DELETE xla_tb_logs
1848: WHERE definition_code = p_definition_code
1849: AND je_source_name = g_je_source_name;
1850:
1851: DELETE xla_tb_user_trans_views
1852: WHERE definition_code = p_definition_code
1853: AND application_id = g_application_id;
1854:
1855: DELETE xla_trial_balances

Line 1928: DELETE xla_tb_user_trans_views

1924:
1925: DELETE xla_tb_defn_je_sources
1926: WHERE definition_code = p_definition_code;
1927:
1928: DELETE xla_tb_user_trans_views
1929: WHERE definition_code = p_definition_code;
1930:
1931: DELETE xla_tb_work_units
1932: WHERE definition_code = p_definition_code;

Line 1953: DELETE xla_tb_user_trans_views

1949: DELETE xla_tb_logs
1950: WHERE definition_code = p_definition_code
1951: AND je_source_name = g_je_source_name;
1952:
1953: DELETE xla_tb_user_trans_views
1954: WHERE definition_code = p_definition_code
1955: AND application_id = g_application_id;
1956:
1957: DELETE xla_trial_balances

Line 2530: FROM xla_tb_user_trans_views xut

2526: xut.application_id
2527: ,xec.entity_code
2528: ,xut.event_class_code
2529: ,xut.reporting_view_name
2530: FROM xla_tb_user_trans_views xut
2531: ,xla_event_classes_b xec
2532: WHERE xut.application_id = xec.application_id
2533: AND xut.event_class_code = xec.event_class_code
2534: AND xut.select_string = '###'

Line 2592: INSERT INTO xla_tb_user_trans_views

2588: -- used the following tables in the join ie xla_tb_defn_je_sources and
2589: -- xla_subledgers.
2590:
2591:
2592: INSERT INTO xla_tb_user_trans_views
2593: (definition_code
2594: ,application_id
2595: ,event_class_code
2596: ,reporting_view_name

Line 2639: FROM xla_tb_user_trans_views xut

2635: AND xeca.reporting_view_name IS NOT NULL
2636: AND NOT EXISTS
2637: (
2638: SELECT 'x'
2639: FROM xla_tb_user_trans_views xut
2640: WHERE xut.definition_code = xjs.definition_code
2641: AND xut.application_id = xsu.application_id
2642: AND xut.event_class_code = xeca.event_class_code
2643: );

Line 2654: INSERT INTO xla_tb_user_trans_views

2650: -- p_definition_code is null (from gl_transfer)
2651: --
2652: IF p_group_id IS NOT NULL AND p_ledger_id IS NOT NULL
2653: THEN
2654: INSERT INTO xla_tb_user_trans_views
2655: (definition_code
2656: ,application_id
2657: ,event_class_code
2658: ,reporting_view_name

Line 2705: FROM xla_tb_user_trans_views xut

2701: AND xeca.reporting_view_name IS NOT NULL -- added for bug11770090
2702: AND NOT EXISTS
2703: (
2704: SELECT 'x'
2705: FROM xla_tb_user_trans_views xut
2706: WHERE xut.definition_code = xtd.definition_code
2707: AND xut.application_id = xah.application_id
2708: AND xut.event_class_code = xet.event_class_code
2709: AND xut.event_class_code = xeca.event_class_code

Line 2721: INSERT INTO xla_tb_user_trans_views

2717: -- table in the from clause. To get the definition code and application id
2718: -- used the following tables in the join ie xla_tb_defn_je_sources and
2719: -- xla_subledgers.
2720:
2721: INSERT INTO xla_tb_user_trans_views
2722: (definition_code
2723: ,application_id
2724: ,event_class_code
2725: ,reporting_view_name

Line 2765: FROM xla_tb_user_trans_views xut

2761: AND xsu.je_source_name = xjs.je_source_name
2762: AND xeca.reporting_view_name IS NOT NULL
2763: AND NOT EXISTS
2764: (SELECT 'x'
2765: FROM xla_tb_user_trans_views xut
2766: WHERE xut.definition_code = xjs.definition_code
2767: AND xut.application_id = xsu.application_id
2768: AND xut.event_class_code = xeca.event_class_code
2769: );

Line 2836: UPDATE xla_tb_user_trans_views

2832: ,l_Log_module);
2833:
2834: END IF;
2835:
2836: UPDATE xla_tb_user_trans_views
2837: SET select_string = l_select_string
2838: ,from_string = l_from_string
2839: ,where_string = l_where_string
2840: WHERE request_id = g_request_id

Line 5222: | - xla_tb_user_trans_views |

5218: | |
5219: | Deletes rows from the following tables: |
5220: | - xla_tb_logs |
5221: | - xla_tb_def_seg_ranges |
5222: | - xla_tb_user_trans_views |
5223: | - xla_tb_work_units |
5224: | |
5225: | For xla_trial_balances, call drop_partition separately |
5226: | Called from TbReportDefnsAMImpl.java. |

Line 5249: DELETE xla_tb_user_trans_views

5245:
5246: DELETE xla_tb_def_seg_ranges
5247: WHERE definition_code = p_definition_code;
5248:
5249: DELETE xla_tb_user_trans_views
5250: WHERE definition_code = p_definition_code;
5251:
5252: DELETE xla_tb_work_units
5253: WHERE definition_code = p_definition_code;