DBA Data[Home] [Help]

APPS.XLA_TB_BALANCE_PKG dependencies on XLA_TB_USER_TRANS_VIEWS

Line 1779: FROM xla_tb_user_trans_views xut

1775: xut.application_id
1776: ,xec.entity_code
1777: ,xut.event_class_code
1778: ,xut.reporting_view_name
1779: FROM xla_tb_user_trans_views xut
1780: ,xla_event_classes_b xec
1781: WHERE xut.application_id = xec.application_id
1782: AND xut.event_class_code = xec.event_class_code
1783: AND xut.select_string = '###'

Line 1819: INSERT INTO xla_tb_user_trans_views

1815: END IF;
1816:
1817: --add parallel hint per bug 8222265
1818:
1819: INSERT INTO xla_tb_user_trans_views
1820: (definition_code
1821: ,application_id
1822: ,event_class_code
1823: ,reporting_view_name

Line 1864: FROM xla_tb_user_trans_views xut

1860: AND xtb.source_application_id = xeca.application_id
1861: AND xtb.definition_code = xtd.definition_code
1862: AND NOT EXISTS
1863: (SELECT 'x'
1864: FROM xla_tb_user_trans_views xut
1865: WHERE xut.definition_code = xtb.definition_code
1866: AND xut.application_id = xtb.source_application_id
1867: AND xut.event_class_code = xtb.event_class_code
1868: );

Line 1918: UPDATE xla_tb_user_trans_views

1914: ,l_Log_module);
1915:
1916: END IF;
1917:
1918: UPDATE xla_tb_user_trans_views
1919: SET select_string = l_select_string
1920: ,from_string = l_from_string
1921: ,where_string = l_where_string
1922: WHERE application_id = l_application_id