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.BSC_DIM_FILTERS_PVT dependencies on BSC_SYS_FILTERS_VIEWS

Line 32: l_Level_View_Nane BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE;

28: ( p_Tab_Id NUMBER
29: , p_Dim_Level_Id NUMBER
30: ) RETURN VARCHAR2 IS
31: l_Cursor BSC_BIS_LOCKS_PUB.t_cursor;
32: l_Level_View_Nane BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE;
33: BEGIN
34: SELECT Level_View_Name
35: INTO l_Level_View_Nane
36: FROM BSC_SYS_FILTERS_VIEWS

Line 36: FROM BSC_SYS_FILTERS_VIEWS

32: l_Level_View_Nane BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE;
33: BEGIN
34: SELECT Level_View_Name
35: INTO l_Level_View_Nane
36: FROM BSC_SYS_FILTERS_VIEWS
37: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
38: AND Source_Code = p_Tab_Id
39: AND Dim_Level_Id = p_Dim_Level_Id;
40:

Line 65: FROM BSC_SYS_FILTERS_VIEWS TF

61: l_Tab_Id NUMBER;
62:
63: CURSOR c_Filters_Not_Apply IS
64: SELECT TF.Dim_Level_Id
65: FROM BSC_SYS_FILTERS_VIEWS TF
66: WHERE TF.Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
67: AND TF.Source_Code = p_Tab_Id
68: AND TF.Dim_Level_Id NOT IN
69: ( SELECT SL.Dim_Level_Id

Line 155: l_Filter_Level_View_Name BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE;

151: ) IS
152: l_Count NUMBER;
153: l_sql VARCHAR2(500);
154: l_Child_Dim_Level_Id NUMBER;
155: l_Filter_Level_View_Name BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE;
156: l_count_filter_values NUMBER;
157:
158: -- Cursor for get child dimension levels
159: CURSOR c_child_dim_obj IS

Line 275: l_Filter_Level_View_Name BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE;

271: ) IS
272: l_Count NUMBER;
273: l_sql VARCHAR2(500);
274: l_Child_Dim_Level_Id NUMBER;
275: l_Filter_Level_View_Name BSC_SYS_FILTERS_VIEWS.level_view_name%TYPE;
276:
277: BEGIN
278: ----DBMS_OUTPUT.PUT_LINE('BEGIN Drop_Filter' );
279: ----DBMS_OUTPUT.PUT_LINE('Drop_Filter p_Tab_Id = ' || p_Tab_Id );

Line 296: DELETE FROM BSC_SYS_FILTERS_VIEWS

292: ----DBMS_OUTPUT.PUT_LINE(' Drop_Filter p_Tab_Id = ' || p_Tab_Id );
293: ----DBMS_OUTPUT.PUT_LINE(' Drop_Filter p_Dim_Level_Id = ' || p_Dim_Level_Id );
294:
295: --Delete Filter Level View metadata
296: DELETE FROM BSC_SYS_FILTERS_VIEWS
297: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
298: AND Source_Code = p_Tab_Id
299: AND Dim_Level_Id = p_Dim_Level_Id;
300:

Line 301: ----DBMS_OUTPUT.PUT_LINE(' DELETE FROM BSC_SYS_FILTERS_VIEWS ' );

297: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
298: AND Source_Code = p_Tab_Id
299: AND Dim_Level_Id = p_Dim_Level_Id;
300:
301: ----DBMS_OUTPUT.PUT_LINE(' DELETE FROM BSC_SYS_FILTERS_VIEWS ' );
302:
303: -- Delete Filter Level Values metadata
304: DELETE FROM BSC_SYS_FILTERS
305: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB

Line 393: FROM BSC_SYS_FILTERS_VIEWS A

389: , BSC_KPI_DIM_LEVELS_B KD
390: , BSC_SYS_DIM_LEVELS_B SD
391: , (
392: SELECT *
393: FROM BSC_SYS_FILTERS_VIEWS A
394: WHERE A.Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB
395: AND A.Source_Code = p_Tab_Id
396: ) FV
397: WHERE TI.Tab_Id = p_Tab_Id