APPS.BSC_MO_UI_PKG dependencies on ALL_TAB_COLUMNS

Line 996: all_tab_columns cols,

992:
993: cursor cDims (l_schema IN VARCHAR2) IS
994: select lvl.name, cols.column_name
995: from
996: all_tab_columns cols,
997: bsc_sys_dim_levels_vl lvl
998: where cols.table_name = pTableName
999: and cols.owner = l_schema
1000: and cols.column_name = upper(lvl.level_pk_col)

Line 1010: all_tab_columns cols,

1006: --Added one more condition to filter out those columns
1007: cursor cMeasures (l_schema IN VARCHAR2) IS
1008: select datasets.name, cols.column_name
1009: from
1010: all_tab_columns cols,
1011: bsc_sys_measures measure, bsc_sys_datasets_vl datasets
1012: where cols.table_name = pTableName
1013: and cols.owner = l_schema
1014: and cols.column_name not in ('YEAR', 'TYPE', 'PERIOD', 'TIME_FK', 'PERIODICITY_ID', 'PERIOD_TYPE_ID')

Line 1022: all_tab_columns cols,

1018: and datasets.name is not null
1019: and cols.column_name not in
1020: (select cols.column_name
1021: from
1022: all_tab_columns cols,
1023: bsc_sys_dim_levels_vl lvl
1024: where cols.table_name = pTableName
1025: and cols.owner = l_schema
1026: and cols.column_name = upper(lvl.level_pk_col))

Line 1038: from all_tab_columns cols, bsc_sys_dim_levels_vl lvl

1034: and r.source_table_name = pTableName;
1035:
1036: cursor getDimObjNameForMN(l_schema IN VARCHAR2) IS
1037: select lvl.name, cols.column_name
1038: from all_tab_columns cols, bsc_sys_dim_levels_vl lvl
1039: where cols.table_name = pTableName
1040: and cols.owner = l_schema
1041: and cols.column_name = upper(lvl.level_pk_col)
1042: union

Line 1044: from all_tab_columns cols,

1040: and cols.owner = l_schema
1041: and cols.column_name = upper(lvl.level_pk_col)
1042: union
1043: select lvl.name, cols.column_name
1044: from all_tab_columns cols,
1045: bsc_sys_dim_levels_vl lvl, bsc_db_tables_rels r
1046: where r.source_table_name = pTableName
1047: and cols.table_name = r.TABLE_NAME
1048: and cols.owner = l_schema