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_BIS_DIM_OBJ_PUB dependencies on USER_OBJECTS

Line 4320: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

4316: RAISE FND_API.G_EXC_ERROR;
4317: END IF;
4318: --Need to initiliaze in order to Do_DDL works fine
4319:
4320: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4321: ' WHERE OBJECT_NAME = :1';
4322:
4323: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
4324:

Line 4365: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

4361: l_col_names := NULL;
4362: --Bug #3081595
4363: l_col_names := 'USER_CODE, NAME ';
4364:
4365: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4366: ' WHERE OBJECT_NAME = :1';
4367:
4368: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_input_table;
4369:

Line 4623: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

4619: END IF;
4620: --check if old master tables, views, input table exists in the system.
4621: --if they do not exists than call BSC_BIS_DIM_OBJ_PUB.Create_Bsc_Master_Tabs otherwise proceed further
4622: l_flag := TRUE;
4623: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4624: ' WHERE OBJECT_NAME = :1';
4625:
4626: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING p_Dim_Level_Rec_Old.Bsc_Level_Name;
4627: IF (l_count = 0) THEN

Line 4630: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

4626: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING p_Dim_Level_Rec_Old.Bsc_Level_Name;
4627: IF (l_count = 0) THEN
4628: l_flag := FALSE;
4629: END IF;
4630: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4631: ' WHERE OBJECT_NAME = :1';
4632: l_bind_variable := 'BSC_D_'||p_Dim_Level_Rec_Old.Bsc_Level_Id||'_VL';
4633: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_bind_variable;
4634: IF (l_count = 0) THEN

Line 4637: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

4633: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_bind_variable;
4634: IF (l_count = 0) THEN
4635: l_flag := FALSE;
4636: END IF;
4637: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4638: ' WHERE OBJECT_NAME = :1';
4639:
4640: l_bind_variable := 'BSC_DI_'||p_Dim_Level_Rec_Old.Bsc_Level_Id;
4641: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_bind_variable;

Line 4705: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

4701: END IF;
4702: END IF;
4703: IF (l_master_table <> UPPER(p_Dim_Level_Rec_Old.Bsc_Level_Name)) THEN
4704: l_Create_View := TRUE;
4705: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4706: ' WHERE OBJECT_NAME = :1';
4707:
4708: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
4709: IF (l_count <> 0) THEN

Line 4895: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

4891: ELSE
4892: l_master_table := 'BSC_D_'||UPPER(l_abbreviation)||'_'||UPPER(p_Dim_Level_Rec.Bsc_Level_Abbreviation);
4893: END IF;
4894:
4895: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4896: ' WHERE OBJECT_NAME = :1';
4897:
4898: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_input_table;
4899: IF (l_count = 0) THEN

Line 4911: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

4907: ELSE
4908: l_old_mas_name := 'BSC_D_'||UPPER(p_Dim_Level_Rec_Old.Bsc_Level_Abbreviation)||'_'||UPPER(l_abbreviation);
4909: END IF;
4910:
4911: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4912: ' WHERE OBJECT_NAME = :1';
4913:
4914: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
4915: IF (l_count <> 0) THEN

Line 4919: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

4915: IF (l_count <> 0) THEN
4916: l_sql_stmt := 'DROP TABLE '||l_master_table;
4917: BSC_APPS.Do_Ddl_AT(l_sql_stmt, ad_ddl.drop_table, l_master_table, BSC_APPS.fnd_apps_schema, BSC_APPS.bsc_apps_short_name);
4918: END IF;
4919: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
4920: ' WHERE OBJECT_NAME = :1';
4921:
4922: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_old_mas_name;
4923: IF (l_count = 0) THEN

Line 5165: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

5161: l_master_table := UPPER(l_master_table);
5162: l_input_table := 'BSC_DI_'||cd.Dim_Level_Id;
5163: l_view_name := 'BSC_D_'||cd.Dim_Level_Id||'_VL';
5164:
5165: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
5166: ' WHERE OBJECT_NAME = :1';
5167:
5168: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_master_table;
5169: IF (l_count = 0) THEN

Line 5174: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||

5170: x_msg_data := 'Master Table does not exists '||l_master_table;
5171: RAISE FND_API.G_EXC_ERROR;
5172: END IF;
5173:
5174: l_sql_stmt := ' SELECT COUNT(1) FROM USER_OBJECTS '||
5175: ' WHERE OBJECT_NAME = :1';
5176:
5177: EXECUTE IMMEDIATE l_sql_stmt INTO l_count USING l_input_table;
5178: IF (l_count = 0) THEN

Line 6664: FROM user_objects

6660: WHERE table_name = p_view_name;
6661:
6662: CURSOR c_view_status IS
6663: SELECT status
6664: FROM user_objects
6665: WHERE object_name = p_view_name
6666: AND object_type = 'VIEW';
6667: BEGIN
6668: