APPS.BSC_BIS_DIM_OBJ_PUB dependencies on ALL_TAB_COLUMNS

Line 3792: FROM ALL_TAB_COLUMNS

3788:
3789: --meastmon Fix bug#3337923 Performance issue: remove UPPER from left part to allow use of indexes
3790: CURSOR allTabCol1 IS
3791: SELECT Column_Name
3792: FROM ALL_TAB_COLUMNS
3793: WHERE Table_Name = UPPER(p_Dim_Level_Rec.Bsc_Level_Name)
3794: AND Column_Name LIKE l_prefix
3795: AND Owner = BSC_APPS.get_user_schema('APPS');
3796:

Line 3800: FROM ALL_TAB_COLUMNS

3796:
3797: --meastmon Fix bug#3337923 Performance issue: remove UPPER from left part to allow use of indexes
3798: CURSOR allTabCol2 IS
3799: SELECT Column_Name
3800: FROM ALL_TAB_COLUMNS
3801: WHERE Table_Name = UPPER(p_Dim_Level_Rec.Bsc_Level_Name)
3802: AND (Column_Name LIKE '%DESCRIPTION%'
3803: OR Column_Name LIKE '%NAME%'
3804: OR Column_Name LIKE '%PK')

Line 4240: FROM ALL_TAB_COLUMNS

4236: l_count NUMBER := 0;
4237:
4238: CURSOR c_view_cols IS
4239: SELECT column_name
4240: FROM ALL_TAB_COLUMNS
4241: WHERE TABLE_NAME = l_master_table
4242: AND column_name NOT IN ('LANGUAGE', 'SOURCE_LANG')
4243: AND column_name IS NOT NULL
4244: AND OWNER = BSC_APPS.get_user_schema;

Line 4538: FROM ALL_TAB_COLUMNS

4534: l_error_msg VARCHAR2(4000);
4535:
4536: CURSOR c_view_cols IS
4537: SELECT column_name
4538: FROM ALL_TAB_COLUMNS
4539: WHERE TABLE_NAME = l_master_table
4540: AND column_name IS NOT NULL
4541: AND column_name NOT IN ('LANGUAGE', 'SOURCE_LANG')
4542: AND OWNER = BSC_APPS.get_user_schema;

Line 5124: FROM ALL_TAB_COLUMNS

5120:
5121: --cursor to get the columns for creation of view based on master-table
5122: CURSOR c_view_cols IS
5123: SELECT column_name
5124: FROM ALL_TAB_COLUMNS
5125: WHERE TABLE_NAME = l_master_table
5126: AND column_name NOT IN ('LANGUAGE', 'SOURCE_LANG')
5127: AND column_name IS NOT NULL
5128: AND OWNER = BSC_APPS.get_user_schema;