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_UPDATE_VAL dependencies on BSC_SYS_DIM_LEVELS_B

Line 136: ' FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d'||

132: TYPE t_cursor IS REF CURSOR;
133:
134: /* c_dim_cols t_cursor; -- x_input_table, h_column_type_p
135: c_dim_cols_sql VARCHAR2(2000) := 'SELECT t.column_name, d.level_view_name'||
136: ' FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d'||
137: ' WHERE t.table_name = :1 AND t.column_type = :2 AND'||
138: ' t.column_name = d.level_pk_col'; */
139:
140: cursor c_dim_cols( pTableName varchar2, pColTYpe varchar) is

Line 142: FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d

138: ' t.column_name = d.level_pk_col'; */
139:
140: cursor c_dim_cols( pTableName varchar2, pColTYpe varchar) is
141: SELECT t.column_name, d.level_view_name, d.short_name, d.source
142: FROM bsc_db_tables_cols t, bsc_sys_dim_levels_b d
143: WHERE t.table_name = pTableName
144: AND t.column_type = pColType
145: AND t.column_name = d.level_pk_col ;
146:

Line 150: h_level_table_name bsc_sys_dim_levels_b.level_view_name%TYPE;

146:
147: h_column_type_p VARCHAR2(1);
148:
149: h_column_name bsc_db_tables_cols.column_name%TYPE;
150: h_level_table_name bsc_sys_dim_levels_b.level_view_name%TYPE;
151: h_level_short_name bsc_sys_dim_levels_b.short_name%TYPE;
152: h_level_source bsc_sys_dim_levels_b.short_name%TYPE;
153: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
154:

Line 151: h_level_short_name bsc_sys_dim_levels_b.short_name%TYPE;

147: h_column_type_p VARCHAR2(1);
148:
149: h_column_name bsc_db_tables_cols.column_name%TYPE;
150: h_level_table_name bsc_sys_dim_levels_b.level_view_name%TYPE;
151: h_level_short_name bsc_sys_dim_levels_b.short_name%TYPE;
152: h_level_source bsc_sys_dim_levels_b.short_name%TYPE;
153: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
154:
155: h_sql VARCHAR2(2000);

Line 152: h_level_source bsc_sys_dim_levels_b.short_name%TYPE;

148:
149: h_column_name bsc_db_tables_cols.column_name%TYPE;
150: h_level_table_name bsc_sys_dim_levels_b.level_view_name%TYPE;
151: h_level_short_name bsc_sys_dim_levels_b.short_name%TYPE;
152: h_level_source bsc_sys_dim_levels_b.short_name%TYPE;
153: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
154:
155: h_sql VARCHAR2(2000);
156:

Line 180: ' FROM bsc_sys_dim_level_rels r, bsc_sys_dim_levels_b d1,'||

176: /* c_mn_rels t_cursor; -- 2, x_input_table, h_column_type_p, x_input_table, h_column_type_p
177: c_mn_rels_sql VARCHAR2(2000) := 'SELECT d1.level_view_name as p1_table, d1.level_pk_col as p1_pk_col,'||
178: ' d2.level_view_name as p2_table, d2.level_pk_col as p2_pk_col,'||
179: ' r.relation_col as rel_table'||
180: ' FROM bsc_sys_dim_level_rels r, bsc_sys_dim_levels_b d1,'||
181: ' bsc_sys_dim_levels_b d2'||
182: ' WHERE r.relation_type = :1 AND r.dim_level_id = ('||
183: ' SELECT min(r2.dim_level_id)'||
184: ' FROM bsc_sys_dim_level_rels r2'||

Line 181: ' bsc_sys_dim_levels_b d2'||

177: c_mn_rels_sql VARCHAR2(2000) := 'SELECT d1.level_view_name as p1_table, d1.level_pk_col as p1_pk_col,'||
178: ' d2.level_view_name as p2_table, d2.level_pk_col as p2_pk_col,'||
179: ' r.relation_col as rel_table'||
180: ' FROM bsc_sys_dim_level_rels r, bsc_sys_dim_levels_b d1,'||
181: ' bsc_sys_dim_levels_b d2'||
182: ' WHERE r.relation_type = :1 AND r.dim_level_id = ('||
183: ' SELECT min(r2.dim_level_id)'||
184: ' FROM bsc_sys_dim_level_rels r2'||
185: ' WHERE r.relation_col = r2.relation_col) AND'||

Line 201: FROM bsc_sys_dim_level_rels r, bsc_sys_dim_levels_b d1,

197: cursor c_mn_rels(pRelnType number,pTableName varchar2, pColType varchar2,pTableName2 varchar2, pColType2 varchar2) is
198: SELECT d1.level_view_name as p1_table, d1.level_pk_col as p1_pk_col,
199: d2.level_view_name as p2_table, d2.level_pk_col as p2_pk_col,
200: r.relation_col as rel_table
201: FROM bsc_sys_dim_level_rels r, bsc_sys_dim_levels_b d1,
202: bsc_sys_dim_levels_b d2
203: WHERE r.relation_type = pRelnType
204: AND r.dim_level_id = (SELECT min(r2.dim_level_id)
205: FROM bsc_sys_dim_level_rels r2

Line 202: bsc_sys_dim_levels_b d2

198: SELECT d1.level_view_name as p1_table, d1.level_pk_col as p1_pk_col,
199: d2.level_view_name as p2_table, d2.level_pk_col as p2_pk_col,
200: r.relation_col as rel_table
201: FROM bsc_sys_dim_level_rels r, bsc_sys_dim_levels_b d1,
202: bsc_sys_dim_levels_b d2
203: WHERE r.relation_type = pRelnType
204: AND r.dim_level_id = (SELECT min(r2.dim_level_id)
205: FROM bsc_sys_dim_level_rels r2
206: WHERE r.relation_col = r2.relation_col)

Line 219: h_p1_table bsc_sys_dim_levels_b.level_table_name%TYPE;

215: FROM bsc_db_tables_cols
216: WHERE table_name = pTableName2 AND column_type = pColType2);
217:
218:
219: h_p1_table bsc_sys_dim_levels_b.level_table_name%TYPE;
220: h_p1_pk_col bsc_db_tables_cols.column_name%TYPE;
221: h_p2_table bsc_sys_dim_levels_b.level_table_name%TYPE;
222: h_p2_pk_col bsc_db_tables_cols.column_name%TYPE;
223: h_rel_table bsc_sys_dim_levels_b.level_table_name%TYPE;

Line 221: h_p2_table bsc_sys_dim_levels_b.level_table_name%TYPE;

217:
218:
219: h_p1_table bsc_sys_dim_levels_b.level_table_name%TYPE;
220: h_p1_pk_col bsc_db_tables_cols.column_name%TYPE;
221: h_p2_table bsc_sys_dim_levels_b.level_table_name%TYPE;
222: h_p2_pk_col bsc_db_tables_cols.column_name%TYPE;
223: h_rel_table bsc_sys_dim_levels_b.level_table_name%TYPE;
224:
225:

Line 223: h_rel_table bsc_sys_dim_levels_b.level_table_name%TYPE;

219: h_p1_table bsc_sys_dim_levels_b.level_table_name%TYPE;
220: h_p1_pk_col bsc_db_tables_cols.column_name%TYPE;
221: h_p2_table bsc_sys_dim_levels_b.level_table_name%TYPE;
222: h_p2_pk_col bsc_db_tables_cols.column_name%TYPE;
223: h_rel_table bsc_sys_dim_levels_b.level_table_name%TYPE;
224:
225:
226: -- Bind Var. fix for POSCO
227: l_bind_vars_values BSC_UPDATE_UTIL.t_array_of_number;