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

Line 535: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

531: IF v_item_enabled = SYS_YES THEN
532:
533: BEGIN
534:
535: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
536: application_short_name => 'MSC',
537: statement_type => AD_DDL.CREATE_INDEX,
538: statement =>
539: 'create index MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code

Line 537: statement_type => AD_DDL.CREATE_INDEX,

533: BEGIN
534:
535: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
536: application_short_name => 'MSC',
537: statement_type => AD_DDL.CREATE_INDEX,
538: statement =>
539: 'create index MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code
540: ||' on MSC_ST_SYSTEM_ITEMS '
541: ||'(item_name, sr_instance_code, organization_code, company_name) '

Line 560: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

556:
557: IF v_mat_sup_enabled = SYS_YES THEN
558:
559: BEGIN
560: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
561: application_short_name => 'MSC',
562: statement_type => AD_DDL.CREATE_INDEX,
563: statement =>
564: 'create index MSC_ST_SUPPLIES_N1_'||v_instance_code

Line 562: statement_type => AD_DDL.CREATE_INDEX,

558:
559: BEGIN
560: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
561: application_short_name => 'MSC',
562: statement_type => AD_DDL.CREATE_INDEX,
563: statement =>
564: 'create index MSC_ST_SUPPLIES_N1_'||v_instance_code
565: ||' on MSC_ST_SUPPLIES '
566: ||'(SR_INSTANCE_CODE, ORDER_NUMBER, PURCH_LINE_NUM, ORDER_TYPE, COMPANY_NAME) '

Line 577: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

573: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Error creating Index MSC_ST_SUPPLIES_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));
574: END;
575:
576: BEGIN
577: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
578: application_short_name => 'MSC',
579: statement_type => AD_DDL.CREATE_INDEX,
580: statement =>
581: 'create index MSC_ST_SUPPLIES_N2_'||v_instance_code

Line 579: statement_type => AD_DDL.CREATE_INDEX,

575:
576: BEGIN
577: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
578: application_short_name => 'MSC',
579: statement_type => AD_DDL.CREATE_INDEX,
580: statement =>
581: 'create index MSC_ST_SUPPLIES_N2_'||v_instance_code
582: ||' on MSC_ST_SUPPLIES '
583: ||'(sr_instance_code, schedule_line_num, schedule_designator, organization_code, order_type, company_name) '

Line 594: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Error creating Index MSC_ST_SUPPLIES_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
591: END;
592:
593: BEGIN
594: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
595: application_short_name => 'MSC',
596: statement_type => AD_DDL.CREATE_INDEX,
597: statement =>
598: 'create index MSC_ST_SUPPLIES_N3_'||v_instance_code

Line 596: statement_type => AD_DDL.CREATE_INDEX,

592:
593: BEGIN
594: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
595: application_short_name => 'MSC',
596: statement_type => AD_DDL.CREATE_INDEX,
597: statement =>
598: 'create index MSC_ST_SUPPLIES_N3_'||v_instance_code
599: ||' on MSC_ST_SUPPLIES '
600: ||'(sr_instance_code, item_name, organization_code, order_type, company_name) '

Line 613: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

609: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
610: END;
611:
612: BEGIN
613: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
614: application_short_name => 'MSC',
615: statement_type => AD_DDL.CREATE_INDEX,
616: statement =>
617: 'create index MSC_ST_SUPPLIES_N4_'||v_instance_code

Line 615: statement_type => AD_DDL.CREATE_INDEX,

611:
612: BEGIN
613: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
614: application_short_name => 'MSC',
615: statement_type => AD_DDL.CREATE_INDEX,
616: statement =>
617: 'create index MSC_ST_SUPPLIES_N4_'||v_instance_code
618: ||' on MSC_ST_SUPPLIES '
619: ||'(sr_instance_code,wip_entity_name, organization_code,order_type, company_name) '

Line 637: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

633:
634: IF v_mat_dmd_enabled = SYS_YES THEN
635:
636: BEGIN
637: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
638: application_short_name => 'MSC',
639: statement_type => AD_DDL.CREATE_INDEX,
640: statement =>
641: 'create index MSC_ST_DEMANDS_N1_'||v_instance_code

Line 639: statement_type => AD_DDL.CREATE_INDEX,

635:
636: BEGIN
637: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
638: application_short_name => 'MSC',
639: statement_type => AD_DDL.CREATE_INDEX,
640: statement =>
641: 'create index MSC_ST_DEMANDS_N1_'||v_instance_code
642: ||' on MSC_ST_DEMANDS '
643: ||'(sr_instance_code, schedule_date, item_name, organization_code, forecast_designator, company_name) '

Line 655: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

651: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_DEMANDS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
652: END;
653:
654: BEGIN
655: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
656: application_short_name => 'MSC',
657: statement_type => AD_DDL.CREATE_INDEX,
658: statement =>
659: 'create index MSC_ST_DEMANDS_N2_'||v_instance_code

Line 657: statement_type => AD_DDL.CREATE_INDEX,

653:
654: BEGIN
655: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
656: application_short_name => 'MSC',
657: statement_type => AD_DDL.CREATE_INDEX,
658: statement =>
659: 'create index MSC_ST_DEMANDS_N2_'||v_instance_code
660: ||' on MSC_ST_DEMANDS '
661: ||'(SR_INSTANCE_CODE, ITEM_NAME,WIP_ENTITY_NAME, ORGANIZATION_CODE, ORIGINATION_TYPE, OPERATION_SEQ_CODE, COMPANY_NAME) '

Line 673: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

669: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_DEMANDS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
670: END;
671:
672: BEGIN
673: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
674: application_short_name => 'MSC',
675: statement_type => AD_DDL.CREATE_INDEX,
676: statement =>
677: 'create index MSC_ST_SO_N1_'||v_instance_code

Line 675: statement_type => AD_DDL.CREATE_INDEX,

671:
672: BEGIN
673: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
674: application_short_name => 'MSC',
675: statement_type => AD_DDL.CREATE_INDEX,
676: statement =>
677: 'create index MSC_ST_SO_N1_'||v_instance_code
678: ||' on MSC_ST_SALES_ORDERS '
679: ||'(sr_instance_code, sales_order_number, line_num, organization_code, company_name) '

Line 698: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

694:
695: IF v_reserve_enabled = SYS_YES THEN
696:
697: BEGIN
698: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
699: application_short_name => 'MSC',
700: statement_type => AD_DDL.CREATE_INDEX,
701: statement =>
702: 'create index MSC_ST_RESERVE_N1_'||v_instance_code

Line 700: statement_type => AD_DDL.CREATE_INDEX,

696:
697: BEGIN
698: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
699: application_short_name => 'MSC',
700: statement_type => AD_DDL.CREATE_INDEX,
701: statement =>
702: 'create index MSC_ST_RESERVE_N1_'||v_instance_code
703: ||' on MSC_ST_RESERVATIONS '
704: ||'(sr_instance_code,sales_order_number, line_num,organization_code,company_name ) '

Line 724: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

720:
721: IF v_bom_enabled = SYS_YES THEN
722:
723: BEGIN
724: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
725: application_short_name => 'MSC',
726: statement_type => AD_DDL.CREATE_INDEX,
727: statement =>
728: 'create index MSC_ST_BOMS_N1_'||v_instance_code

Line 726: statement_type => AD_DDL.CREATE_INDEX,

722:
723: BEGIN
724: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
725: application_short_name => 'MSC',
726: statement_type => AD_DDL.CREATE_INDEX,
727: statement =>
728: 'create index MSC_ST_BOMS_N1_'||v_instance_code
729: ||' on MSC_ST_BOMS '
730: ||'(sr_instance_code, assembly_name, organization_code, company_name, bom_name, alternate_bom_designator) '

Line 741: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
738: END;
739:
740: BEGIN
741: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
742: application_short_name => 'MSC',
743: statement_type => AD_DDL.CREATE_INDEX,
744: statement =>
745: 'create index MSC_ST_BOM_COMP_N1_'||v_instance_code

Line 743: statement_type => AD_DDL.CREATE_INDEX,

739:
740: BEGIN
741: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
742: application_short_name => 'MSC',
743: statement_type => AD_DDL.CREATE_INDEX,
744: statement =>
745: 'create index MSC_ST_BOM_COMP_N1_'||v_instance_code
746: ||' on MSC_ST_BOM_COMPONENTS '
747: ||'(sr_instance_code, assembly_name, component_name, effectivity_date, operation_seq_code, organization_code, company_name, bom_name, alternate_bom_designator) '

Line 758: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_BOM_COMP_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
755: END;
756:
757: BEGIN
758: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
759: application_short_name => 'MSC',
760: statement_type => AD_DDL.CREATE_INDEX,
761: statement =>
762: 'create index MSC_ST_COMP_SUB_N1_'||v_instance_code

Line 760: statement_type => AD_DDL.CREATE_INDEX,

756:
757: BEGIN
758: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
759: application_short_name => 'MSC',
760: statement_type => AD_DDL.CREATE_INDEX,
761: statement =>
762: 'create index MSC_ST_COMP_SUB_N1_'||v_instance_code
763: ||' on MSC_ST_COMPONENT_SUBSTITUTES '
764: ||'(sr_instance_code, assembly_name, component_name, sub_item_name, effectivity_date, operation_seq_code, organization_code,company_name, bom_name, alternate_bom_designator) '

Line 777: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

773: END;
774:
775: -- Added for Co Products (OSFM Integration) --
776: BEGIN
777: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
778: application_short_name => 'MSC',
779: statement_type => AD_DDL.CREATE_INDEX,
780: statement =>
781: 'create index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code

Line 779: statement_type => AD_DDL.CREATE_INDEX,

775: -- Added for Co Products (OSFM Integration) --
776: BEGIN
777: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
778: application_short_name => 'MSC',
779: statement_type => AD_DDL.CREATE_INDEX,
780: statement =>
781: 'create index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code
782: ||' on MSC_ST_CO_PRODUCTS '
783: ||'(co_product_name,component_name,sr_instance_code,company_name ) '

Line 804: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

800:
801: IF v_rtg_enabled = SYS_YES THEN
802:
803: BEGIN
804: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
805: application_short_name => 'MSC',
806: statement_type => AD_DDL.CREATE_INDEX,
807: statement =>
808: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code

Line 806: statement_type => AD_DDL.CREATE_INDEX,

802:
803: BEGIN
804: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
805: application_short_name => 'MSC',
806: statement_type => AD_DDL.CREATE_INDEX,
807: statement =>
808: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code
809: ||' on MSC_ST_ROUTINGS '
810: ||'(sr_instance_code, assembly_name, organization_code, company_name, routing_name, alternate_routing_designator) '

Line 822: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
819: END;
820:
821: BEGIN
822: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
823: application_short_name => 'MSC',
824: statement_type => AD_DDL.CREATE_INDEX,
825: statement =>
826: 'create index MSC_ST_ROUTING_OPER_N1_'||v_instance_code

Line 824: statement_type => AD_DDL.CREATE_INDEX,

820:
821: BEGIN
822: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
823: application_short_name => 'MSC',
824: statement_type => AD_DDL.CREATE_INDEX,
825: statement =>
826: 'create index MSC_ST_ROUTING_OPER_N1_'||v_instance_code
827: ||' on MSC_ST_ROUTING_OPERATIONS '
828: ||'( sr_instance_code, assembly_name, operation_seq_code, organization_code, company_name, routing_name, alternate_routing_designator) '

Line 841: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ROUTING_OPER_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
838: END;
839:
840: BEGIN
841: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
842: application_short_name => 'MSC',
843: statement_type => AD_DDL.CREATE_INDEX,
844: statement =>
845: 'create index MSC_ST_OPER_RES_N1_'||v_instance_code

Line 843: statement_type => AD_DDL.CREATE_INDEX,

839:
840: BEGIN
841: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
842: application_short_name => 'MSC',
843: statement_type => AD_DDL.CREATE_INDEX,
844: statement =>
845: 'create index MSC_ST_OPER_RES_N1_'||v_instance_code
846: ||' on MSC_ST_OPERATION_RESOURCES '
847: ||'(sr_instance_code, assembly_name, resource_code, organization_code, company_name, alternate_number, operation_seq_code, resource_seq_code, routing_name, alternate_routing_designator) '

Line 860: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

856: END;
857:
858: -- Added for Operation Networks (OSFM Integration )
859: BEGIN
860: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
861: application_short_name => 'MSC',
862: statement_type => AD_DDL.CREATE_INDEX,
863: statement =>
864: 'create index MSC_ST_OPER_NTWK_N1_'||v_instance_code

Line 862: statement_type => AD_DDL.CREATE_INDEX,

858: -- Added for Operation Networks (OSFM Integration )
859: BEGIN
860: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
861: application_short_name => 'MSC',
862: statement_type => AD_DDL.CREATE_INDEX,
863: statement =>
864: 'create index MSC_ST_OPER_NTWK_N1_'||v_instance_code
865: ||' on MSC_ST_OPERATION_NETWORKS '
866: ||'(assembly_name, organization_code,FROM_OPERATION_SEQ_CODE, TO_OPERATION_SEQ_CODE,sr_instance_code, company_name) '

Line 888: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

884:
885: IF v_item_cat_enabled = SYS_YES THEN
886:
887: BEGIN
888: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
889: application_short_name => 'MSC',
890: statement_type => AD_DDL.CREATE_INDEX,
891: statement =>
892: 'create index MSC_ST_ITEM_CAT_N1_'||v_instance_code

Line 890: statement_type => AD_DDL.CREATE_INDEX,

886:
887: BEGIN
888: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
889: application_short_name => 'MSC',
890: statement_type => AD_DDL.CREATE_INDEX,
891: statement =>
892: 'create index MSC_ST_ITEM_CAT_N1_'||v_instance_code
893: ||' on MSC_ST_ITEM_CATEGORIES '
894: ||'(sr_instance_code,item_name, category_name, category_set_name, organization_code, company_name) '

Line 906: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

902: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_CAT_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
903: END;
904:
905: BEGIN
906: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
907: application_short_name => 'MSC',
908: statement_type => AD_DDL.CREATE_INDEX,
909: statement =>
910: 'create index MSC_ST_ITEM_CAT_N2_'||v_instance_code

Line 908: statement_type => AD_DDL.CREATE_INDEX,

904:
905: BEGIN
906: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
907: application_short_name => 'MSC',
908: statement_type => AD_DDL.CREATE_INDEX,
909: statement =>
910: 'create index MSC_ST_ITEM_CAT_N2_'||v_instance_code
911: ||' on MSC_ST_ITEM_CATEGORIES '
912: ||'(sr_instance_code,batch_id) '

Line 930: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

926:
927: IF v_resources_enabled = SYS_YES THEN
928: BEGIN
929:
930: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
931: application_short_name => 'MSC',
932: statement_type => AD_DDL.CREATE_INDEX,
933: statement =>
934: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code

Line 932: statement_type => AD_DDL.CREATE_INDEX,

928: BEGIN
929:
930: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
931: application_short_name => 'MSC',
932: statement_type => AD_DDL.CREATE_INDEX,
933: statement =>
934: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code
935: ||' on MSC_ST_RESOURCE_GROUPS '
936: ||'(sr_instance_code, group_code, company_name) '

Line 948: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

944: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
945: END;
946:
947: BEGIN
948: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
949: application_short_name => 'MSC',
950: statement_type => AD_DDL.CREATE_INDEX,
951: statement =>
952: 'create index MSC_ST_DEPT_RES_N1_'||v_instance_code

Line 950: statement_type => AD_DDL.CREATE_INDEX,

946:
947: BEGIN
948: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
949: application_short_name => 'MSC',
950: statement_type => AD_DDL.CREATE_INDEX,
951: statement =>
952: 'create index MSC_ST_DEPT_RES_N1_'||v_instance_code
953: ||' on MSC_ST_DEPARTMENT_RESOURCES '
954: ||'(sr_instance_code, resource_code, department_code, organization_code, company_name) '

Line 966: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_DEPT_RES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
963: END;
964:
965: BEGIN
966: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
967: application_short_name => 'MSC',
968: statement_type => AD_DDL.CREATE_INDEX,
969: statement =>
970: 'create index MSC_ST_RES_SHIFTS_N1_'||v_instance_code

Line 968: statement_type => AD_DDL.CREATE_INDEX,

964:
965: BEGIN
966: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
967: application_short_name => 'MSC',
968: statement_type => AD_DDL.CREATE_INDEX,
969: statement =>
970: 'create index MSC_ST_RES_SHIFTS_N1_'||v_instance_code
971: ||' on MSC_ST_RESOURCE_SHIFTS '
972: ||'(sr_instance_code, resource_code, department_code, shift_name, organization_code, company_name) '

Line 984: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

980: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_RES_SHIFTS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
981: END;
982:
983: BEGIN
984: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
985: application_short_name => 'MSC',
986: statement_type => AD_DDL.CREATE_INDEX,
987: statement =>
988: 'create index MSC_ST_RES_CHANGES_N1_'||v_instance_code

Line 986: statement_type => AD_DDL.CREATE_INDEX,

982:
983: BEGIN
984: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
985: application_short_name => 'MSC',
986: statement_type => AD_DDL.CREATE_INDEX,
987: statement =>
988: 'create index MSC_ST_RES_CHANGES_N1_'||v_instance_code
989: ||' on MSC_ST_RESOURCE_CHANGES '
990: ||'(sr_instance_code, simulation_set, resource_code, department_code, from_date, shift_name, organization_code, company_name) '

Line 1011: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1007:
1008: IF v_project_enabled = SYS_YES THEN
1009:
1010: BEGIN
1011: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1012: application_short_name => 'MSC',
1013: statement_type => AD_DDL.CREATE_INDEX,
1014: statement =>
1015: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code

Line 1013: statement_type => AD_DDL.CREATE_INDEX,

1009:
1010: BEGIN
1011: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1012: application_short_name => 'MSC',
1013: statement_type => AD_DDL.CREATE_INDEX,
1014: statement =>
1015: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code
1016: ||' on MSC_ST_PROJECT_TASKS '
1017: ||'(sr_instance_code, project_number, task_number, organization_code, company_name) '

Line 1035: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1031:
1032: IF v_dmd_class_enabled = SYS_YES THEN
1033:
1034: BEGIN
1035: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1036: application_short_name => 'MSC',
1037: statement_type => AD_DDL.CREATE_INDEX,
1038: statement =>
1039: 'create index MSC_ST_DMD_CLASS_N1_'||v_instance_code

Line 1037: statement_type => AD_DDL.CREATE_INDEX,

1033:
1034: BEGIN
1035: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1036: application_short_name => 'MSC',
1037: statement_type => AD_DDL.CREATE_INDEX,
1038: statement =>
1039: 'create index MSC_ST_DMD_CLASS_N1_'||v_instance_code
1040: ||' on MSC_ST_DEMAND_CLASSES '
1041: ||'(sr_instance_code,demand_class,company_name) '

Line 1059: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1055:
1056: IF v_tp_enabled = SYS_YES THEN
1057:
1058: BEGIN
1059: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1060: application_short_name => 'MSC',
1061: statement_type => AD_DDL.CREATE_INDEX,
1062: statement =>
1063: 'create index MSC_ST_TRADING_PART_N1_'||v_instance_code

Line 1061: statement_type => AD_DDL.CREATE_INDEX,

1057:
1058: BEGIN
1059: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1060: application_short_name => 'MSC',
1061: statement_type => AD_DDL.CREATE_INDEX,
1062: statement =>
1063: 'create index MSC_ST_TRADING_PART_N1_'||v_instance_code
1064: ||' on MSC_ST_TRADING_PARTNERS '
1065: ||'(sr_instance_code, partner_name, partner_type, company_name) '

Line 1077: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1073: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_TRADING_PART_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1074: END;
1075:
1076: BEGIN
1077: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1078: application_short_name => 'MSC',
1079: statement_type => AD_DDL.CREATE_INDEX,
1080: statement =>
1081: 'create index MSC_ST_TRADING_PART_N2_'||v_instance_code

Line 1079: statement_type => AD_DDL.CREATE_INDEX,

1075:
1076: BEGIN
1077: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1078: application_short_name => 'MSC',
1079: statement_type => AD_DDL.CREATE_INDEX,
1080: statement =>
1081: 'create index MSC_ST_TRADING_PART_N2_'||v_instance_code
1082: ||' on MSC_ST_TRADING_PARTNERS '
1083: ||'(sr_instance_code, organization_code, partner_type, company_name) '

Line 1095: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1091: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_TRADING_PART_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1092: END;
1093:
1094: BEGIN
1095: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1096: application_short_name => 'MSC',
1097: statement_type => AD_DDL.CREATE_INDEX,
1098: statement =>
1099: 'create index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code

Line 1097: statement_type => AD_DDL.CREATE_INDEX,

1093:
1094: BEGIN
1095: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1096: application_short_name => 'MSC',
1097: statement_type => AD_DDL.CREATE_INDEX,
1098: statement =>
1099: 'create index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code
1100: ||' on MSC_ST_TRADING_PARTNER_SITES '
1101: ||'(sr_instance_code ,tp_site_code, partner_name, partner_type) '

Line 1113: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1110: END;
1111:
1112: BEGIN
1113: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1114: application_short_name => 'MSC',
1115: statement_type => AD_DDL.CREATE_INDEX,
1116: statement =>
1117: 'create index MSC_ST_SUB_INV_N1_'||v_instance_code

Line 1115: statement_type => AD_DDL.CREATE_INDEX,

1111:
1112: BEGIN
1113: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1114: application_short_name => 'MSC',
1115: statement_type => AD_DDL.CREATE_INDEX,
1116: statement =>
1117: 'create index MSC_ST_SUB_INV_N1_'||v_instance_code
1118: ||' on MSC_ST_SUB_INVENTORIES '
1119: ||'( sr_instance_code, sub_inventory_code, organization_code ) '

Line 1131: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1127: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUB_INV_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1128: END;
1129:
1130: BEGIN
1131: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1132: application_short_name => 'MSC',
1133: statement_type => AD_DDL.CREATE_INDEX,
1134: statement =>
1135: 'create index MSC_ST_LOC_ASC_N1_'||v_instance_code

Line 1133: statement_type => AD_DDL.CREATE_INDEX,

1129:
1130: BEGIN
1131: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1132: application_short_name => 'MSC',
1133: statement_type => AD_DDL.CREATE_INDEX,
1134: statement =>
1135: 'create index MSC_ST_LOC_ASC_N1_'||v_instance_code
1136: ||' on MSC_ST_LOCATION_ASSOCIATIONS '
1137: ||'(sr_instance_code, location_code, tp_site_code, partner_name, partner_type, company_name) '

Line 1149: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_LOC_ASC_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1146: END;
1147:
1148: BEGIN
1149: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1150: application_short_name => 'MSC',
1151: statement_type => AD_DDL.CREATE_INDEX,
1152: statement =>
1153: 'create index MSC_ST_PART_CONT_N1_'||v_instance_code

Line 1151: statement_type => AD_DDL.CREATE_INDEX,

1147:
1148: BEGIN
1149: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1150: application_short_name => 'MSC',
1151: statement_type => AD_DDL.CREATE_INDEX,
1152: statement =>
1153: 'create index MSC_ST_PART_CONT_N1_'||v_instance_code
1154: ||' on MSC_ST_PARTNER_CONTACTS '
1155: ||'(sr_instance_code,tp_site_code, partner_name, partner_type, company_name) '

Line 1169: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1165:
1166: --For Aeroexchange
1167: --Added for MSC_ST_GROUPS
1168: BEGIN
1169: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1170: application_short_name => 'MSC',
1171: statement_type => AD_DDL.CREATE_INDEX,
1172: statement =>
1173: 'create index MSC_ST_GROUPS_N1_'||v_instance_code

Line 1171: statement_type => AD_DDL.CREATE_INDEX,

1167: --Added for MSC_ST_GROUPS
1168: BEGIN
1169: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1170: application_short_name => 'MSC',
1171: statement_type => AD_DDL.CREATE_INDEX,
1172: statement =>
1173: 'create index MSC_ST_GROUPS_N1_'||v_instance_code
1174: ||' on MSC_ST_GROUPS '
1175: ||'(GROUP_NAME) '

Line 1189: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1186: END;
1187:
1188: BEGIN
1189: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1190: application_short_name => 'MSC',
1191: statement_type => AD_DDL.CREATE_INDEX,
1192: statement =>
1193: 'create index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code

Line 1191: statement_type => AD_DDL.CREATE_INDEX,

1187:
1188: BEGIN
1189: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1190: application_short_name => 'MSC',
1191: statement_type => AD_DDL.CREATE_INDEX,
1192: statement =>
1193: 'create index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code
1194: ||' on MSC_ST_GROUP_COMPANIES '
1195: ||'(group_name,company_name) '

Line 1220: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1216: IF v_item_cst_enabled = SYS_YES THEN
1217:
1218: BEGIN
1219:
1220: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1221: application_short_name => 'MSC',
1222: statement_type => AD_DDL.CREATE_INDEX,
1223: statement =>
1224: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code

Line 1222: statement_type => AD_DDL.CREATE_INDEX,

1218: BEGIN
1219:
1220: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1221: application_short_name => 'MSC',
1222: statement_type => AD_DDL.CREATE_INDEX,
1223: statement =>
1224: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code
1225: ||' on MSC_ST_ITEM_CUSTOMERS '
1226: ||'(ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '

Line 1239: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1235: END;
1236:
1237: BEGIN
1238:
1239: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1240: application_short_name => 'MSC',
1241: statement_type => AD_DDL.CREATE_INDEX,
1242: statement =>
1243: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code

Line 1241: statement_type => AD_DDL.CREATE_INDEX,

1237: BEGIN
1238:
1239: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1240: application_short_name => 'MSC',
1241: statement_type => AD_DDL.CREATE_INDEX,
1242: statement =>
1243: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code
1244: ||' on MSC_ST_ITEM_CUSTOMERS '
1245: ||'(CUSTOMER_ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '

Line 1263: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1259:
1260: IF v_ship_mthd_enabled = SYS_YES THEN
1261:
1262: BEGIN
1263: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1264: application_short_name => 'MSC',
1265: statement_type => AD_DDL.CREATE_INDEX,
1266: statement =>
1267: 'create index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code

Line 1265: statement_type => AD_DDL.CREATE_INDEX,

1261:
1262: BEGIN
1263: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1264: application_short_name => 'MSC',
1265: statement_type => AD_DDL.CREATE_INDEX,
1266: statement =>
1267: 'create index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code
1268: ||' on MSC_ST_INTERORG_SHIP_METHODS '
1269: ||'(sr_instance_code,from_organization_code,to_organization_code,ship_method,company_name) '

Line 1288: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1284: IF v_sourcing_enabled = SYS_YES THEN
1285:
1286: BEGIN
1287:
1288: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1289: application_short_name => 'MSC',
1290: statement_type => AD_DDL.CREATE_INDEX,
1291: statement =>
1292: 'create index MSC_ST_ITEM_SRC_N1_'||v_instance_code

Line 1290: statement_type => AD_DDL.CREATE_INDEX,

1286: BEGIN
1287:
1288: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1289: application_short_name => 'MSC',
1290: statement_type => AD_DDL.CREATE_INDEX,
1291: statement =>
1292: 'create index MSC_ST_ITEM_SRC_N1_'||v_instance_code
1293: ||' on MSC_ST_ITEM_SOURCING '
1294: ||'(sr_instance_code, sourcing_rule_name, assignment_set_name, organization_code, company_name, receipt_organization_code, source_organization_code) '

Line 1307: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1303: END;
1304:
1305: BEGIN
1306:
1307: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1308: application_short_name => 'MSC',
1309: statement_type => AD_DDL.CREATE_INDEX,
1310: statement =>
1311: 'create index MSC_ST_REGIONS_N1_'||v_instance_code

Line 1309: statement_type => AD_DDL.CREATE_INDEX,

1305: BEGIN
1306:
1307: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1308: application_short_name => 'MSC',
1309: statement_type => AD_DDL.CREATE_INDEX,
1310: statement =>
1311: 'create index MSC_ST_REGIONS_N1_'||v_instance_code
1312: ||' on MSC_ST_REGIONS '
1313: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, zone ) '

Line 1326: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1322: END;
1323:
1324: BEGIN
1325:
1326: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1327: application_short_name => 'MSC',
1328: statement_type => AD_DDL.CREATE_INDEX,
1329: statement =>
1330: 'create index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code

Line 1328: statement_type => AD_DDL.CREATE_INDEX,

1324: BEGIN
1325:
1326: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1327: application_short_name => 'MSC',
1328: statement_type => AD_DDL.CREATE_INDEX,
1329: statement =>
1330: 'create index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code
1331: ||' on MSC_ST_ZONE_REGIONS '
1332: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, zone ) '

Line 1344: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1340: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1341: END;
1342:
1343: BEGIN
1344: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1345: application_short_name => 'MSC',
1346: statement_type => AD_DDL.CREATE_INDEX,
1347: statement =>
1348: 'create index MSC_ST_REGION_LOC_N1_'||v_instance_code

Line 1346: statement_type => AD_DDL.CREATE_INDEX,

1342:
1343: BEGIN
1344: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1345: application_short_name => 'MSC',
1346: statement_type => AD_DDL.CREATE_INDEX,
1347: statement =>
1348: 'create index MSC_ST_REGION_LOC_N1_'||v_instance_code
1349: ||' on MSC_ST_REGION_LOCATIONS '
1350: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, location_code ) '

Line 1362: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1358: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_REGION_LOC_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1359: END;
1360:
1361: BEGIN
1362: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1363: application_short_name => 'MSC',
1364: statement_type => AD_DDL.CREATE_INDEX,
1365: statement =>
1366: 'create index MSC_ST_REGION_SITE_N1_'||v_instance_code

Line 1364: statement_type => AD_DDL.CREATE_INDEX,

1360:
1361: BEGIN
1362: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1363: application_short_name => 'MSC',
1364: statement_type => AD_DDL.CREATE_INDEX,
1365: statement =>
1366: 'create index MSC_ST_REGION_SITE_N1_'||v_instance_code
1367: ||' on MSC_ST_REGION_SITES '
1368: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, vendor_name, vendor_site_code ) '

Line 1391: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1387: IF v_res_dmd_enabled = SYS_YES THEN
1388:
1389: BEGIN
1390:
1391: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1392: application_short_name => 'MSC',
1393: statement_type => AD_DDL.CREATE_INDEX,
1394: statement =>
1395: 'create index MSC_ST_RES_REQ_N1_'||v_instance_code

Line 1393: statement_type => AD_DDL.CREATE_INDEX,

1389: BEGIN
1390:
1391: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1392: application_short_name => 'MSC',
1393: statement_type => AD_DDL.CREATE_INDEX,
1394: statement =>
1395: 'create index MSC_ST_RES_REQ_N1_'||v_instance_code
1396: ||' on MSC_ST_RESOURCE_REQUIREMENTS '
1397: ||'(sr_instance_code, resource_code, wip_entity_name, operation_seq_code, organization_code, company_name, resource_seq_code) '

Line 1416: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1412: IF v_uom_class_enabled = SYS_YES THEN
1413:
1414: BEGIN
1415:
1416: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1417: application_short_name => 'MSC',
1418: statement_type => AD_DDL.CREATE_INDEX,
1419: statement =>
1420: 'create index MSC_ST_UOM_CLS_CONV_N1_'||v_instance_code

Line 1418: statement_type => AD_DDL.CREATE_INDEX,

1414: BEGIN
1415:
1416: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1417: application_short_name => 'MSC',
1418: statement_type => AD_DDL.CREATE_INDEX,
1419: statement =>
1420: 'create index MSC_ST_UOM_CLS_CONV_N1_'||v_instance_code
1421: ||' on MSC_ST_UOM_CLASS_CONVERSIONS '
1422: ||'( from_uom_code, to_uom_code, item_name, company_name) '

Line 1440: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1436:
1437: IF v_sup_cap_enabled = SYS_YES THEN
1438:
1439: BEGIN
1440: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1441: application_short_name => 'MSC',
1442: statement_type => AD_DDL.CREATE_INDEX,
1443: statement =>
1444: 'create index MSC_ST_ITEM_SUP_N1_'||v_instance_code

Line 1442: statement_type => AD_DDL.CREATE_INDEX,

1438:
1439: BEGIN
1440: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1441: application_short_name => 'MSC',
1442: statement_type => AD_DDL.CREATE_INDEX,
1443: statement =>
1444: 'create index MSC_ST_ITEM_SUP_N1_'||v_instance_code
1445: ||' on MSC_ST_ITEM_SUPPLIERS '
1446: ||'(sr_instance_code, item_name, vendor_name, organization_code, company_name, vendor_site_code) '

Line 1459: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1455: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_SUP_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1456: END;
1457:
1458: BEGIN
1459: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1460: application_short_name => 'MSC',
1461: statement_type => AD_DDL.CREATE_INDEX,
1462: statement =>
1463: 'create index MSC_ST_SUP_CAP_N1_'||v_instance_code

Line 1461: statement_type => AD_DDL.CREATE_INDEX,

1457:
1458: BEGIN
1459: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1460: application_short_name => 'MSC',
1461: statement_type => AD_DDL.CREATE_INDEX,
1462: statement =>
1463: 'create index MSC_ST_SUP_CAP_N1_'||v_instance_code
1464: ||' on MSC_ST_SUPPLIER_CAPACITIES '
1465: ||'(sr_instance_code, item_name, vendor_name, from_date,organization_code,company_name,vendor_site_code) '

Line 1477: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1473: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUP_CAP_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1474: END;
1475:
1476: BEGIN
1477: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1478: application_short_name => 'MSC',
1479: statement_type => AD_DDL.CREATE_INDEX,
1480: statement =>
1481: 'create index MSC_ST_SUP_FENCES_N1_'||v_instance_code

Line 1479: statement_type => AD_DDL.CREATE_INDEX,

1475:
1476: BEGIN
1477: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1478: application_short_name => 'MSC',
1479: statement_type => AD_DDL.CREATE_INDEX,
1480: statement =>
1481: 'create index MSC_ST_SUP_FENCES_N1_'||v_instance_code
1482: ||' on MSC_ST_SUPPLIER_FLEX_FENCES '
1483: ||'(sr_instance_code, item_name,vendor_name,fence_days,organization_code,company_name,vendor_site_code) '

Line 1504: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1500: IF v_safety_stk_enabled = SYS_YES THEN
1501:
1502: BEGIN
1503:
1504: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1505: application_short_name => 'MSC',
1506: statement_type => AD_DDL.CREATE_INDEX,
1507: statement =>
1508: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code

Line 1506: statement_type => AD_DDL.CREATE_INDEX,

1502: BEGIN
1503:
1504: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1505: application_short_name => 'MSC',
1506: statement_type => AD_DDL.CREATE_INDEX,
1507: statement =>
1508: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code
1509: ||' on MSC_ST_SAFETY_STOCKS '
1510: ||'(sr_instance_code,organization_code,item_name,period_start_date,company_name) '

Line 1526: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1522: IF v_item_substitute_enabled = SYS_YES THEN
1523:
1524: BEGIN
1525:
1526: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1527: application_short_name => 'MSC',
1528: statement_type => AD_DDL.CREATE_INDEX,
1529: statement =>
1530: 'create index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code

Line 1528: statement_type => AD_DDL.CREATE_INDEX,

1524: BEGIN
1525:
1526: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1527: application_short_name => 'MSC',
1528: statement_type => AD_DDL.CREATE_INDEX,
1529: statement =>
1530: 'create index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code
1531: ||' on MSC_ST_ITEM_SUBSTITUTES '
1532: ||' (sr_instance_code,item_name,substitute_item_name,customer_name,'

Line 1553: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1549: IF v_planners_enabled = SYS_YES THEN
1550:
1551: BEGIN
1552:
1553: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1554: application_short_name => 'MSC',
1555: statement_type => AD_DDL.CREATE_INDEX,
1556: statement =>
1557: 'create index MSC_ST_PLANNERS_N1_'||v_instance_code

Line 1555: statement_type => AD_DDL.CREATE_INDEX,

1551: BEGIN
1552:
1553: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1554: application_short_name => 'MSC',
1555: statement_type => AD_DDL.CREATE_INDEX,
1556: statement =>
1557: 'create index MSC_ST_PLANNERS_N1_'||v_instance_code
1558: ||' on MSC_ST_PLANNERS '
1559: ||'(sr_instance_code,organization_code,planner_code,company_name) '

Line 1577: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1573:
1574: IF v_mat_sup_enabled = SYS_YES THEN
1575:
1576: BEGIN
1577: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1578: application_short_name => 'MSC',
1579: statement_type => AD_DDL.CREATE_INDEX,
1580: statement =>
1581: 'create index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code

Line 1579: statement_type => AD_DDL.CREATE_INDEX,

1575:
1576: BEGIN
1577: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1578: application_short_name => 'MSC',
1579: statement_type => AD_DDL.CREATE_INDEX,
1580: statement =>
1581: 'create index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code
1582: ||' on MSC_ST_JOB_OPERATION_NETWORKS '
1583: ||'(SR_INSTANCE_CODE, WIP_ENTITY_NAME, FROM_OPERATION_SEQ_CODE, TO_OPERATION_SEQ_CODE) '

Line 1594: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));
1591: END;
1592:
1593: BEGIN
1594: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1595: application_short_name => 'MSC',
1596: statement_type => AD_DDL.CREATE_INDEX,
1597: statement =>
1598: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code

Line 1596: statement_type => AD_DDL.CREATE_INDEX,

1592:
1593: BEGIN
1594: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1595: application_short_name => 'MSC',
1596: statement_type => AD_DDL.CREATE_INDEX,
1597: statement =>
1598: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code
1599: ||' on MSC_ST_JOB_OPERATIONS '
1600: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE ) '

Line 1611: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));
1608: END;
1609:
1610: BEGIN
1611: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1612: application_short_name => 'MSC',
1613: statement_type => AD_DDL.CREATE_INDEX,
1614: statement =>
1615: 'create index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code

Line 1613: statement_type => AD_DDL.CREATE_INDEX,

1609:
1610: BEGIN
1611: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1612: application_short_name => 'MSC',
1613: statement_type => AD_DDL.CREATE_INDEX,
1614: statement =>
1615: 'create index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code
1616: ||' on MSC_ST_JOB_REQUIREMENT_OPS '
1617: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, COMPONENT_NAME, PRIMARY_COMPONENT_NAME ) '

Line 1628: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1624: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));
1625: END;
1626:
1627: BEGIN
1628: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1629: application_short_name => 'MSC',
1630: statement_type => AD_DDL.CREATE_INDEX,
1631: statement =>
1632: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code

Line 1630: statement_type => AD_DDL.CREATE_INDEX,

1626:
1627: BEGIN
1628: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1629: application_short_name => 'MSC',
1630: statement_type => AD_DDL.CREATE_INDEX,
1631: statement =>
1632: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code
1633: ||' on MSC_ST_JOB_OP_RESOURCES '
1634: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE, ALTERNATE_NUM, RESOURCE_CODE ) '

Line 1650: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1646: IF v_cal_assignment_enabled = SYS_YES THEN
1647:
1648: BEGIN
1649:
1650: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1651: application_short_name => 'MSC',
1652: statement_type => AD_DDL.CREATE_INDEX,
1653: statement =>
1654: 'create index MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code

Line 1652: statement_type => AD_DDL.CREATE_INDEX,

1648: BEGIN
1649:
1650: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1651: application_short_name => 'MSC',
1652: statement_type => AD_DDL.CREATE_INDEX,
1653: statement =>
1654: 'create index MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code
1655: ||' on MSC_ST_CALENDAR_ASSIGNMENTS '
1656: ||'(sr_instance_code,association_type, calendar_code, calendar_type, partner_name, partner_site_code, organization_code, ship_method_code) '

Line 1676: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1672: ELSIF p_batch_index = 'ITEM' THEN
1673:
1674: BEGIN
1675:
1676: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1677: application_short_name => 'MSC',
1678: statement_type => AD_DDL.CREATE_INDEX,
1679: statement =>
1680: 'create index MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code

Line 1678: statement_type => AD_DDL.CREATE_INDEX,

1674: BEGIN
1675:
1676: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1677: application_short_name => 'MSC',
1678: statement_type => AD_DDL.CREATE_INDEX,
1679: statement =>
1680: 'create index MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code
1681: ||' on MSC_ST_SYSTEM_ITEMS '
1682: ||' (sr_instance_code,batch_id,sr_inventory_item_id, deleted_flag) '

Line 1700: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1696: ELSIF p_batch_index = 'SUPPLY' THEN
1697:
1698: BEGIN
1699:
1700: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1701: application_short_name => 'MSC',
1702: statement_type => AD_DDL.CREATE_INDEX,
1703: statement =>
1704: 'create index MSC_ST_SUPPLIES_N5_'||v_instance_code

Line 1702: statement_type => AD_DDL.CREATE_INDEX,

1698: BEGIN
1699:
1700: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1701: application_short_name => 'MSC',
1702: statement_type => AD_DDL.CREATE_INDEX,
1703: statement =>
1704: 'create index MSC_ST_SUPPLIES_N5_'||v_instance_code
1705: ||' on MSC_ST_SUPPLIES '
1706: ||' (batch_id, order_type, sr_instance_code, deleted_flag) '

Line 1723: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1719: ELSIF p_batch_index = 'DEMAND' THEN
1720:
1721: BEGIN
1722:
1723: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1724: application_short_name => 'MSC',
1725: statement_type => AD_DDL.CREATE_INDEX,
1726: statement =>
1727: 'create index MSC_ST_DEMANDS_N3_'||v_instance_code

Line 1725: statement_type => AD_DDL.CREATE_INDEX,

1721: BEGIN
1722:
1723: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1724: application_short_name => 'MSC',
1725: statement_type => AD_DDL.CREATE_INDEX,
1726: statement =>
1727: 'create index MSC_ST_DEMANDS_N3_'||v_instance_code
1728: ||' on MSC_ST_DEMANDS '
1729: ||' (batch_id, origination_type, sr_instance_code, deleted_flag) '

Line 1745: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1741:
1742: ELSIF p_batch_index = 'SO' THEN
1743:
1744: BEGIN
1745: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1746: application_short_name => 'MSC',
1747: statement_type => AD_DDL.CREATE_INDEX,
1748: statement =>
1749: 'create index MSC_ST_SO_N2_'||v_instance_code

Line 1747: statement_type => AD_DDL.CREATE_INDEX,

1743:
1744: BEGIN
1745: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1746: application_short_name => 'MSC',
1747: statement_type => AD_DDL.CREATE_INDEX,
1748: statement =>
1749: 'create index MSC_ST_SO_N2_'||v_instance_code
1750: ||' on MSC_ST_SALES_ORDERS '
1751: ||' (sales_order_number, batch_id ,sr_instance_code, deleted_flag) '

Line 1763: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1759: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SO_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1760: END;
1761:
1762: BEGIN
1763: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1764: application_short_name => 'MSC',
1765: statement_type => AD_DDL.CREATE_INDEX,
1766: statement =>
1767: 'create index MSC_ST_SO_N3_'||v_instance_code

Line 1765: statement_type => AD_DDL.CREATE_INDEX,

1761:
1762: BEGIN
1763: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1764: application_short_name => 'MSC',
1765: statement_type => AD_DDL.CREATE_INDEX,
1766: statement =>
1767: 'create index MSC_ST_SO_N3_'||v_instance_code
1768: ||' on MSC_ST_SALES_ORDERS '
1769: ||' (sr_instance_code, batch_id , deleted_flag) '

Line 1796: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1792:
1793: IF v_item_enabled = SYS_YES THEN
1794:
1795: BEGIN
1796: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1797: application_short_name => 'MSC',
1798: statement_type => AD_DDL.DROP_INDEX,
1799: statement =>
1800: 'drop index MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code,

Line 1798: statement_type => AD_DDL.DROP_INDEX,

1794:
1795: BEGIN
1796: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1797: application_short_name => 'MSC',
1798: statement_type => AD_DDL.DROP_INDEX,
1799: statement =>
1800: 'drop index MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code,
1801: object_name => 'MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code);
1802:

Line 1811: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1807: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1808: END;
1809:
1810: BEGIN
1811: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1812: application_short_name => 'MSC',
1813: statement_type => AD_DDL.DROP_INDEX,
1814: statement =>
1815: 'drop index MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code,

Line 1813: statement_type => AD_DDL.DROP_INDEX,

1809:
1810: BEGIN
1811: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1812: application_short_name => 'MSC',
1813: statement_type => AD_DDL.DROP_INDEX,
1814: statement =>
1815: 'drop index MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code,
1816: object_name => 'MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code);
1817:

Line 1832: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1828:
1829: IF v_mat_sup_enabled = SYS_YES THEN
1830:
1831: BEGIN
1832: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1833: application_short_name => 'MSC',
1834: statement_type => AD_DDL.DROP_INDEX,
1835: statement =>
1836: 'drop index MSC_ST_SUPPLIES_N1_'||v_instance_code,

Line 1834: statement_type => AD_DDL.DROP_INDEX,

1830:
1831: BEGIN
1832: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1833: application_short_name => 'MSC',
1834: statement_type => AD_DDL.DROP_INDEX,
1835: statement =>
1836: 'drop index MSC_ST_SUPPLIES_N1_'||v_instance_code,
1837: object_name => 'MSC_ST_SUPPLIES_N1_'||v_instance_code);
1838:

Line 1847: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1844: END;
1845:
1846: BEGIN
1847: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1848: application_short_name => 'MSC',
1849: statement_type => AD_DDL.DROP_INDEX,
1850: statement =>
1851: 'drop index MSC_ST_SUPPLIES_N2_'||v_instance_code,

Line 1849: statement_type => AD_DDL.DROP_INDEX,

1845:
1846: BEGIN
1847: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1848: application_short_name => 'MSC',
1849: statement_type => AD_DDL.DROP_INDEX,
1850: statement =>
1851: 'drop index MSC_ST_SUPPLIES_N2_'||v_instance_code,
1852: object_name => 'MSC_ST_SUPPLIES_N2_'||v_instance_code);
1853:

Line 1861: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1857: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1858: END;
1859:
1860: BEGIN
1861: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1862: application_short_name => 'MSC',
1863: statement_type => AD_DDL.DROP_INDEX,
1864: statement =>
1865: 'drop index MSC_ST_SUPPLIES_N3_'||v_instance_code,

Line 1863: statement_type => AD_DDL.DROP_INDEX,

1859:
1860: BEGIN
1861: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1862: application_short_name => 'MSC',
1863: statement_type => AD_DDL.DROP_INDEX,
1864: statement =>
1865: 'drop index MSC_ST_SUPPLIES_N3_'||v_instance_code,
1866: object_name => 'MSC_ST_SUPPLIES_N3_'||v_instance_code);
1867:

Line 1875: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1871: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1872: END;
1873:
1874: BEGIN
1875: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1876: application_short_name => 'MSC',
1877: statement_type => AD_DDL.DROP_INDEX,
1878: statement =>
1879: 'drop index MSC_ST_SUPPLIES_N4_'||v_instance_code,

Line 1877: statement_type => AD_DDL.DROP_INDEX,

1873:
1874: BEGIN
1875: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1876: application_short_name => 'MSC',
1877: statement_type => AD_DDL.DROP_INDEX,
1878: statement =>
1879: 'drop index MSC_ST_SUPPLIES_N4_'||v_instance_code,
1880: object_name => 'MSC_ST_SUPPLIES_N4_'||v_instance_code);
1881:

Line 1889: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N4_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1886: END;
1887:
1888: BEGIN
1889: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1890: application_short_name => 'MSC',
1891: statement_type => AD_DDL.DROP_INDEX,
1892: statement =>
1893: 'drop index MSC_ST_SUPPLIES_N5_'||v_instance_code,

Line 1891: statement_type => AD_DDL.DROP_INDEX,

1887:
1888: BEGIN
1889: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1890: application_short_name => 'MSC',
1891: statement_type => AD_DDL.DROP_INDEX,
1892: statement =>
1893: 'drop index MSC_ST_SUPPLIES_N5_'||v_instance_code,
1894: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);
1895:

Line 1910: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1906:
1907: IF v_mat_dmd_enabled = SYS_YES THEN
1908:
1909: BEGIN
1910: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1911: application_short_name => 'MSC',
1912: statement_type => AD_DDL.DROP_INDEX,
1913: statement =>
1914: 'drop index MSC_ST_DEMANDS_N1_'||v_instance_code,

Line 1912: statement_type => AD_DDL.DROP_INDEX,

1908:
1909: BEGIN
1910: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1911: application_short_name => 'MSC',
1912: statement_type => AD_DDL.DROP_INDEX,
1913: statement =>
1914: 'drop index MSC_ST_DEMANDS_N1_'||v_instance_code,
1915: object_name => 'MSC_ST_DEMANDS_N1_'||v_instance_code);
1916:

Line 1924: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1920: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_DEMANDS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1921: END;
1922:
1923: BEGIN
1924: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1925: application_short_name => 'MSC',
1926: statement_type => AD_DDL.DROP_INDEX,
1927: statement =>
1928: 'drop index MSC_ST_DEMANDS_N2_'||v_instance_code,

Line 1926: statement_type => AD_DDL.DROP_INDEX,

1922:
1923: BEGIN
1924: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1925: application_short_name => 'MSC',
1926: statement_type => AD_DDL.DROP_INDEX,
1927: statement =>
1928: 'drop index MSC_ST_DEMANDS_N2_'||v_instance_code,
1929: object_name => 'MSC_ST_DEMANDS_N2_'||v_instance_code);
1930:

Line 1938: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1934: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_DEMANDS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1935: END;
1936:
1937: BEGIN
1938: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1939: application_short_name => 'MSC',
1940: statement_type => AD_DDL.DROP_INDEX,
1941: statement =>
1942: 'drop index MSC_ST_DEMANDS_N3_'||v_instance_code,

Line 1940: statement_type => AD_DDL.DROP_INDEX,

1936:
1937: BEGIN
1938: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1939: application_short_name => 'MSC',
1940: statement_type => AD_DDL.DROP_INDEX,
1941: statement =>
1942: 'drop index MSC_ST_DEMANDS_N3_'||v_instance_code,
1943: object_name => 'MSC_ST_DEMANDS_N3_'||v_instance_code);
1944:

Line 1953: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1949: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_DEMANDS_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1950: END;
1951:
1952: BEGIN
1953: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1954: application_short_name => 'MSC',
1955: statement_type => AD_DDL.DROP_INDEX,
1956: statement =>
1957: 'drop index MSC_ST_SO_N1_'||v_instance_code,

Line 1955: statement_type => AD_DDL.DROP_INDEX,

1951:
1952: BEGIN
1953: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1954: application_short_name => 'MSC',
1955: statement_type => AD_DDL.DROP_INDEX,
1956: statement =>
1957: 'drop index MSC_ST_SO_N1_'||v_instance_code,
1958: object_name => 'MSC_ST_SO_N1_'||v_instance_code);
1959:

Line 1967: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1963: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SO_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1964: END;
1965:
1966: BEGIN
1967: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1968: application_short_name => 'MSC',
1969: statement_type => AD_DDL.DROP_INDEX,
1970: statement =>
1971: 'drop index MSC_ST_SO_N2_'||v_instance_code,

Line 1969: statement_type => AD_DDL.DROP_INDEX,

1965:
1966: BEGIN
1967: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1968: application_short_name => 'MSC',
1969: statement_type => AD_DDL.DROP_INDEX,
1970: statement =>
1971: 'drop index MSC_ST_SO_N2_'||v_instance_code,
1972: object_name => 'MSC_ST_SO_N2_'||v_instance_code);
1973:

Line 1981: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1977: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SO_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1978: END;
1979:
1980: BEGIN
1981: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1982: application_short_name => 'MSC',
1983: statement_type => AD_DDL.DROP_INDEX,
1984: statement =>
1985: 'drop index MSC_ST_SO_N3_'||v_instance_code,

Line 1983: statement_type => AD_DDL.DROP_INDEX,

1979:
1980: BEGIN
1981: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1982: application_short_name => 'MSC',
1983: statement_type => AD_DDL.DROP_INDEX,
1984: statement =>
1985: 'drop index MSC_ST_SO_N3_'||v_instance_code,
1986: object_name => 'MSC_ST_SO_N3_'||v_instance_code);
1987:

Line 2001: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1997: END IF;
1998:
1999: IF v_reserve_enabled = SYS_YES THEN
2000: BEGIN
2001: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2002: application_short_name => 'MSC',
2003: statement_type => AD_DDL.DROP_INDEX,
2004: statement =>
2005: 'drop index MSC_ST_RESERVE_N1_'||v_instance_code,

Line 2003: statement_type => AD_DDL.DROP_INDEX,

1999: IF v_reserve_enabled = SYS_YES THEN
2000: BEGIN
2001: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2002: application_short_name => 'MSC',
2003: statement_type => AD_DDL.DROP_INDEX,
2004: statement =>
2005: 'drop index MSC_ST_RESERVE_N1_'||v_instance_code,
2006: object_name => 'MSC_ST_RESERVE_N1_'||v_instance_code);
2007:

Line 2018: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2014:
2015: IF v_bom_enabled = SYS_YES THEN
2016:
2017: BEGIN
2018: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2019: application_short_name => 'MSC',
2020: statement_type => AD_DDL.DROP_INDEX,
2021: statement =>
2022: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,

Line 2020: statement_type => AD_DDL.DROP_INDEX,

2016:
2017: BEGIN
2018: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2019: application_short_name => 'MSC',
2020: statement_type => AD_DDL.DROP_INDEX,
2021: statement =>
2022: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,
2023: object_name => 'MSC_ST_BOMS_N1_'||v_instance_code);
2024:

Line 2032: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2029: END;
2030:
2031: BEGIN
2032: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2033: application_short_name => 'MSC',
2034: statement_type => AD_DDL.DROP_INDEX,
2035: statement =>
2036: 'drop index MSC_ST_BOM_COMP_N1_'||v_instance_code,

Line 2034: statement_type => AD_DDL.DROP_INDEX,

2030:
2031: BEGIN
2032: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2033: application_short_name => 'MSC',
2034: statement_type => AD_DDL.DROP_INDEX,
2035: statement =>
2036: 'drop index MSC_ST_BOM_COMP_N1_'||v_instance_code,
2037: object_name => 'MSC_ST_BOM_COMP_N1_'||v_instance_code);
2038:

Line 2046: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2042: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_BOM_COMP_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2043: END;
2044:
2045: BEGIN
2046: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2047: application_short_name => 'MSC',
2048: statement_type => AD_DDL.DROP_INDEX,
2049: statement =>
2050: 'drop index MSC_ST_COMP_SUB_N1_'||v_instance_code,

Line 2048: statement_type => AD_DDL.DROP_INDEX,

2044:
2045: BEGIN
2046: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2047: application_short_name => 'MSC',
2048: statement_type => AD_DDL.DROP_INDEX,
2049: statement =>
2050: 'drop index MSC_ST_COMP_SUB_N1_'||v_instance_code,
2051: object_name => 'MSC_ST_COMP_SUB_N1_'||v_instance_code);
2052:

Line 2062: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2058: END;
2059:
2060: -- Added for Co Products (OSFM Integration --
2061: BEGIN
2062: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2063: application_short_name => 'MSC',
2064: statement_type => AD_DDL.DROP_INDEX,
2065: statement =>
2066: 'drop index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code,

Line 2064: statement_type => AD_DDL.DROP_INDEX,

2060: -- Added for Co Products (OSFM Integration --
2061: BEGIN
2062: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2063: application_short_name => 'MSC',
2064: statement_type => AD_DDL.DROP_INDEX,
2065: statement =>
2066: 'drop index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code,
2067: object_name => 'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
2068:

Line 2080: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2076:
2077: IF v_rtg_enabled = SYS_YES THEN
2078:
2079: BEGIN
2080: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2081: application_short_name => 'MSC',
2082: statement_type => AD_DDL.DROP_INDEX,
2083: statement =>
2084: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,

Line 2082: statement_type => AD_DDL.DROP_INDEX,

2078:
2079: BEGIN
2080: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2081: application_short_name => 'MSC',
2082: statement_type => AD_DDL.DROP_INDEX,
2083: statement =>
2084: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,
2085: object_name => 'MSC_ST_ROUTINGS_N1_'||v_instance_code);
2086:

Line 2094: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2090: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2091: END;
2092:
2093: BEGIN
2094: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2095: application_short_name => 'MSC',
2096: statement_type => AD_DDL.DROP_INDEX,
2097: statement =>
2098: 'drop index MSC_ST_ROUTING_OPER_N1_'||v_instance_code,

Line 2096: statement_type => AD_DDL.DROP_INDEX,

2092:
2093: BEGIN
2094: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2095: application_short_name => 'MSC',
2096: statement_type => AD_DDL.DROP_INDEX,
2097: statement =>
2098: 'drop index MSC_ST_ROUTING_OPER_N1_'||v_instance_code,
2099: object_name => 'MSC_ST_ROUTING_OPER_N1_'||v_instance_code);
2100:

Line 2109: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2105: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ROUTING_OPER_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2106: END;
2107:
2108: BEGIN
2109: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2110: application_short_name => 'MSC',
2111: statement_type => AD_DDL.DROP_INDEX,
2112: statement =>
2113: 'drop index MSC_ST_OPER_RES_N1_'||v_instance_code,

Line 2111: statement_type => AD_DDL.DROP_INDEX,

2107:
2108: BEGIN
2109: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2110: application_short_name => 'MSC',
2111: statement_type => AD_DDL.DROP_INDEX,
2112: statement =>
2113: 'drop index MSC_ST_OPER_RES_N1_'||v_instance_code,
2114: object_name => 'MSC_ST_OPER_RES_N1_'||v_instance_code);
2115:

Line 2125: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2121: END;
2122:
2123: -- Added for Operation Networks (OSFM Integration)--
2124: BEGIN
2125: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2126: application_short_name => 'MSC',
2127: statement_type => AD_DDL.DROP_INDEX,
2128: statement =>
2129: 'drop index MSC_ST_OPER_NTWK_N1_'||v_instance_code,

Line 2127: statement_type => AD_DDL.DROP_INDEX,

2123: -- Added for Operation Networks (OSFM Integration)--
2124: BEGIN
2125: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2126: application_short_name => 'MSC',
2127: statement_type => AD_DDL.DROP_INDEX,
2128: statement =>
2129: 'drop index MSC_ST_OPER_NTWK_N1_'||v_instance_code,
2130: object_name => 'MSC_ST_OPER_NTWK_N1_'||v_instance_code);
2131:

Line 2145: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2141:
2142: IF v_item_cat_enabled = SYS_YES THEN
2143:
2144: BEGIN
2145: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2146: application_short_name => 'MSC',
2147: statement_type => AD_DDL.DROP_INDEX,
2148: statement =>
2149: 'drop index MSC_ST_ITEM_CAT_N1_'||v_instance_code,

Line 2147: statement_type => AD_DDL.DROP_INDEX,

2143:
2144: BEGIN
2145: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2146: application_short_name => 'MSC',
2147: statement_type => AD_DDL.DROP_INDEX,
2148: statement =>
2149: 'drop index MSC_ST_ITEM_CAT_N1_'||v_instance_code,
2150: object_name => 'MSC_ST_ITEM_CAT_N1_'||v_instance_code);
2151:

Line 2160: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_CAT_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2157: END;
2158:
2159: BEGIN
2160: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2161: application_short_name => 'MSC',
2162: statement_type => AD_DDL.DROP_INDEX,
2163: statement =>
2164: 'drop index MSC_ST_ITEM_CAT_N2_'||v_instance_code,

Line 2162: statement_type => AD_DDL.DROP_INDEX,

2158:
2159: BEGIN
2160: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2161: application_short_name => 'MSC',
2162: statement_type => AD_DDL.DROP_INDEX,
2163: statement =>
2164: 'drop index MSC_ST_ITEM_CAT_N2_'||v_instance_code,
2165: object_name => 'MSC_ST_ITEM_CAT_N2_'||v_instance_code);
2166:

Line 2179: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2175:
2176: IF v_resources_enabled = SYS_YES THEN
2177:
2178: BEGIN
2179: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2180: application_short_name => 'MSC',
2181: statement_type => AD_DDL.DROP_INDEX,
2182: statement =>
2183: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,

Line 2181: statement_type => AD_DDL.DROP_INDEX,

2177:
2178: BEGIN
2179: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2180: application_short_name => 'MSC',
2181: statement_type => AD_DDL.DROP_INDEX,
2182: statement =>
2183: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,
2184: object_name => 'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2185:

Line 2194: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2190: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2191: END;
2192:
2193: BEGIN
2194: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2195: application_short_name => 'MSC',
2196: statement_type => AD_DDL.DROP_INDEX,
2197: statement =>
2198: 'drop index MSC_ST_DEPT_RES_N1_'||v_instance_code,

Line 2196: statement_type => AD_DDL.DROP_INDEX,

2192:
2193: BEGIN
2194: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2195: application_short_name => 'MSC',
2196: statement_type => AD_DDL.DROP_INDEX,
2197: statement =>
2198: 'drop index MSC_ST_DEPT_RES_N1_'||v_instance_code,
2199: object_name => 'MSC_ST_DEPT_RES_N1_'||v_instance_code);
2200:

Line 2209: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_DEPT_RES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2206: END;
2207:
2208: BEGIN
2209: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2210: application_short_name => 'MSC',
2211: statement_type => AD_DDL.DROP_INDEX,
2212: statement =>
2213: 'drop index MSC_ST_RES_SHIFTS_N1_'||v_instance_code,

Line 2211: statement_type => AD_DDL.DROP_INDEX,

2207:
2208: BEGIN
2209: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2210: application_short_name => 'MSC',
2211: statement_type => AD_DDL.DROP_INDEX,
2212: statement =>
2213: 'drop index MSC_ST_RES_SHIFTS_N1_'||v_instance_code,
2214: object_name => 'MSC_ST_RES_SHIFTS_N1_'||v_instance_code);
2215:

Line 2224: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_RES_SHIFTS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2221: END;
2222:
2223: BEGIN
2224: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2225: application_short_name => 'MSC',
2226: statement_type => AD_DDL.DROP_INDEX,
2227: statement =>
2228: 'drop index MSC_ST_RES_CHANGES_N1_'||v_instance_code,

Line 2226: statement_type => AD_DDL.DROP_INDEX,

2222:
2223: BEGIN
2224: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2225: application_short_name => 'MSC',
2226: statement_type => AD_DDL.DROP_INDEX,
2227: statement =>
2228: 'drop index MSC_ST_RES_CHANGES_N1_'||v_instance_code,
2229: object_name => 'MSC_ST_RES_CHANGES_N1_'||v_instance_code);
2230:

Line 2246: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2242: IF v_project_enabled = SYS_YES THEN
2243:
2244: BEGIN
2245:
2246: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2247: application_short_name => 'MSC',
2248: statement_type => AD_DDL.DROP_INDEX,
2249: statement =>
2250: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,

Line 2248: statement_type => AD_DDL.DROP_INDEX,

2244: BEGIN
2245:
2246: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2247: application_short_name => 'MSC',
2248: statement_type => AD_DDL.DROP_INDEX,
2249: statement =>
2250: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,
2251: object_name => 'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2252:

Line 2266: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2262:
2263: IF v_dmd_class_enabled = SYS_YES THEN
2264:
2265: BEGIN
2266: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2267: application_short_name => 'MSC',
2268: statement_type => AD_DDL.DROP_INDEX,
2269: statement =>
2270: 'drop index MSC_ST_DMD_CLASS_N1_'||v_instance_code,

Line 2268: statement_type => AD_DDL.DROP_INDEX,

2264:
2265: BEGIN
2266: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2267: application_short_name => 'MSC',
2268: statement_type => AD_DDL.DROP_INDEX,
2269: statement =>
2270: 'drop index MSC_ST_DMD_CLASS_N1_'||v_instance_code,
2271: object_name => 'MSC_ST_DMD_CLASS_N1_'||v_instance_code);
2272:

Line 2284: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2280:
2281: IF v_tp_enabled = SYS_YES THEN
2282:
2283: BEGIN
2284: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2285: application_short_name => 'MSC',
2286: statement_type => AD_DDL.DROP_INDEX,
2287: statement =>
2288: 'drop index MSC_ST_TRADING_PART_N1_'||v_instance_code,

Line 2286: statement_type => AD_DDL.DROP_INDEX,

2282:
2283: BEGIN
2284: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2285: application_short_name => 'MSC',
2286: statement_type => AD_DDL.DROP_INDEX,
2287: statement =>
2288: 'drop index MSC_ST_TRADING_PART_N1_'||v_instance_code,
2289: object_name => 'MSC_ST_TRADING_PART_N1_'||v_instance_code);
2290:

Line 2299: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_TRADING_PART_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2296: END;
2297:
2298: BEGIN
2299: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2300: application_short_name => 'MSC',
2301: statement_type => AD_DDL.DROP_INDEX,
2302: statement =>
2303: 'drop index MSC_ST_TRADING_PART_N2_'||v_instance_code,

Line 2301: statement_type => AD_DDL.DROP_INDEX,

2297:
2298: BEGIN
2299: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2300: application_short_name => 'MSC',
2301: statement_type => AD_DDL.DROP_INDEX,
2302: statement =>
2303: 'drop index MSC_ST_TRADING_PART_N2_'||v_instance_code,
2304: object_name => 'MSC_ST_TRADING_PART_N2_'||v_instance_code);
2305:

Line 2314: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_TRADING_PART_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2311: END;
2312:
2313: BEGIN
2314: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2315: application_short_name => 'MSC',
2316: statement_type => AD_DDL.DROP_INDEX,
2317: statement =>
2318: 'drop index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code,

Line 2316: statement_type => AD_DDL.DROP_INDEX,

2312:
2313: BEGIN
2314: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2315: application_short_name => 'MSC',
2316: statement_type => AD_DDL.DROP_INDEX,
2317: statement =>
2318: 'drop index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code,
2319: object_name => 'MSC_ST_TRD_PART_SITES_N1_'||v_instance_code);
2320:

Line 2329: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2325: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2326: END;
2327:
2328: BEGIN
2329: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2330: application_short_name => 'MSC',
2331: statement_type => AD_DDL.DROP_INDEX,
2332: statement =>
2333: 'drop index MSC_ST_SUB_INV_N1_'||v_instance_code,

Line 2331: statement_type => AD_DDL.DROP_INDEX,

2327:
2328: BEGIN
2329: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2330: application_short_name => 'MSC',
2331: statement_type => AD_DDL.DROP_INDEX,
2332: statement =>
2333: 'drop index MSC_ST_SUB_INV_N1_'||v_instance_code,
2334: object_name => 'MSC_ST_SUB_INV_N1_'||v_instance_code);
2335:

Line 2344: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2340: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUB_INV_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2341: END;
2342:
2343: BEGIN
2344: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2345: application_short_name => 'MSC',
2346: statement_type => AD_DDL.DROP_INDEX,
2347: statement =>
2348: 'drop index MSC_ST_LOC_ASC_N1_'||v_instance_code,

Line 2346: statement_type => AD_DDL.DROP_INDEX,

2342:
2343: BEGIN
2344: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2345: application_short_name => 'MSC',
2346: statement_type => AD_DDL.DROP_INDEX,
2347: statement =>
2348: 'drop index MSC_ST_LOC_ASC_N1_'||v_instance_code,
2349: object_name => 'MSC_ST_LOC_ASC_N1_'||v_instance_code);
2350:

Line 2359: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2355: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_LOC_ASC_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2356: END;
2357:
2358: BEGIN
2359: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2360: application_short_name => 'MSC',
2361: statement_type => AD_DDL.DROP_INDEX,
2362: statement =>
2363: 'drop index MSC_ST_PART_CONT_N1_'||v_instance_code,

Line 2361: statement_type => AD_DDL.DROP_INDEX,

2357:
2358: BEGIN
2359: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2360: application_short_name => 'MSC',
2361: statement_type => AD_DDL.DROP_INDEX,
2362: statement =>
2363: 'drop index MSC_ST_PART_CONT_N1_'||v_instance_code,
2364: object_name => 'MSC_ST_PART_CONT_N1_'||v_instance_code);
2365:

Line 2376: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2372: -- For Aeroexchange
2373: -- Drop index of MSC_ST_GROUP_COMPANIES
2374:
2375: BEGIN
2376: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2377: application_short_name => 'MSC',
2378: statement_type => AD_DDL.DROP_INDEX,
2379: statement =>
2380: 'drop index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code,

Line 2378: statement_type => AD_DDL.DROP_INDEX,

2374:
2375: BEGIN
2376: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2377: application_short_name => 'MSC',
2378: statement_type => AD_DDL.DROP_INDEX,
2379: statement =>
2380: 'drop index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code,
2381: object_name => 'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
2382:

Line 2393: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2389:
2390:
2391: ---- Drop index of MSC_ST_GROUPS
2392: BEGIN
2393: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2394: application_short_name => 'MSC',
2395: statement_type => AD_DDL.DROP_INDEX,
2396: statement =>
2397: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,

Line 2395: statement_type => AD_DDL.DROP_INDEX,

2391: ---- Drop index of MSC_ST_GROUPS
2392: BEGIN
2393: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2394: application_short_name => 'MSC',
2395: statement_type => AD_DDL.DROP_INDEX,
2396: statement =>
2397: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,
2398: object_name => 'MSC_ST_GROUPS_N1_'||v_instance_code);
2399:

Line 2414: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2410: -- For bug fix 2379391, dropping the indexes for MSC_ST_ITEM_CUSTOMERS
2411: IF v_item_cst_enabled = SYS_YES THEN
2412:
2413: BEGIN
2414: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2415: application_short_name => 'MSC',
2416: statement_type => AD_DDL.DROP_INDEX,
2417: statement =>
2418: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,

Line 2416: statement_type => AD_DDL.DROP_INDEX,

2412:
2413: BEGIN
2414: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2415: application_short_name => 'MSC',
2416: statement_type => AD_DDL.DROP_INDEX,
2417: statement =>
2418: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,
2419: object_name => 'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2420:

Line 2429: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2426: END;
2427:
2428: BEGIN
2429: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2430: application_short_name => 'MSC',
2431: statement_type => AD_DDL.DROP_INDEX,
2432: statement =>
2433: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,

Line 2431: statement_type => AD_DDL.DROP_INDEX,

2427:
2428: BEGIN
2429: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2430: application_short_name => 'MSC',
2431: statement_type => AD_DDL.DROP_INDEX,
2432: statement =>
2433: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,
2434: object_name => 'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2435:

Line 2450: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2446:
2447: IF v_ship_mthd_enabled = SYS_YES THEN
2448:
2449: BEGIN
2450: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2451: application_short_name => 'MSC',
2452: statement_type => AD_DDL.DROP_INDEX,
2453: statement =>
2454: 'drop index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code,

Line 2452: statement_type => AD_DDL.DROP_INDEX,

2448:
2449: BEGIN
2450: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2451: application_short_name => 'MSC',
2452: statement_type => AD_DDL.DROP_INDEX,
2453: statement =>
2454: 'drop index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code,
2455: object_name => 'MSC_ST_INTERORG_SHIP_N1_'||v_instance_code);
2456:

Line 2468: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2464:
2465: IF v_sourcing_enabled = SYS_YES THEN
2466:
2467: BEGIN
2468: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2469: application_short_name => 'MSC',
2470: statement_type => AD_DDL.DROP_INDEX,
2471: statement =>
2472: 'drop index MSC_ST_ITEM_SRC_N1_'||v_instance_code,

Line 2470: statement_type => AD_DDL.DROP_INDEX,

2466:
2467: BEGIN
2468: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2469: application_short_name => 'MSC',
2470: statement_type => AD_DDL.DROP_INDEX,
2471: statement =>
2472: 'drop index MSC_ST_ITEM_SRC_N1_'||v_instance_code,
2473: object_name => 'MSC_ST_ITEM_SRC_N1_'||v_instance_code);
2474:

Line 2483: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2479: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_SRC_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2480: END;
2481:
2482: BEGIN
2483: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2484: application_short_name => 'MSC',
2485: statement_type => AD_DDL.DROP_INDEX,
2486: statement =>
2487: 'drop index MSC_ST_REGIONS_N1_'||v_instance_code,

Line 2485: statement_type => AD_DDL.DROP_INDEX,

2481:
2482: BEGIN
2483: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2484: application_short_name => 'MSC',
2485: statement_type => AD_DDL.DROP_INDEX,
2486: statement =>
2487: 'drop index MSC_ST_REGIONS_N1_'||v_instance_code,
2488: object_name => 'MSC_ST_REGIONS_N1_'||v_instance_code);
2489:

Line 2498: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2494: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_REGIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2495: END;
2496:
2497: BEGIN
2498: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2499: application_short_name => 'MSC',
2500: statement_type => AD_DDL.DROP_INDEX,
2501: statement =>
2502: 'drop index MSC_ST_REGIONS_N1_'||v_instance_code,

Line 2500: statement_type => AD_DDL.DROP_INDEX,

2496:
2497: BEGIN
2498: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2499: application_short_name => 'MSC',
2500: statement_type => AD_DDL.DROP_INDEX,
2501: statement =>
2502: 'drop index MSC_ST_REGIONS_N1_'||v_instance_code,
2503: object_name => 'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
2504:

Line 2513: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2509: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2510: END;
2511:
2512: BEGIN
2513: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2514: application_short_name => 'MSC',
2515: statement_type => AD_DDL.DROP_INDEX,
2516: statement =>
2517: 'drop index MSC_ST_REGION_LOC_N1_'||v_instance_code,

Line 2515: statement_type => AD_DDL.DROP_INDEX,

2511:
2512: BEGIN
2513: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2514: application_short_name => 'MSC',
2515: statement_type => AD_DDL.DROP_INDEX,
2516: statement =>
2517: 'drop index MSC_ST_REGION_LOC_N1_'||v_instance_code,
2518: object_name => 'MSC_ST_REGION_LOC_N1_'||v_instance_code);
2519:

Line 2528: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2524: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_REGION_LOC_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2525: END;
2526:
2527: BEGIN
2528: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2529: application_short_name => 'MSC',
2530: statement_type => AD_DDL.DROP_INDEX,
2531: statement =>
2532: 'drop index MSC_ST_REGION_SITE_N1_'||v_instance_code,

Line 2530: statement_type => AD_DDL.DROP_INDEX,

2526:
2527: BEGIN
2528: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2529: application_short_name => 'MSC',
2530: statement_type => AD_DDL.DROP_INDEX,
2531: statement =>
2532: 'drop index MSC_ST_REGION_SITE_N1_'||v_instance_code,
2533: object_name => 'MSC_ST_REGION_SITE_N1_'||v_instance_code);
2534:

Line 2547: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2543:
2544: IF v_res_dmd_enabled = SYS_YES THEN
2545:
2546: BEGIN
2547: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2548: application_short_name => 'MSC',
2549: statement_type => AD_DDL.DROP_INDEX,
2550: statement =>
2551: 'drop index MSC_ST_RES_REQ_N1_'||v_instance_code,

Line 2549: statement_type => AD_DDL.DROP_INDEX,

2545:
2546: BEGIN
2547: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2548: application_short_name => 'MSC',
2549: statement_type => AD_DDL.DROP_INDEX,
2550: statement =>
2551: 'drop index MSC_ST_RES_REQ_N1_'||v_instance_code,
2552: object_name => 'MSC_ST_RES_REQ_N1_'||v_instance_code);
2553:

Line 2565: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2561:
2562: IF v_sup_cap_enabled = SYS_YES THEN
2563:
2564: BEGIN
2565: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2566: application_short_name => 'MSC',
2567: statement_type => AD_DDL.DROP_INDEX,
2568: statement =>
2569: 'drop index MSC_ST_ITEM_SUP_N1_'||v_instance_code,

Line 2567: statement_type => AD_DDL.DROP_INDEX,

2563:
2564: BEGIN
2565: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2566: application_short_name => 'MSC',
2567: statement_type => AD_DDL.DROP_INDEX,
2568: statement =>
2569: 'drop index MSC_ST_ITEM_SUP_N1_'||v_instance_code,
2570: object_name => 'MSC_ST_ITEM_SUP_N1_'||v_instance_code);
2571:

Line 2580: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2576: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_SUP_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2577: END;
2578:
2579: BEGIN
2580: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2581: application_short_name => 'MSC',
2582: statement_type => AD_DDL.DROP_INDEX,
2583: statement =>
2584: 'drop index MSC_ST_SUP_CAP_N1_'||v_instance_code,

Line 2582: statement_type => AD_DDL.DROP_INDEX,

2578:
2579: BEGIN
2580: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2581: application_short_name => 'MSC',
2582: statement_type => AD_DDL.DROP_INDEX,
2583: statement =>
2584: 'drop index MSC_ST_SUP_CAP_N1_'||v_instance_code,
2585: object_name => 'MSC_ST_SUP_CAP_N1_'||v_instance_code);
2586:

Line 2595: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2591: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUP_CAP_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2592: END;
2593:
2594: BEGIN
2595: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2596: application_short_name => 'MSC',
2597: statement_type => AD_DDL.DROP_INDEX,
2598: statement =>
2599: 'drop index MSC_ST_SUP_FENCES_N1_'||v_instance_code,

Line 2597: statement_type => AD_DDL.DROP_INDEX,

2593:
2594: BEGIN
2595: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2596: application_short_name => 'MSC',
2597: statement_type => AD_DDL.DROP_INDEX,
2598: statement =>
2599: 'drop index MSC_ST_SUP_FENCES_N1_'||v_instance_code,
2600: object_name => 'MSC_ST_SUP_FENCES_N1_'||v_instance_code);
2601:

Line 2615: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2611:
2612: IF v_safety_stk_enabled = SYS_YES THEN
2613:
2614: BEGIN
2615: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2616: application_short_name => 'MSC',
2617: statement_type => AD_DDL.DROP_INDEX,
2618: statement =>
2619: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,

Line 2617: statement_type => AD_DDL.DROP_INDEX,

2613:
2614: BEGIN
2615: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2616: application_short_name => 'MSC',
2617: statement_type => AD_DDL.DROP_INDEX,
2618: statement =>
2619: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,
2620: object_name => 'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2621:

Line 2635: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2631:
2632: IF v_item_substitute_enabled = SYS_YES THEN
2633:
2634: BEGIN
2635: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2636: application_short_name => 'MSC',
2637: statement_type => AD_DDL.DROP_INDEX,
2638: statement =>
2639: 'drop index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code,

Line 2637: statement_type => AD_DDL.DROP_INDEX,

2633:
2634: BEGIN
2635: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2636: application_short_name => 'MSC',
2637: statement_type => AD_DDL.DROP_INDEX,
2638: statement =>
2639: 'drop index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code,
2640: object_name => 'MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code);
2641:

Line 2654: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2650:
2651: IF v_planners_enabled = SYS_YES THEN
2652:
2653: BEGIN
2654: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2655: application_short_name => 'MSC',
2656: statement_type => AD_DDL.DROP_INDEX,
2657: statement =>
2658: 'drop index MSC_ST_PLANNERS_N1_'||v_instance_code,

Line 2656: statement_type => AD_DDL.DROP_INDEX,

2652:
2653: BEGIN
2654: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2655: application_short_name => 'MSC',
2656: statement_type => AD_DDL.DROP_INDEX,
2657: statement =>
2658: 'drop index MSC_ST_PLANNERS_N1_'||v_instance_code,
2659: object_name => 'MSC_ST_PLANNERS_N1_'||v_instance_code);
2660:

Line 2673: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2669:
2670: IF v_uom_class_enabled = SYS_YES THEN
2671:
2672: BEGIN
2673: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2674: application_short_name => 'MSC',
2675: statement_type => AD_DDL.DROP_INDEX,
2676: statement =>
2677: 'drop index MSC_ST_UOM_CLS_CONV_N1_'||v_instance_code,

Line 2675: statement_type => AD_DDL.DROP_INDEX,

2671:
2672: BEGIN
2673: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2674: application_short_name => 'MSC',
2675: statement_type => AD_DDL.DROP_INDEX,
2676: statement =>
2677: 'drop index MSC_ST_UOM_CLS_CONV_N1_'||v_instance_code,
2678: object_name => 'MSC_ST_UOM_CLS_CONV_N1_'||v_instance_code);
2679:

Line 2692: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2688:
2689: IF v_mat_sup_enabled = SYS_YES THEN
2690:
2691: BEGIN
2692: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2693: application_short_name => 'MSC',
2694: statement_type => AD_DDL.DROP_INDEX,
2695: statement =>
2696: 'drop index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code,

Line 2694: statement_type => AD_DDL.DROP_INDEX,

2690:
2691: BEGIN
2692: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2693: application_short_name => 'MSC',
2694: statement_type => AD_DDL.DROP_INDEX,
2695: statement =>
2696: 'drop index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code,
2697: object_name => 'MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code);
2698:

Line 2707: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2703: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2704: END;
2705:
2706: BEGIN
2707: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2708: application_short_name => 'MSC',
2709: statement_type => AD_DDL.DROP_INDEX,
2710: statement =>
2711: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,

Line 2709: statement_type => AD_DDL.DROP_INDEX,

2705:
2706: BEGIN
2707: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2708: application_short_name => 'MSC',
2709: statement_type => AD_DDL.DROP_INDEX,
2710: statement =>
2711: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,
2712: object_name => 'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2713:

Line 2722: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2718: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2719: END;
2720:
2721: BEGIN
2722: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2723: application_short_name => 'MSC',
2724: statement_type => AD_DDL.DROP_INDEX,
2725: statement =>
2726: 'drop index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code,

Line 2724: statement_type => AD_DDL.DROP_INDEX,

2720:
2721: BEGIN
2722: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2723: application_short_name => 'MSC',
2724: statement_type => AD_DDL.DROP_INDEX,
2725: statement =>
2726: 'drop index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code,
2727: object_name => 'MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code);
2728:

Line 2737: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2734: END;
2735:
2736: BEGIN
2737: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2738: application_short_name => 'MSC',
2739: statement_type => AD_DDL.DROP_INDEX,
2740: statement =>
2741: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,

Line 2739: statement_type => AD_DDL.DROP_INDEX,

2735:
2736: BEGIN
2737: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2738: application_short_name => 'MSC',
2739: statement_type => AD_DDL.DROP_INDEX,
2740: statement =>
2741: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,
2742: object_name => 'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2743:

Line 2756: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

2752:
2753: IF v_cal_assignment_enabled = SYS_YES THEN
2754:
2755: BEGIN
2756: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2757: application_short_name => 'MSC',
2758: statement_type => AD_DDL.DROP_INDEX,
2759: statement =>
2760: 'drop index MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code,

Line 2758: statement_type => AD_DDL.DROP_INDEX,

2754:
2755: BEGIN
2756: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2757: application_short_name => 'MSC',
2758: statement_type => AD_DDL.DROP_INDEX,
2759: statement =>
2760: 'drop index MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code,
2761: object_name => 'MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code);
2762: