APPS.MRP_EPI dependencies on AD_DDL

Line 558: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',

554: -- bug2384395
555: -- Drop indexes before insertion
556:
557: BEGIN
558: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
559: application_short_name => 'MRP',
560: statement_type => AD_DDL.DROP_INDEX,
561: statement =>
562: 'drop index MRP_BIS_FORECAST_WB_N1',

Line 560: statement_type => AD_DDL.DROP_INDEX,

556:
557: BEGIN
558: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
559: application_short_name => 'MRP',
560: statement_type => AD_DDL.DROP_INDEX,
561: statement =>
562: 'drop index MRP_BIS_FORECAST_WB_N1',
563: object_name => 'MRP_BIS_FORECAST_WB');
564: --

Line 571: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',

567: FND_FILE.put_line(fnd_file.log,'Drop Index 1 Error : '||SQLERRM(sqlcode));
568: END;
569: --
570: BEGIN
571: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
572: application_short_name => 'MRP',
573: statement_type => AD_DDL.DROP_INDEX,
574: statement =>
575: 'drop index MRP_BIS_FORECAST_WB_N2',

Line 573: statement_type => AD_DDL.DROP_INDEX,

569: --
570: BEGIN
571: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
572: application_short_name => 'MRP',
573: statement_type => AD_DDL.DROP_INDEX,
574: statement =>
575: 'drop index MRP_BIS_FORECAST_WB_N2',
576: object_name => 'MRP_BIS_FORECAST_WB');
577:

Line 857: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',

853:
854: -- bug2384395
855: -- Create Indexes after first insert
856: BEGIN
857: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
858: application_short_name => 'MRP',
859: statement_type => AD_DDL.CREATE_INDEX,
860: statement =>
861: 'create index MRP_BIS_FORECAST_WB_N1'

Line 859: statement_type => AD_DDL.CREATE_INDEX,

855: -- Create Indexes after first insert
856: BEGIN
857: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
858: application_short_name => 'MRP',
859: statement_type => AD_DDL.CREATE_INDEX,
860: statement =>
861: 'create index MRP_BIS_FORECAST_WB_N1'
862: ||' on MRP_BIS_FORECAST_WB '
863: ||'(ORGANIZATION_ID, INVENTORY_ITEM_ID,FORECAST_DATE)'

Line 873: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',

869: ;
870: END;
871:
872: BEGIN
873: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
874: application_short_name => 'MRP',
875: statement_type => AD_DDL.CREATE_INDEX,
876: statement =>
877: 'create index MRP_BIS_FORECAST_WB_N2'

Line 875: statement_type => AD_DDL.CREATE_INDEX,

871:
872: BEGIN
873: ad_ddl.do_ddl( applsys_schema => 'APPLSYS',
874: application_short_name => 'MRP',
875: statement_type => AD_DDL.CREATE_INDEX,
876: statement =>
877: 'create index MRP_BIS_FORECAST_WB_N2'
878: ||' on MRP_BIS_FORECAST_WB '
879: ||'(ORGANIZATION_NAME, FORECAST_SET)'