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

Line 173: Level_View_Name BSC_SYS_DIM_LEVELS_B.level_view_name%type

169: --
170: dim_level_id BSC_KPI_DIM_LEVEL_PROPERTIES.dim_level_id%type,
171: level_display BSC_KPI_DIM_LEVEL_PROPERTIES.level_display%type,
172: --
173: Level_View_Name BSC_SYS_DIM_LEVELS_B.level_view_name%type
174: );
175:
176: TYPE Drill_Tbl_Type IS TABLE OF Drill_Rec_Type
177: INDEX BY BINARY_INTEGER;

Line 180: -- record type for BSC_SYS_DIM_LEVELS_B, BSC_SYS_DIM_LEVELS_TL table

176: TYPE Drill_Tbl_Type IS TABLE OF Drill_Rec_Type
177: INDEX BY BINARY_INTEGER;
178:
179:
180: -- record type for BSC_SYS_DIM_LEVELS_B, BSC_SYS_DIM_LEVELS_TL table
181:
182: Type Project_Rec_Type Is Record (
183: Dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_level_id%type,
184: Table_name BSC_SYS_DIM_LEVELS_B.level_Table_name%type,

Line 183: Dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_level_id%type,

179:
180: -- record type for BSC_SYS_DIM_LEVELS_B, BSC_SYS_DIM_LEVELS_TL table
181:
182: Type Project_Rec_Type Is Record (
183: Dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_level_id%type,
184: Table_name BSC_SYS_DIM_LEVELS_B.level_Table_name%type,
185: Table_Type BSC_SYS_DIM_LEVELS_B.table_type%type,
186: Level_pk_col BSC_SYS_DIM_LEVELS_B.Level_pk_col%type,
187: Abbreviation BSC_SYS_DIM_LEVELS_B.abbreviation%type,

Line 184: Table_name BSC_SYS_DIM_LEVELS_B.level_Table_name%type,

180: -- record type for BSC_SYS_DIM_LEVELS_B, BSC_SYS_DIM_LEVELS_TL table
181:
182: Type Project_Rec_Type Is Record (
183: Dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_level_id%type,
184: Table_name BSC_SYS_DIM_LEVELS_B.level_Table_name%type,
185: Table_Type BSC_SYS_DIM_LEVELS_B.table_type%type,
186: Level_pk_col BSC_SYS_DIM_LEVELS_B.Level_pk_col%type,
187: Abbreviation BSC_SYS_DIM_LEVELS_B.abbreviation%type,
188: Value_Order BSC_SYS_DIM_LEVELS_B.value_order_by%type,

Line 185: Table_Type BSC_SYS_DIM_LEVELS_B.table_type%type,

181:
182: Type Project_Rec_Type Is Record (
183: Dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_level_id%type,
184: Table_name BSC_SYS_DIM_LEVELS_B.level_Table_name%type,
185: Table_Type BSC_SYS_DIM_LEVELS_B.table_type%type,
186: Level_pk_col BSC_SYS_DIM_LEVELS_B.Level_pk_col%type,
187: Abbreviation BSC_SYS_DIM_LEVELS_B.abbreviation%type,
188: Value_Order BSC_SYS_DIM_LEVELS_B.value_order_by%type,
189: Comp_Order BSC_SYS_DIM_LEVELS_B.Comp_order_by%type,

Line 186: Level_pk_col BSC_SYS_DIM_LEVELS_B.Level_pk_col%type,

182: Type Project_Rec_Type Is Record (
183: Dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_level_id%type,
184: Table_name BSC_SYS_DIM_LEVELS_B.level_Table_name%type,
185: Table_Type BSC_SYS_DIM_LEVELS_B.table_type%type,
186: Level_pk_col BSC_SYS_DIM_LEVELS_B.Level_pk_col%type,
187: Abbreviation BSC_SYS_DIM_LEVELS_B.abbreviation%type,
188: Value_Order BSC_SYS_DIM_LEVELS_B.value_order_by%type,
189: Comp_Order BSC_SYS_DIM_LEVELS_B.Comp_order_by%type,
190: Custom_Group BSC_SYS_DIM_LEVELS_B.custom_group%type,

Line 187: Abbreviation BSC_SYS_DIM_LEVELS_B.abbreviation%type,

183: Dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_level_id%type,
184: Table_name BSC_SYS_DIM_LEVELS_B.level_Table_name%type,
185: Table_Type BSC_SYS_DIM_LEVELS_B.table_type%type,
186: Level_pk_col BSC_SYS_DIM_LEVELS_B.Level_pk_col%type,
187: Abbreviation BSC_SYS_DIM_LEVELS_B.abbreviation%type,
188: Value_Order BSC_SYS_DIM_LEVELS_B.value_order_by%type,
189: Comp_Order BSC_SYS_DIM_LEVELS_B.Comp_order_by%type,
190: Custom_Group BSC_SYS_DIM_LEVELS_B.custom_group%type,
191: User_size BSC_SYS_DIM_LEVELS_B.user_key_size%type,

Line 188: Value_Order BSC_SYS_DIM_LEVELS_B.value_order_by%type,

184: Table_name BSC_SYS_DIM_LEVELS_B.level_Table_name%type,
185: Table_Type BSC_SYS_DIM_LEVELS_B.table_type%type,
186: Level_pk_col BSC_SYS_DIM_LEVELS_B.Level_pk_col%type,
187: Abbreviation BSC_SYS_DIM_LEVELS_B.abbreviation%type,
188: Value_Order BSC_SYS_DIM_LEVELS_B.value_order_by%type,
189: Comp_Order BSC_SYS_DIM_LEVELS_B.Comp_order_by%type,
190: Custom_Group BSC_SYS_DIM_LEVELS_B.custom_group%type,
191: User_size BSC_SYS_DIM_LEVELS_B.user_key_size%type,
192: Disp_size BSC_SYS_DIM_LEVELS_B.disp_key_size%type,

Line 189: Comp_Order BSC_SYS_DIM_LEVELS_B.Comp_order_by%type,

185: Table_Type BSC_SYS_DIM_LEVELS_B.table_type%type,
186: Level_pk_col BSC_SYS_DIM_LEVELS_B.Level_pk_col%type,
187: Abbreviation BSC_SYS_DIM_LEVELS_B.abbreviation%type,
188: Value_Order BSC_SYS_DIM_LEVELS_B.value_order_by%type,
189: Comp_Order BSC_SYS_DIM_LEVELS_B.Comp_order_by%type,
190: Custom_Group BSC_SYS_DIM_LEVELS_B.custom_group%type,
191: User_size BSC_SYS_DIM_LEVELS_B.user_key_size%type,
192: Disp_size BSC_SYS_DIM_LEVELS_B.disp_key_size%type,
193: --

Line 190: Custom_Group BSC_SYS_DIM_LEVELS_B.custom_group%type,

186: Level_pk_col BSC_SYS_DIM_LEVELS_B.Level_pk_col%type,
187: Abbreviation BSC_SYS_DIM_LEVELS_B.abbreviation%type,
188: Value_Order BSC_SYS_DIM_LEVELS_B.value_order_by%type,
189: Comp_Order BSC_SYS_DIM_LEVELS_B.Comp_order_by%type,
190: Custom_Group BSC_SYS_DIM_LEVELS_B.custom_group%type,
191: User_size BSC_SYS_DIM_LEVELS_B.user_key_size%type,
192: Disp_size BSC_SYS_DIM_LEVELS_B.disp_key_size%type,
193: --
194: Name BSC_SYS_DIM_LEVELS_TL.name%type,

Line 191: User_size BSC_SYS_DIM_LEVELS_B.user_key_size%type,

187: Abbreviation BSC_SYS_DIM_LEVELS_B.abbreviation%type,
188: Value_Order BSC_SYS_DIM_LEVELS_B.value_order_by%type,
189: Comp_Order BSC_SYS_DIM_LEVELS_B.Comp_order_by%type,
190: Custom_Group BSC_SYS_DIM_LEVELS_B.custom_group%type,
191: User_size BSC_SYS_DIM_LEVELS_B.user_key_size%type,
192: Disp_size BSC_SYS_DIM_LEVELS_B.disp_key_size%type,
193: --
194: Name BSC_SYS_DIM_LEVELS_TL.name%type,
195: Help BSC_SYS_DIM_LEVELS_TL.help%type,

Line 192: Disp_size BSC_SYS_DIM_LEVELS_B.disp_key_size%type,

188: Value_Order BSC_SYS_DIM_LEVELS_B.value_order_by%type,
189: Comp_Order BSC_SYS_DIM_LEVELS_B.Comp_order_by%type,
190: Custom_Group BSC_SYS_DIM_LEVELS_B.custom_group%type,
191: User_size BSC_SYS_DIM_LEVELS_B.user_key_size%type,
192: Disp_size BSC_SYS_DIM_LEVELS_B.disp_key_size%type,
193: --
194: Name BSC_SYS_DIM_LEVELS_TL.name%type,
195: Help BSC_SYS_DIM_LEVELS_TL.help%type,
196: Caption_Tot BSC_SYS_DIM_LEVELS_TL.total_disp_name%type,

Line 204: Level_View_Name BSC_SYS_DIM_LEVELS_B.level_view_name%type

200: fk_field BSC_SYS_DIM_LEVEL_RELS.relation_col%type,
201: rel_type BSC_SYS_DIM_LEVEL_RELS.relation_type%type,
202: direct_rel BSC_SYS_DIM_LEVEL_RELS.direct_relation%type,
203: --
204: Level_View_Name BSC_SYS_DIM_LEVELS_B.level_view_name%type
205: );
206:
207: Type Project_Tbl_Type IS TABLE OF Project_Rec_Type
208: INDEX BY BINARY_INTEGER;

Line 211: -- record type for BSC_SYS_DIM_GROUPS_TL, BSC_SYS_DIM_LEVELS_BY_GROUP table

207: Type Project_Tbl_Type IS TABLE OF Project_Rec_Type
208: INDEX BY BINARY_INTEGER;
209:
210:
211: -- record type for BSC_SYS_DIM_GROUPS_TL, BSC_SYS_DIM_LEVELS_BY_GROUP table
212:
213: Type Dfamily_Rec_Type Is Record (
214: Dim_group_id BSC_SYS_DIM_GROUPS_TL.dim_group_id%type,
215: Name BSC_SYS_DIM_GROUPS_TL.name%type,

Line 218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,

214: Dim_group_id BSC_SYS_DIM_GROUPS_TL.dim_group_id%type,
215: Name BSC_SYS_DIM_GROUPS_TL.name%type,
216: Short_Name BSC_SYS_DIM_GROUPS_TL.short_name%type,
217: --
218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,

Line 219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,

215: Name BSC_SYS_DIM_GROUPS_TL.name%type,
216: Short_Name BSC_SYS_DIM_GROUPS_TL.short_name%type,
217: --
218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,

Line 220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,

216: Short_Name BSC_SYS_DIM_GROUPS_TL.short_name%type,
217: --
218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,

Line 221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,

217: --
218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,

Line 222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,

218: Dim_level_id BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_id%type,
219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,

Line 223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,

219: Dim_level_idx BSC_SYS_DIM_LEVELS_BY_GROUP.Dim_level_index%type,
220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type

Line 224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,

220: Total BSC_SYS_DIM_LEVELS_BY_GROUP.total_flag%type,
221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type
228: );

Line 225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,

221: Comparison BSC_SYS_DIM_LEVELS_BY_GROUP.comparison_flag%type,
222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type
228: );
229:

Line 226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,

222: filter_col BSC_SYS_DIM_LEVELS_BY_GROUP.filter_column%type,
223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type
228: );
229:
230: Type Dfamily_Tbl_Type IS TABLE OF Dfamily_Rec_Type

Line 227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type

223: filter_val BSC_SYS_DIM_LEVELS_BY_GROUP.filter_value%type,
224: default_val BSC_SYS_DIM_LEVELS_BY_GROUP.default_value%type,
225: default_type BSC_SYS_DIM_LEVELS_BY_GROUP.default_type%type,
226: Parent_Total BSC_SYS_DIM_LEVELS_BY_GROUP.parent_in_total%type,
227: No_items BSC_SYS_DIM_LEVELS_BY_GROUP.No_items%type
228: );
229:
230: Type Dfamily_Tbl_Type IS TABLE OF Dfamily_Rec_Type
231: INDEX BY BINARY_INTEGER;