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_LEVEL_RELS

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 184: ' FROM bsc_sys_dim_level_rels r2'||

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'||
186: ' r.dim_level_id = d1.dim_level_id AND'||
187: ' r.parent_dim_level_id = d2.dim_level_id AND'||
188: ' d1.level_pk_col in ('||

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 205: FROM bsc_sys_dim_level_rels r2

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)
207: AND r.dim_level_id = d1.dim_level_id
208: AND r.parent_dim_level_id = d2.dim_level_id
209: AND d1.level_pk_col in ( SELECT column_name