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 361: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,

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

Line 363: statement_type => AD_DDL.DROP_INDEX,

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

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

406: USING lv_msc_schema, lv_msc_schema;
407:
408: IF (lv_drop_index = 1) THEN
409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index : SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
410: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
411: application_short_name => 'MSC',
412: statement_type => AD_DDL.DROP_INDEX,
413: statement =>
414: 'drop index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code,

Line 412: statement_type => AD_DDL.DROP_INDEX,

408: IF (lv_drop_index = 1) THEN
409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Dropping the index : SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
410: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
411: application_short_name => 'MSC',
412: statement_type => AD_DDL.DROP_INDEX,
413: statement =>
414: 'drop index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code,
415: object_name => 'SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code);
416:

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

462: IF lv_exchange_mode=MSC_UTIL.SYS_YES THEN
463: lv_tbl:= 'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code;
464: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
465:
466: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
467: application_short_name => 'MSC',
468: statement_type => AD_DDL.CREATE_INDEX,
469: statement =>
470: 'create index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code

Line 468: statement_type => AD_DDL.CREATE_INDEX,

464: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
465:
466: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
467: application_short_name => 'MSC',
468: statement_type => AD_DDL.CREATE_INDEX,
469: statement =>
470: 'create index SALES_ORDERS_NX_'||MSC_CL_COLLECTION.v_instance_code
471: ||' on '||'SALES_ORDERS_'||MSC_CL_COLLECTION.v_instance_code
472: ||'(link_to_line_id,reservation_type,sr_instance_id) '

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

576: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
577: lv_tbl:= 'DEMANDS_'||MSC_CL_COLLECTION.v_instance_code;
578: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
579:
580: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
581: application_short_name => 'MSC',
582: statement_type => AD_DDL.CREATE_INDEX,
583: statement =>
584: 'create index demands_nx_'||MSC_CL_COLLECTION.v_instance_code

Line 582: statement_type => AD_DDL.CREATE_INDEX,

578: lv_retval := FND_INSTALLATION.GET_APP_INFO ( 'FND', lv_dummy1, lv_dummy2, MSC_CL_COLLECTION.v_applsys_schema);
579:
580: ad_ddl.do_ddl( applsys_schema => MSC_CL_COLLECTION.v_applsys_schema,
581: application_short_name => 'MSC',
582: statement_type => AD_DDL.CREATE_INDEX,
583: statement =>
584: 'create index demands_nx_'||MSC_CL_COLLECTION.v_instance_code
585: ||' on '||'demands_'||MSC_CL_COLLECTION.v_instance_code
586: ||'(link_to_line_id,origination_type,sr_instance_id,plan_id) '