APPS.XLA_TB_BALANCE_PKG dependencies on XLA_TB_USER_TRANS_VIEWS

Line 23: | XLA_TB_USER_TRANS_VIEWS_U1 violated. |

19: | 5-Mar-2009 ssawhney BUG 8222265 mainline perf changes |
20: | 20-Oct-2010 nksurana bug#10135907 Removed the parallel hint and |
21: | join with xla_trial_balances to improve |
22: | performance and avoid the error |
23: | XLA_TB_USER_TRANS_VIEWS_U1 violated. |
24: | 25-Nov-2011 nmikkili Bug 13390676 adding full(xah) and full(xal)|
25: | hints in insert to xla_trial_balances in |
26: | create_ap_balances |
27: | 22-Mar-2012 vgopiset Bug13864126 changes in create_defn_in_batch|

Line 1791: FROM xla_tb_user_trans_views xut

1787: xut.application_id
1788: ,xec.entity_code
1789: ,xut.event_class_code
1790: ,xut.reporting_view_name
1791: FROM xla_tb_user_trans_views xut
1792: ,xla_event_classes_b xec
1793: WHERE xut.application_id = xec.application_id
1794: AND xut.event_class_code = xec.event_class_code
1795: AND xut.select_string = '###'

Line 1832: INSERT INTO xla_tb_user_trans_views

1828:
1829: --add parallel hint per bug 8222265
1830: --bug#10135907 Removed the parallel hint and join with xla_trial_balances
1831:
1832: INSERT INTO xla_tb_user_trans_views
1833: (definition_code
1834: ,application_id
1835: ,event_class_code
1836: ,reporting_view_name

Line 1876: FROM xla_tb_user_trans_views xut

1872: AND xsu.je_source_name = xjs.je_source_name
1873: AND xeca.reporting_view_name IS NOT NULL
1874: AND NOT EXISTS
1875: (SELECT 'x'
1876: FROM xla_tb_user_trans_views xut
1877: WHERE xut.definition_code = xjs.definition_code
1878: AND xut.application_id = xsu.application_id
1879: AND xut.event_class_code = xeca.event_class_code
1880: );

Line 1930: UPDATE xla_tb_user_trans_views

1926: ,l_Log_module);
1927:
1928: END IF;
1929:
1930: UPDATE xla_tb_user_trans_views
1931: SET select_string = l_select_string
1932: ,from_string = l_from_string
1933: ,where_string = l_where_string
1934: WHERE application_id = l_application_id