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.MSC_CL_DEMAND_ODS_LOAD dependencies on AD_DDL

Line 313: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

309: USING lv_msc_schema,lv_msc_schema;
310:
311: IF (lv_drop_index = 1) THEN
312: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index : DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code);
313: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
314: application_short_name => 'MSC',
315: statement_type => AD_DDL.DROP_INDEX,
316: statement =>
317: 'drop index demands_nx_'||MSC_CL_COLLECTION.v_instance_code,

Line 315: statement_type => AD_DDL.DROP_INDEX,

311: IF (lv_drop_index = 1) THEN
312: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index : DEMANDS_NX_'||MSC_CL_COLLECTION.v_instance_code);
313: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
314: application_short_name => 'MSC',
315: statement_type => AD_DDL.DROP_INDEX,
316: statement =>
317: 'drop index demands_nx_'||MSC_CL_COLLECTION.v_instance_code,
318: object_name => 'demands_nx_'||MSC_CL_COLLECTION.v_instance_code);
319:

Line 362: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

358: USING lv_msc_schema, lv_msc_schema;
359:
360: IF (lv_drop_index = 1) THEN
361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index : SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
362: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
363: application_short_name => 'MSC',
364: statement_type => AD_DDL.DROP_INDEX,
365: statement =>
366: 'drop index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code,

Line 364: statement_type => AD_DDL.DROP_INDEX,

360: IF (lv_drop_index = 1) THEN
361: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index : SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
362: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
363: application_short_name => 'MSC',
364: statement_type => AD_DDL.DROP_INDEX,
365: statement =>
366: 'drop index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code,
367: object_name => 'SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
368:

Line 418: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

414: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN
415: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
416: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
417:
418: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
419: application_short_name => 'MSC',
420: statement_type => AD_DDL.CREATE_INDEX,
421: statement =>
422: 'create index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code

Line 420: statement_type => AD_DDL.CREATE_INDEX,

416: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
417:
418: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
419: application_short_name => 'MSC',
420: statement_type => AD_DDL.CREATE_INDEX,
421: statement =>
422: 'create index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code
423: ||' on '||'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code
424: ||'(link_to_line_id,reservation_type,sr_instance_id) '

Line 532: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

528: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
529: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
530: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
531:
532: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
533: application_short_name => 'MSC',
534: statement_type => AD_DDL.CREATE_INDEX,
535: statement =>
536: 'create index demands_nx_'||MSC_CL_COLLECTION.v_instance_code

Line 534: statement_type => AD_DDL.CREATE_INDEX,

530: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
531:
532: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
533: application_short_name => 'MSC',
534: statement_type => AD_DDL.CREATE_INDEX,
535: statement =>
536: 'create index demands_nx_'||MSC_CL_COLLECTION.v_instance_code
537: ||' on '||'demands_'||MSC_CL_COLLECTION.v_instance_code
538: ||'(link_to_line_id,origination_type,sr_instance_id,plan_id) '