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_DIM_TPLATE dependencies on AD_DDL

Line 115: ad_ddl.drop_table,

111: l_sql_stmt := 'Drop Table BSC_D_TYPE_OF_ACCOUNT';
112: l_debug_stmt := l_sql_stmt;
113:
114: BSC_APPS.DO_DDL(l_sql_stmt,
115: ad_ddl.drop_table,
116: 'BSC_D_TYPE_OF_ACCOUNT');
117: end if;
118:
119: l_sql_stmt := 'Create Table BSC_D_TYPE_OF_ACCOUNT (' ||

Line 131: ad_ddl.create_table,

127:
128: l_debug_stmt := l_sql_stmt;
129:
130: BSC_APPS.DO_DDL(l_sql_stmt,
131: ad_ddl.create_table,
132: 'BSC_D_TYPE_OF_ACCOUNT');
133:
134:
135: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_TYPE_OF_ACCOUNT_U1 ON BSC_D_TYPE_OF_ACCOUNT (CODE,LANGUAGE)'||

Line 140: ad_ddl.create_index,

136: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
137: ' '||BSC_APPS.bsc_storage_clause;
138: l_debug_stmt := l_sql_stmt;
139: BSC_APPS.DO_DDL(l_sql_stmt,
140: ad_ddl.create_index,
141: 'BSC_D_TYPE_OF_ACCOUNT_U1');
142:
143: -- Create View
144: l_sql_stmt := 'Create or replace view BSC_D_2_VL AS (' ||

Line 153: ad_ddl.create_view,

149: ' WHERE LANGUAGE = userenv(''LANG''))';
150:
151: l_debug_stmt := l_sql_stmt;
152: BSC_APPS.DO_DDL(l_sql_stmt,
153: ad_ddl.create_view,
154: 'BSC_D_2_VL');
155:
156: -- Create Input table
157: l_object_type := 'BSC_DI_2';

Line 168: ad_ddl.drop_table,

164: l_sql_stmt := 'Drop Table BSC_DI_2';
165: l_debug_stmt := l_sql_stmt;
166:
167: BSC_APPS.DO_DDL(l_sql_stmt,
168: ad_ddl.drop_table,
169: 'BSC_DI_2');
170: end if;
171:
172: l_sql_stmt := 'Create Table BSC_DI_2 (' ||

Line 180: ad_ddl.create_table,

176: ' '||BSC_APPS.bsc_storage_clause;
177: l_debug_stmt := l_sql_stmt;
178:
179: BSC_APPS.DO_DDL(l_sql_stmt,
180: ad_ddl.create_table,
181: 'BSC_DI_2');
182:
183: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_2_U1 ON BSC_DI_2 (USER_CODE)'||
184: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||

Line 188: ad_ddl.create_index,

184: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
185: ' '||BSC_APPS.bsc_storage_clause;
186: l_debug_stmt := l_sql_stmt;
187: BSC_APPS.DO_DDL(l_sql_stmt,
188: ad_ddl.create_index,
189: 'BSC_DI_2_U1');
190:
191:
192: -- create Account dimension table

Line 205: ad_ddl.drop_table,

201: l_sql_stmt := 'Drop Table BSC_D_ACCOUNT';
202: l_debug_stmt := l_sql_stmt;
203:
204: BSC_APPS.DO_DDL(l_sql_stmt,
205: ad_ddl.drop_table,
206: 'BSC_D_ACCOUNT');
207: end if;
208:
209: l_sql_stmt := 'Create Table BSC_D_ACCOUNT ( ' ||

Line 223: ad_ddl.create_table,

219: ' '||BSC_APPS.bsc_storage_clause;
220: l_debug_stmt := l_sql_stmt;
221:
222: BSC_APPS.DO_DDL(l_sql_stmt,
223: ad_ddl.create_table,
224: 'BSC_D_ACCOUNT');
225:
226: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_ACCOUNT_U1 ON BSC_D_ACCOUNT (CODE,LANGUAGE)'||
227: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||

Line 231: ad_ddl.create_index,

227: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
228: ' '||BSC_APPS.bsc_storage_clause;
229: l_debug_stmt := l_sql_stmt;
230: BSC_APPS.DO_DDL(l_sql_stmt,
231: ad_ddl.create_index,
232: 'BSC_D_ACCOUNT_U1');
233: -- Create View
234: l_sql_stmt := 'Create or replace view BSC_D_0_VL AS (' ||
235: ' SELECT CODE,'||

Line 246: ad_ddl.create_view,

242: ' WHERE LANGUAGE = userenv(''LANG''))';
243:
244: l_debug_stmt := l_sql_stmt;
245: BSC_APPS.DO_DDL(l_sql_stmt,
246: ad_ddl.create_view,
247: 'BSC_D_0_VL');
248:
249: -- Create Input table
250: l_object_type := 'BSC_DI_0' ;

Line 261: ad_ddl.drop_table,

257: l_sql_stmt := 'Drop Table BSC_DI_0';
258: l_debug_stmt := l_sql_stmt;
259:
260: BSC_APPS.DO_DDL(l_sql_stmt,
261: ad_ddl.drop_table,
262: 'BSC_DI_0');
263: end if;
264:
265: l_sql_stmt := 'Create Table BSC_DI_0 (' ||

Line 275: ad_ddl.create_table,

271: ' '||BSC_APPS.bsc_storage_clause;
272: l_debug_stmt := l_sql_stmt;
273:
274: BSC_APPS.DO_DDL(l_sql_stmt,
275: ad_ddl.create_table,
276: 'BSC_DI_0');
277:
278: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_0_U1 ON BSC_DI_0 (USER_CODE)'||
279: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||

Line 283: ad_ddl.create_index,

279: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
280: ' '||BSC_APPS.bsc_storage_clause;
281: l_debug_stmt := l_sql_stmt;
282: BSC_APPS.DO_DDL(l_sql_stmt,
283: ad_ddl.create_index,
284: 'BSC_DI_0_U1');
285:
286:
287: -- create Subaccount Type dimension table

Line 300: ad_ddl.drop_table,

296: l_sql_stmt := 'Drop Table BSC_D_SUBACCOUNT';
297: l_debug_stmt := l_sql_stmt;
298:
299: BSC_APPS.DO_DDL(l_sql_stmt,
300: ad_ddl.drop_table,
301: 'BSC_D_SUBACCOUNT');
302: end if;
303:
304: l_sql_stmt := 'Create Table BSC_D_SUBACCOUNT ( ' ||

Line 317: ad_ddl.create_table,

313: ' '||BSC_APPS.bsc_storage_clause;
314:
315: l_debug_stmt := l_sql_stmt;
316: BSC_APPS.DO_DDL(l_sql_stmt,
317: ad_ddl.create_table,
318: 'BSC_D_SUBACCOUNT');
319:
320: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_SUBACCOUNT_U1 ON BSC_D_SUBACCOUNT (CODE,LANGUAGE)'||
321: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||

Line 326: ad_ddl.create_index,

322: ' '||BSC_APPS.bsc_storage_clause;
323: l_debug_stmt := l_sql_stmt;
324:
325: BSC_APPS.DO_DDL(l_sql_stmt,
326: ad_ddl.create_index,
327: 'BSC_D_SUBACCOUNT_U1');
328:
329: -- Create View
330: l_sql_stmt := 'Create or replace view BSC_D_1_VL AS (' ||

Line 341: ad_ddl.create_view,

337: ' WHERE LANGUAGE = userenv(''LANG''))';
338:
339: l_debug_stmt := l_sql_stmt;
340: BSC_APPS.DO_DDL(l_sql_stmt,
341: ad_ddl.create_view,
342: 'BSC_D_1_VL');
343:
344: -- Create Input table
345:

Line 357: ad_ddl.drop_table,

353: l_sql_stmt := 'Drop Table BSC_DI_1';
354: l_debug_stmt := l_sql_stmt;
355:
356: BSC_APPS.DO_DDL(l_sql_stmt,
357: ad_ddl.drop_table,
358: 'BSC_DI_1');
359: end if;
360:
361: l_sql_stmt := 'Create Table BSC_DI_1 (' ||

Line 370: ad_ddl.create_table,

366: ' '||BSC_APPS.bsc_storage_clause;
367: l_debug_stmt := l_sql_stmt;
368:
369: BSC_APPS.DO_DDL(l_sql_stmt,
370: ad_ddl.create_table,
371: 'BSC_DI_1');
372:
373: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_1_U1 ON BSC_DI_1 (USER_CODE)'||
374: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||

Line 378: ad_ddl.create_index,

374: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
375: ' '||BSC_APPS.bsc_storage_clause;
376: l_debug_stmt := l_sql_stmt;
377: BSC_APPS.DO_DDL(l_sql_stmt,
378: ad_ddl.create_index,
379: 'BSC_DI_1_U1');
380:
381: if (is_cross_template) then
382:

Line 393: ad_ddl.drop_table,

389: if (l_project_count <> 0) then
390: l_sql_stmt := 'Drop Table BSC_D_PROJECT';
391: l_debug_stmt := l_sql_stmt;
392: BSC_APPS.DO_DDL(l_sql_stmt,
393: ad_ddl.drop_table,
394: 'BSC_D_PROJECT');
395:
396: end if;
397:

Line 411: ad_ddl.create_table,

407: ' '||BSC_APPS.bsc_storage_clause;
408:
409: l_debug_stmt := l_sql_stmt;
410: BSC_APPS.DO_DDL(l_sql_stmt,
411: ad_ddl.create_table,
412: 'BSC_D_PROJECT');
413:
414: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_D_PROJECT_U1 ON BSC_D_PROJECT (CODE,LANGUAGE)'||
415: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||

Line 419: ad_ddl.create_index,

415: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.dimension_index_tbs_type)||
416: ' '||BSC_APPS.bsc_storage_clause;
417: l_debug_stmt := l_sql_stmt;
418: BSC_APPS.DO_DDL(l_sql_stmt,
419: ad_ddl.create_index,
420: 'BSC_D_PROJECT_U1');
421: -- Create View
422: l_sql_stmt := 'Create or replace view BSC_D_3_VL AS (' ||
423: ' SELECT CODE,'||

Line 431: ad_ddl.create_view,

427: ' WHERE LANGUAGE = userenv(''LANG''))';
428:
429: l_debug_stmt := l_sql_stmt;
430: BSC_APPS.DO_DDL(l_sql_stmt,
431: ad_ddl.create_view,
432: 'BSC_D_3_VL');
433: -- Create Input table
434: l_object_type := 'BSC_DI_3' ;
435: Select count(*)

Line 445: ad_ddl.drop_table,

441: l_sql_stmt := 'Drop Table BSC_DI_3';
442: l_debug_stmt := l_sql_stmt;
443:
444: BSC_APPS.DO_DDL(l_sql_stmt,
445: ad_ddl.drop_table,
446: 'BSC_DI_1');
447: end if;
448:
449: l_sql_stmt := 'Create Table BSC_DI_3 (' ||

Line 458: ad_ddl.create_table,

454:
455: l_debug_stmt := l_sql_stmt;
456:
457: BSC_APPS.DO_DDL(l_sql_stmt,
458: ad_ddl.create_table,
459: 'BSC_DI_1');
460:
461: l_sql_stmt := 'CREATE UNIQUE INDEX BSC_DI_3_U1 ON BSC_DI_3 (USER_CODE)'||
462: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||

Line 466: ad_ddl.create_index,

462: ' TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.input_index_tbs_type)||
463: ' '||BSC_APPS.bsc_storage_clause;
464: l_debug_stmt := l_sql_stmt;
465: BSC_APPS.DO_DDL(l_sql_stmt,
466: ad_ddl.create_index,
467: 'BSC_DI_3_U1');
468:
469:
470: -- populating Project dimension value