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

539: IF v_item_enabled = SYS_YES THEN
540:
541: BEGIN
542:
543: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
544: application_short_name => 'MSC',
545: statement_type => AD_DDL.CREATE_INDEX,
546: statement =>
547: 'create index MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code

Line 545: statement_type => AD_DDL.CREATE_INDEX,

541: BEGIN
542:
543: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
544: application_short_name => 'MSC',
545: statement_type => AD_DDL.CREATE_INDEX,
546: statement =>
547: 'create index MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code
548: ||' on MSC_ST_SYSTEM_ITEMS '
549: ||'(item_name, sr_instance_code, organization_code, company_name) '

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

564:
565: IF v_mat_sup_enabled = SYS_YES THEN
566:
567: BEGIN
568: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
569: application_short_name => 'MSC',
570: statement_type => AD_DDL.CREATE_INDEX,
571: statement =>
572: 'create index MSC_ST_SUPPLIES_N1_'||v_instance_code

Line 570: statement_type => AD_DDL.CREATE_INDEX,

566:
567: BEGIN
568: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
569: application_short_name => 'MSC',
570: statement_type => AD_DDL.CREATE_INDEX,
571: statement =>
572: 'create index MSC_ST_SUPPLIES_N1_'||v_instance_code
573: ||' on MSC_ST_SUPPLIES '
574: ||'(SR_INSTANCE_CODE, ORDER_NUMBER, PURCH_LINE_NUM, ORDER_TYPE, COMPANY_NAME) '

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

581: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Error creating Index MSC_ST_SUPPLIES_N1_'||v_instance_code ||'. Error:'||substr(SQLERRM,1,240));
582: END;
583:
584: BEGIN
585: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
586: application_short_name => 'MSC',
587: statement_type => AD_DDL.CREATE_INDEX,
588: statement =>
589: 'create index MSC_ST_SUPPLIES_N2_'||v_instance_code

Line 587: statement_type => AD_DDL.CREATE_INDEX,

583:
584: BEGIN
585: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
586: application_short_name => 'MSC',
587: statement_type => AD_DDL.CREATE_INDEX,
588: statement =>
589: 'create index MSC_ST_SUPPLIES_N2_'||v_instance_code
590: ||' on MSC_ST_SUPPLIES '
591: ||'(sr_instance_code, schedule_line_num, schedule_designator, organization_code, order_type, company_name) '

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

598: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Error creating Index MSC_ST_SUPPLIES_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
599: END;
600:
601: BEGIN
602: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
603: application_short_name => 'MSC',
604: statement_type => AD_DDL.CREATE_INDEX,
605: statement =>
606: 'create index MSC_ST_SUPPLIES_N3_'||v_instance_code

Line 604: statement_type => AD_DDL.CREATE_INDEX,

600:
601: BEGIN
602: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
603: application_short_name => 'MSC',
604: statement_type => AD_DDL.CREATE_INDEX,
605: statement =>
606: 'create index MSC_ST_SUPPLIES_N3_'||v_instance_code
607: ||' on MSC_ST_SUPPLIES '
608: ||'(sr_instance_code, item_name, organization_code, order_type, company_name) '

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

617: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SUPPLIES_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
618: END;
619:
620: BEGIN
621: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
622: application_short_name => 'MSC',
623: statement_type => AD_DDL.CREATE_INDEX,
624: statement =>
625: 'create index MSC_ST_SUPPLIES_N4_'||v_instance_code

Line 623: statement_type => AD_DDL.CREATE_INDEX,

619:
620: BEGIN
621: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
622: application_short_name => 'MSC',
623: statement_type => AD_DDL.CREATE_INDEX,
624: statement =>
625: 'create index MSC_ST_SUPPLIES_N4_'||v_instance_code
626: ||' on MSC_ST_SUPPLIES '
627: ||'(sr_instance_code,wip_entity_name, organization_code,order_type, company_name) '

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

641:
642: IF v_mat_dmd_enabled = SYS_YES THEN
643:
644: BEGIN
645: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
646: application_short_name => 'MSC',
647: statement_type => AD_DDL.CREATE_INDEX,
648: statement =>
649: 'create index MSC_ST_DEMANDS_N1_'||v_instance_code

Line 647: statement_type => AD_DDL.CREATE_INDEX,

643:
644: BEGIN
645: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
646: application_short_name => 'MSC',
647: statement_type => AD_DDL.CREATE_INDEX,
648: statement =>
649: 'create index MSC_ST_DEMANDS_N1_'||v_instance_code
650: ||' on MSC_ST_DEMANDS '
651: ||'(sr_instance_code, schedule_date, item_name, organization_code, forecast_designator, company_name) '

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

659: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_DEMANDS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
660: END;
661:
662: BEGIN
663: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
664: application_short_name => 'MSC',
665: statement_type => AD_DDL.CREATE_INDEX,
666: statement =>
667: 'create index MSC_ST_DEMANDS_N2_'||v_instance_code

Line 665: statement_type => AD_DDL.CREATE_INDEX,

661:
662: BEGIN
663: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
664: application_short_name => 'MSC',
665: statement_type => AD_DDL.CREATE_INDEX,
666: statement =>
667: 'create index MSC_ST_DEMANDS_N2_'||v_instance_code
668: ||' on MSC_ST_DEMANDS '
669: ||'(SR_INSTANCE_CODE, ITEM_NAME,WIP_ENTITY_NAME, ORGANIZATION_CODE, ORIGINATION_TYPE, OPERATION_SEQ_CODE, COMPANY_NAME) '

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

677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_DEMANDS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
678: END;
679:
680: BEGIN
681: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
682: application_short_name => 'MSC',
683: statement_type => AD_DDL.CREATE_INDEX,
684: statement =>
685: 'create index MSC_ST_SO_N1_'||v_instance_code

Line 683: statement_type => AD_DDL.CREATE_INDEX,

679:
680: BEGIN
681: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
682: application_short_name => 'MSC',
683: statement_type => AD_DDL.CREATE_INDEX,
684: statement =>
685: 'create index MSC_ST_SO_N1_'||v_instance_code
686: ||' on MSC_ST_SALES_ORDERS '
687: ||'(sr_instance_code, sales_order_number, line_num, organization_code, company_name) '

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

702:
703: IF v_reserve_enabled = SYS_YES THEN
704:
705: BEGIN
706: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
707: application_short_name => 'MSC',
708: statement_type => AD_DDL.CREATE_INDEX,
709: statement =>
710: 'create index MSC_ST_RESERVE_N1_'||v_instance_code

Line 708: statement_type => AD_DDL.CREATE_INDEX,

704:
705: BEGIN
706: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
707: application_short_name => 'MSC',
708: statement_type => AD_DDL.CREATE_INDEX,
709: statement =>
710: 'create index MSC_ST_RESERVE_N1_'||v_instance_code
711: ||' on MSC_ST_RESERVATIONS '
712: ||'(sr_instance_code,sales_order_number, line_num,organization_code,company_name ) '

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

728:
729: IF v_bom_enabled = SYS_YES THEN
730:
731: BEGIN
732: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
733: application_short_name => 'MSC',
734: statement_type => AD_DDL.CREATE_INDEX,
735: statement =>
736: 'create index MSC_ST_BOMS_N1_'||v_instance_code

Line 734: statement_type => AD_DDL.CREATE_INDEX,

730:
731: BEGIN
732: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
733: application_short_name => 'MSC',
734: statement_type => AD_DDL.CREATE_INDEX,
735: statement =>
736: 'create index MSC_ST_BOMS_N1_'||v_instance_code
737: ||' on MSC_ST_BOMS '
738: ||'(sr_instance_code, assembly_name, organization_code, company_name, bom_name, alternate_bom_designator) '

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

745: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
746: END;
747:
748: BEGIN
749: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
750: application_short_name => 'MSC',
751: statement_type => AD_DDL.CREATE_INDEX,
752: statement =>
753: 'create index MSC_ST_BOM_COMP_N1_'||v_instance_code

Line 751: statement_type => AD_DDL.CREATE_INDEX,

747:
748: BEGIN
749: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
750: application_short_name => 'MSC',
751: statement_type => AD_DDL.CREATE_INDEX,
752: statement =>
753: 'create index MSC_ST_BOM_COMP_N1_'||v_instance_code
754: ||' on MSC_ST_BOM_COMPONENTS '
755: ||'(sr_instance_code, assembly_name, component_name, effectivity_date, operation_seq_code, organization_code, company_name, bom_name, alternate_bom_designator) '

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

762: 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));
763: END;
764:
765: BEGIN
766: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
767: application_short_name => 'MSC',
768: statement_type => AD_DDL.CREATE_INDEX,
769: statement =>
770: 'create index MSC_ST_COMP_SUB_N1_'||v_instance_code

Line 768: statement_type => AD_DDL.CREATE_INDEX,

764:
765: BEGIN
766: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
767: application_short_name => 'MSC',
768: statement_type => AD_DDL.CREATE_INDEX,
769: statement =>
770: 'create index MSC_ST_COMP_SUB_N1_'||v_instance_code
771: ||' on MSC_ST_COMPONENT_SUBSTITUTES '
772: ||'(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 785: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

781: END;
782:
783: -- Added for Co Products (OSFM Integration) --
784: BEGIN
785: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
786: application_short_name => 'MSC',
787: statement_type => AD_DDL.CREATE_INDEX,
788: statement =>
789: 'create index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code

Line 787: statement_type => AD_DDL.CREATE_INDEX,

783: -- Added for Co Products (OSFM Integration) --
784: BEGIN
785: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
786: application_short_name => 'MSC',
787: statement_type => AD_DDL.CREATE_INDEX,
788: statement =>
789: 'create index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code
790: ||' on MSC_ST_CO_PRODUCTS '
791: ||'(co_product_name,component_name,sr_instance_code,company_name ) '

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

808:
809: IF v_rtg_enabled = SYS_YES THEN
810:
811: BEGIN
812: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
813: application_short_name => 'MSC',
814: statement_type => AD_DDL.CREATE_INDEX,
815: statement =>
816: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code

Line 814: statement_type => AD_DDL.CREATE_INDEX,

810:
811: BEGIN
812: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
813: application_short_name => 'MSC',
814: statement_type => AD_DDL.CREATE_INDEX,
815: statement =>
816: 'create index MSC_ST_ROUTINGS_N1_'||v_instance_code
817: ||' on MSC_ST_ROUTINGS '
818: ||'(sr_instance_code, assembly_name, organization_code, company_name, routing_name, alternate_routing_designator) '

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

826: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
827: END;
828:
829: BEGIN
830: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
831: application_short_name => 'MSC',
832: statement_type => AD_DDL.CREATE_INDEX,
833: statement =>
834: 'create index MSC_ST_ROUTING_OPER_N1_'||v_instance_code

Line 832: statement_type => AD_DDL.CREATE_INDEX,

828:
829: BEGIN
830: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
831: application_short_name => 'MSC',
832: statement_type => AD_DDL.CREATE_INDEX,
833: statement =>
834: 'create index MSC_ST_ROUTING_OPER_N1_'||v_instance_code
835: ||' on MSC_ST_ROUTING_OPERATIONS '
836: ||'( sr_instance_code, assembly_name, operation_seq_code, organization_code, company_name, routing_name, alternate_routing_designator) '

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

845: 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));
846: END;
847:
848: BEGIN
849: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
850: application_short_name => 'MSC',
851: statement_type => AD_DDL.CREATE_INDEX,
852: statement =>
853: 'create index MSC_ST_OPER_RES_N1_'||v_instance_code

Line 851: statement_type => AD_DDL.CREATE_INDEX,

847:
848: BEGIN
849: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
850: application_short_name => 'MSC',
851: statement_type => AD_DDL.CREATE_INDEX,
852: statement =>
853: 'create index MSC_ST_OPER_RES_N1_'||v_instance_code
854: ||' on MSC_ST_OPERATION_RESOURCES '
855: ||'(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 868: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

864: END;
865:
866: -- Added for Operation Networks (OSFM Integration )
867: BEGIN
868: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
869: application_short_name => 'MSC',
870: statement_type => AD_DDL.CREATE_INDEX,
871: statement =>
872: 'create index MSC_ST_OPER_NTWK_N1_'||v_instance_code

Line 870: statement_type => AD_DDL.CREATE_INDEX,

866: -- Added for Operation Networks (OSFM Integration )
867: BEGIN
868: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
869: application_short_name => 'MSC',
870: statement_type => AD_DDL.CREATE_INDEX,
871: statement =>
872: 'create index MSC_ST_OPER_NTWK_N1_'||v_instance_code
873: ||' on MSC_ST_OPERATION_NETWORKS '
874: ||'(assembly_name, organization_code,FROM_OPERATION_SEQ_CODE, TO_OPERATION_SEQ_CODE,sr_instance_code, company_name) '

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

892:
893: IF v_item_cat_enabled = SYS_YES THEN
894:
895: BEGIN
896: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
897: application_short_name => 'MSC',
898: statement_type => AD_DDL.CREATE_INDEX,
899: statement =>
900: 'create index MSC_ST_ITEM_CAT_N1_'||v_instance_code

Line 898: statement_type => AD_DDL.CREATE_INDEX,

894:
895: BEGIN
896: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
897: application_short_name => 'MSC',
898: statement_type => AD_DDL.CREATE_INDEX,
899: statement =>
900: 'create index MSC_ST_ITEM_CAT_N1_'||v_instance_code
901: ||' on MSC_ST_ITEM_CATEGORIES '
902: ||'(sr_instance_code,item_name, category_name, category_set_name, organization_code, company_name) '

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

910: 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));
911: END;
912:
913: BEGIN
914: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
915: application_short_name => 'MSC',
916: statement_type => AD_DDL.CREATE_INDEX,
917: statement =>
918: 'create index MSC_ST_ITEM_CAT_N2_'||v_instance_code

Line 916: statement_type => AD_DDL.CREATE_INDEX,

912:
913: BEGIN
914: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
915: application_short_name => 'MSC',
916: statement_type => AD_DDL.CREATE_INDEX,
917: statement =>
918: 'create index MSC_ST_ITEM_CAT_N2_'||v_instance_code
919: ||' on MSC_ST_ITEM_CATEGORIES '
920: ||'(sr_instance_code,batch_id) '

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

934:
935: IF v_resources_enabled = SYS_YES THEN
936: BEGIN
937:
938: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
939: application_short_name => 'MSC',
940: statement_type => AD_DDL.CREATE_INDEX,
941: statement =>
942: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code

Line 940: statement_type => AD_DDL.CREATE_INDEX,

936: BEGIN
937:
938: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
939: application_short_name => 'MSC',
940: statement_type => AD_DDL.CREATE_INDEX,
941: statement =>
942: 'create index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code
943: ||' on MSC_ST_RESOURCE_GROUPS '
944: ||'(sr_instance_code, group_code, company_name) '

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

952: 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));
953: END;
954:
955: BEGIN
956: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
957: application_short_name => 'MSC',
958: statement_type => AD_DDL.CREATE_INDEX,
959: statement =>
960: 'create index MSC_ST_DEPT_RES_N1_'||v_instance_code

Line 958: statement_type => AD_DDL.CREATE_INDEX,

954:
955: BEGIN
956: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
957: application_short_name => 'MSC',
958: statement_type => AD_DDL.CREATE_INDEX,
959: statement =>
960: 'create index MSC_ST_DEPT_RES_N1_'||v_instance_code
961: ||' on MSC_ST_DEPARTMENT_RESOURCES '
962: ||'(sr_instance_code, resource_code, department_code, organization_code, company_name) '

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

970: 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));
971: END;
972:
973: BEGIN
974: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
975: application_short_name => 'MSC',
976: statement_type => AD_DDL.CREATE_INDEX,
977: statement =>
978: 'create index MSC_ST_RES_SHIFTS_N1_'||v_instance_code

Line 976: statement_type => AD_DDL.CREATE_INDEX,

972:
973: BEGIN
974: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
975: application_short_name => 'MSC',
976: statement_type => AD_DDL.CREATE_INDEX,
977: statement =>
978: 'create index MSC_ST_RES_SHIFTS_N1_'||v_instance_code
979: ||' on MSC_ST_RESOURCE_SHIFTS '
980: ||'(sr_instance_code, resource_code, department_code, shift_name, organization_code, company_name) '

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

988: 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));
989: END;
990:
991: BEGIN
992: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
993: application_short_name => 'MSC',
994: statement_type => AD_DDL.CREATE_INDEX,
995: statement =>
996: 'create index MSC_ST_RES_CHANGES_N1_'||v_instance_code

Line 994: statement_type => AD_DDL.CREATE_INDEX,

990:
991: BEGIN
992: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
993: application_short_name => 'MSC',
994: statement_type => AD_DDL.CREATE_INDEX,
995: statement =>
996: 'create index MSC_ST_RES_CHANGES_N1_'||v_instance_code
997: ||' on MSC_ST_RESOURCE_CHANGES '
998: ||'(sr_instance_code, simulation_set, resource_code, department_code, from_date, shift_name, organization_code, company_name) '

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

1015:
1016: IF v_project_enabled = SYS_YES THEN
1017:
1018: BEGIN
1019: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1020: application_short_name => 'MSC',
1021: statement_type => AD_DDL.CREATE_INDEX,
1022: statement =>
1023: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code

Line 1021: statement_type => AD_DDL.CREATE_INDEX,

1017:
1018: BEGIN
1019: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1020: application_short_name => 'MSC',
1021: statement_type => AD_DDL.CREATE_INDEX,
1022: statement =>
1023: 'create index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code
1024: ||' on MSC_ST_PROJECT_TASKS '
1025: ||'(sr_instance_code, project_number, task_number, organization_code, company_name) '

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

1039:
1040: IF v_dmd_class_enabled = SYS_YES THEN
1041:
1042: BEGIN
1043: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1044: application_short_name => 'MSC',
1045: statement_type => AD_DDL.CREATE_INDEX,
1046: statement =>
1047: 'create index MSC_ST_DMD_CLASS_N1_'||v_instance_code

Line 1045: statement_type => AD_DDL.CREATE_INDEX,

1041:
1042: BEGIN
1043: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1044: application_short_name => 'MSC',
1045: statement_type => AD_DDL.CREATE_INDEX,
1046: statement =>
1047: 'create index MSC_ST_DMD_CLASS_N1_'||v_instance_code
1048: ||' on MSC_ST_DEMAND_CLASSES '
1049: ||'(sr_instance_code,demand_class,company_name) '

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

1063:
1064: IF v_tp_enabled = SYS_YES THEN
1065:
1066: BEGIN
1067: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1068: application_short_name => 'MSC',
1069: statement_type => AD_DDL.CREATE_INDEX,
1070: statement =>
1071: 'create index MSC_ST_TRADING_PART_N1_'||v_instance_code

Line 1069: statement_type => AD_DDL.CREATE_INDEX,

1065:
1066: BEGIN
1067: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1068: application_short_name => 'MSC',
1069: statement_type => AD_DDL.CREATE_INDEX,
1070: statement =>
1071: 'create index MSC_ST_TRADING_PART_N1_'||v_instance_code
1072: ||' on MSC_ST_TRADING_PARTNERS '
1073: ||'(sr_instance_code, partner_name, partner_type, company_name) '

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

1081: 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));
1082: END;
1083:
1084: BEGIN
1085: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1086: application_short_name => 'MSC',
1087: statement_type => AD_DDL.CREATE_INDEX,
1088: statement =>
1089: 'create index MSC_ST_TRADING_PART_N2_'||v_instance_code

Line 1087: statement_type => AD_DDL.CREATE_INDEX,

1083:
1084: BEGIN
1085: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1086: application_short_name => 'MSC',
1087: statement_type => AD_DDL.CREATE_INDEX,
1088: statement =>
1089: 'create index MSC_ST_TRADING_PART_N2_'||v_instance_code
1090: ||' on MSC_ST_TRADING_PARTNERS '
1091: ||'(sr_instance_code, organization_code, partner_type, company_name) '

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

1099: 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));
1100: END;
1101:
1102: BEGIN
1103: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1104: application_short_name => 'MSC',
1105: statement_type => AD_DDL.CREATE_INDEX,
1106: statement =>
1107: 'create index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code

Line 1105: statement_type => AD_DDL.CREATE_INDEX,

1101:
1102: BEGIN
1103: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1104: application_short_name => 'MSC',
1105: statement_type => AD_DDL.CREATE_INDEX,
1106: statement =>
1107: 'create index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code
1108: ||' on MSC_ST_TRADING_PARTNER_SITES '
1109: ||'(sr_instance_code ,tp_site_code, partner_name, partner_type) '

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

1117: 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));
1118: END;
1119:
1120: BEGIN
1121: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1122: application_short_name => 'MSC',
1123: statement_type => AD_DDL.CREATE_INDEX,
1124: statement =>
1125: 'create index MSC_ST_SUB_INV_N1_'||v_instance_code

Line 1123: statement_type => AD_DDL.CREATE_INDEX,

1119:
1120: BEGIN
1121: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1122: application_short_name => 'MSC',
1123: statement_type => AD_DDL.CREATE_INDEX,
1124: statement =>
1125: 'create index MSC_ST_SUB_INV_N1_'||v_instance_code
1126: ||' on MSC_ST_SUB_INVENTORIES '
1127: ||'( sr_instance_code, sub_inventory_code, organization_code ) '

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

1135: 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));
1136: END;
1137:
1138: BEGIN
1139: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1140: application_short_name => 'MSC',
1141: statement_type => AD_DDL.CREATE_INDEX,
1142: statement =>
1143: 'create index MSC_ST_LOC_ASC_N1_'||v_instance_code

Line 1141: statement_type => AD_DDL.CREATE_INDEX,

1137:
1138: BEGIN
1139: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1140: application_short_name => 'MSC',
1141: statement_type => AD_DDL.CREATE_INDEX,
1142: statement =>
1143: 'create index MSC_ST_LOC_ASC_N1_'||v_instance_code
1144: ||' on MSC_ST_LOCATION_ASSOCIATIONS '
1145: ||'(sr_instance_code, location_code, tp_site_code, partner_name, partner_type, company_name) '

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

1153: 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));
1154: END;
1155:
1156: BEGIN
1157: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1158: application_short_name => 'MSC',
1159: statement_type => AD_DDL.CREATE_INDEX,
1160: statement =>
1161: 'create index MSC_ST_PART_CONT_N1_'||v_instance_code

Line 1159: statement_type => AD_DDL.CREATE_INDEX,

1155:
1156: BEGIN
1157: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1158: application_short_name => 'MSC',
1159: statement_type => AD_DDL.CREATE_INDEX,
1160: statement =>
1161: 'create index MSC_ST_PART_CONT_N1_'||v_instance_code
1162: ||' on MSC_ST_PARTNER_CONTACTS '
1163: ||'(sr_instance_code,tp_site_code, partner_name, partner_type, company_name) '

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

1173:
1174: --For Aeroexchange
1175: --Added for MSC_ST_GROUPS
1176: BEGIN
1177: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1178: application_short_name => 'MSC',
1179: statement_type => AD_DDL.CREATE_INDEX,
1180: statement =>
1181: 'create index MSC_ST_GROUPS_N1_'||v_instance_code

Line 1179: statement_type => AD_DDL.CREATE_INDEX,

1175: --Added for MSC_ST_GROUPS
1176: BEGIN
1177: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1178: application_short_name => 'MSC',
1179: statement_type => AD_DDL.CREATE_INDEX,
1180: statement =>
1181: 'create index MSC_ST_GROUPS_N1_'||v_instance_code
1182: ||' on MSC_ST_GROUPS '
1183: ||'(GROUP_NAME) '

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

1193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_GROUPS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1194: END;
1195:
1196: BEGIN
1197: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1198: application_short_name => 'MSC',
1199: statement_type => AD_DDL.CREATE_INDEX,
1200: statement =>
1201: 'create index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code

Line 1199: statement_type => AD_DDL.CREATE_INDEX,

1195:
1196: BEGIN
1197: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1198: application_short_name => 'MSC',
1199: statement_type => AD_DDL.CREATE_INDEX,
1200: statement =>
1201: 'create index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code
1202: ||' on MSC_ST_GROUP_COMPANIES '
1203: ||'(group_name,company_name) '

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

1224: IF v_item_cst_enabled = SYS_YES THEN
1225:
1226: BEGIN
1227:
1228: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1229: application_short_name => 'MSC',
1230: statement_type => AD_DDL.CREATE_INDEX,
1231: statement =>
1232: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code

Line 1230: statement_type => AD_DDL.CREATE_INDEX,

1226: BEGIN
1227:
1228: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1229: application_short_name => 'MSC',
1230: statement_type => AD_DDL.CREATE_INDEX,
1231: statement =>
1232: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code
1233: ||' on MSC_ST_ITEM_CUSTOMERS '
1234: ||'(ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '

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

1243: END;
1244:
1245: BEGIN
1246:
1247: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1248: application_short_name => 'MSC',
1249: statement_type => AD_DDL.CREATE_INDEX,
1250: statement =>
1251: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code

Line 1249: statement_type => AD_DDL.CREATE_INDEX,

1245: BEGIN
1246:
1247: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1248: application_short_name => 'MSC',
1249: statement_type => AD_DDL.CREATE_INDEX,
1250: statement =>
1251: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code
1252: ||' on MSC_ST_ITEM_CUSTOMERS '
1253: ||'(CUSTOMER_ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '

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

1267:
1268: IF v_ship_mthd_enabled = SYS_YES THEN
1269:
1270: BEGIN
1271: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1272: application_short_name => 'MSC',
1273: statement_type => AD_DDL.CREATE_INDEX,
1274: statement =>
1275: 'create index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code

Line 1273: statement_type => AD_DDL.CREATE_INDEX,

1269:
1270: BEGIN
1271: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1272: application_short_name => 'MSC',
1273: statement_type => AD_DDL.CREATE_INDEX,
1274: statement =>
1275: 'create index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code
1276: ||' on MSC_ST_INTERORG_SHIP_METHODS '
1277: ||'(sr_instance_code,from_organization_code,to_organization_code,ship_method,company_name) '

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

1292: IF v_sourcing_enabled = SYS_YES THEN
1293:
1294: BEGIN
1295:
1296: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1297: application_short_name => 'MSC',
1298: statement_type => AD_DDL.CREATE_INDEX,
1299: statement =>
1300: 'create index MSC_ST_ITEM_SRC_N1_'||v_instance_code

Line 1298: statement_type => AD_DDL.CREATE_INDEX,

1294: BEGIN
1295:
1296: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1297: application_short_name => 'MSC',
1298: statement_type => AD_DDL.CREATE_INDEX,
1299: statement =>
1300: 'create index MSC_ST_ITEM_SRC_N1_'||v_instance_code
1301: ||' on MSC_ST_ITEM_SOURCING '
1302: ||'(sr_instance_code, sourcing_rule_name, assignment_set_name, organization_code, company_name, receipt_organization_code, source_organization_code) '

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

1311: END;
1312:
1313: BEGIN
1314:
1315: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1316: application_short_name => 'MSC',
1317: statement_type => AD_DDL.CREATE_INDEX,
1318: statement =>
1319: 'create index MSC_ST_REGIONS_N1_'||v_instance_code

Line 1317: statement_type => AD_DDL.CREATE_INDEX,

1313: BEGIN
1314:
1315: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1316: application_short_name => 'MSC',
1317: statement_type => AD_DDL.CREATE_INDEX,
1318: statement =>
1319: 'create index MSC_ST_REGIONS_N1_'||v_instance_code
1320: ||' on MSC_ST_REGIONS '
1321: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, zone ) '

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

1330: END;
1331:
1332: BEGIN
1333:
1334: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1335: application_short_name => 'MSC',
1336: statement_type => AD_DDL.CREATE_INDEX,
1337: statement =>
1338: 'create index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code

Line 1336: statement_type => AD_DDL.CREATE_INDEX,

1332: BEGIN
1333:
1334: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1335: application_short_name => 'MSC',
1336: statement_type => AD_DDL.CREATE_INDEX,
1337: statement =>
1338: 'create index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code
1339: ||' on MSC_ST_ZONE_REGIONS '
1340: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, zone ) '

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

1348: 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));
1349: END;
1350:
1351: BEGIN
1352: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1353: application_short_name => 'MSC',
1354: statement_type => AD_DDL.CREATE_INDEX,
1355: statement =>
1356: 'create index MSC_ST_REGION_LOC_N1_'||v_instance_code

Line 1354: statement_type => AD_DDL.CREATE_INDEX,

1350:
1351: BEGIN
1352: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1353: application_short_name => 'MSC',
1354: statement_type => AD_DDL.CREATE_INDEX,
1355: statement =>
1356: 'create index MSC_ST_REGION_LOC_N1_'||v_instance_code
1357: ||' on MSC_ST_REGION_LOCATIONS '
1358: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, location_code ) '

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

1366: 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));
1367: END;
1368:
1369: BEGIN
1370: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1371: application_short_name => 'MSC',
1372: statement_type => AD_DDL.CREATE_INDEX,
1373: statement =>
1374: 'create index MSC_ST_REGION_SITE_N1_'||v_instance_code

Line 1372: statement_type => AD_DDL.CREATE_INDEX,

1368:
1369: BEGIN
1370: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1371: application_short_name => 'MSC',
1372: statement_type => AD_DDL.CREATE_INDEX,
1373: statement =>
1374: 'create index MSC_ST_REGION_SITE_N1_'||v_instance_code
1375: ||' on MSC_ST_REGION_SITES '
1376: ||'(sr_instance_code, country, state, city, postal_code_from, postal_code_to, vendor_name, vendor_site_code ) '

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

1395: IF v_res_dmd_enabled = SYS_YES THEN
1396:
1397: BEGIN
1398:
1399: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1400: application_short_name => 'MSC',
1401: statement_type => AD_DDL.CREATE_INDEX,
1402: statement =>
1403: 'create index MSC_ST_RES_REQ_N1_'||v_instance_code

Line 1401: statement_type => AD_DDL.CREATE_INDEX,

1397: BEGIN
1398:
1399: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1400: application_short_name => 'MSC',
1401: statement_type => AD_DDL.CREATE_INDEX,
1402: statement =>
1403: 'create index MSC_ST_RES_REQ_N1_'||v_instance_code
1404: ||' on MSC_ST_RESOURCE_REQUIREMENTS '
1405: ||'(sr_instance_code, resource_code, wip_entity_name, operation_seq_code, organization_code, company_name, resource_seq_code) '

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

1420: IF v_uom_class_enabled = SYS_YES THEN
1421:
1422: BEGIN
1423:
1424: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1425: application_short_name => 'MSC',
1426: statement_type => AD_DDL.CREATE_INDEX,
1427: statement =>
1428: 'create index MSC_ST_UOM_CLS_CONV_N1_'||v_instance_code

Line 1426: statement_type => AD_DDL.CREATE_INDEX,

1422: BEGIN
1423:
1424: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1425: application_short_name => 'MSC',
1426: statement_type => AD_DDL.CREATE_INDEX,
1427: statement =>
1428: 'create index MSC_ST_UOM_CLS_CONV_N1_'||v_instance_code
1429: ||' on MSC_ST_UOM_CLASS_CONVERSIONS '
1430: ||'( from_uom_code, to_uom_code, item_name, company_name) '

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

1444:
1445: IF v_sup_cap_enabled = SYS_YES THEN
1446:
1447: BEGIN
1448: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1449: application_short_name => 'MSC',
1450: statement_type => AD_DDL.CREATE_INDEX,
1451: statement =>
1452: 'create index MSC_ST_ITEM_SUP_N1_'||v_instance_code

Line 1450: statement_type => AD_DDL.CREATE_INDEX,

1446:
1447: BEGIN
1448: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1449: application_short_name => 'MSC',
1450: statement_type => AD_DDL.CREATE_INDEX,
1451: statement =>
1452: 'create index MSC_ST_ITEM_SUP_N1_'||v_instance_code
1453: ||' on MSC_ST_ITEM_SUPPLIERS '
1454: ||'(sr_instance_code, item_name, vendor_name, organization_code, company_name, vendor_site_code) '

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

1463: 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));
1464: END;
1465:
1466: BEGIN
1467: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1468: application_short_name => 'MSC',
1469: statement_type => AD_DDL.CREATE_INDEX,
1470: statement =>
1471: 'create index MSC_ST_SUP_CAP_N1_'||v_instance_code

Line 1469: statement_type => AD_DDL.CREATE_INDEX,

1465:
1466: BEGIN
1467: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1468: application_short_name => 'MSC',
1469: statement_type => AD_DDL.CREATE_INDEX,
1470: statement =>
1471: 'create index MSC_ST_SUP_CAP_N1_'||v_instance_code
1472: ||' on MSC_ST_SUPPLIER_CAPACITIES '
1473: ||'(sr_instance_code, item_name, vendor_name, from_date,organization_code,company_name,vendor_site_code) '

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

1481: 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));
1482: END;
1483:
1484: BEGIN
1485: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1486: application_short_name => 'MSC',
1487: statement_type => AD_DDL.CREATE_INDEX,
1488: statement =>
1489: 'create index MSC_ST_SUP_FENCES_N1_'||v_instance_code

Line 1487: statement_type => AD_DDL.CREATE_INDEX,

1483:
1484: BEGIN
1485: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1486: application_short_name => 'MSC',
1487: statement_type => AD_DDL.CREATE_INDEX,
1488: statement =>
1489: 'create index MSC_ST_SUP_FENCES_N1_'||v_instance_code
1490: ||' on MSC_ST_SUPPLIER_FLEX_FENCES '
1491: ||'(sr_instance_code, item_name,vendor_name,fence_days,organization_code,company_name,vendor_site_code) '

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

1508: IF v_safety_stk_enabled = SYS_YES THEN
1509:
1510: BEGIN
1511:
1512: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1513: application_short_name => 'MSC',
1514: statement_type => AD_DDL.CREATE_INDEX,
1515: statement =>
1516: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code

Line 1514: statement_type => AD_DDL.CREATE_INDEX,

1510: BEGIN
1511:
1512: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1513: application_short_name => 'MSC',
1514: statement_type => AD_DDL.CREATE_INDEX,
1515: statement =>
1516: 'create index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code
1517: ||' on MSC_ST_SAFETY_STOCKS '
1518: ||'(sr_instance_code,organization_code,item_name,period_start_date,company_name) '

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

1530: IF v_item_substitute_enabled = SYS_YES THEN
1531:
1532: BEGIN
1533:
1534: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1535: application_short_name => 'MSC',
1536: statement_type => AD_DDL.CREATE_INDEX,
1537: statement =>
1538: 'create index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code

Line 1536: statement_type => AD_DDL.CREATE_INDEX,

1532: BEGIN
1533:
1534: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1535: application_short_name => 'MSC',
1536: statement_type => AD_DDL.CREATE_INDEX,
1537: statement =>
1538: 'create index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code
1539: ||' on MSC_ST_ITEM_SUBSTITUTES '
1540: ||' (sr_instance_code,item_name,substitute_item_name,customer_name,'

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

1557: IF v_planners_enabled = SYS_YES THEN
1558:
1559: BEGIN
1560:
1561: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1562: application_short_name => 'MSC',
1563: statement_type => AD_DDL.CREATE_INDEX,
1564: statement =>
1565: 'create index MSC_ST_PLANNERS_N1_'||v_instance_code

Line 1563: statement_type => AD_DDL.CREATE_INDEX,

1559: BEGIN
1560:
1561: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1562: application_short_name => 'MSC',
1563: statement_type => AD_DDL.CREATE_INDEX,
1564: statement =>
1565: 'create index MSC_ST_PLANNERS_N1_'||v_instance_code
1566: ||' on MSC_ST_PLANNERS '
1567: ||'(sr_instance_code,organization_code,planner_code,company_name) '

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

1581:
1582: IF v_mat_sup_enabled = SYS_YES THEN
1583:
1584: BEGIN
1585: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1586: application_short_name => 'MSC',
1587: statement_type => AD_DDL.CREATE_INDEX,
1588: statement =>
1589: 'create index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code

Line 1587: statement_type => AD_DDL.CREATE_INDEX,

1583:
1584: BEGIN
1585: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1586: application_short_name => 'MSC',
1587: statement_type => AD_DDL.CREATE_INDEX,
1588: statement =>
1589: 'create index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code
1590: ||' on MSC_ST_JOB_OPERATION_NETWORKS '
1591: ||'(SR_INSTANCE_CODE, WIP_ENTITY_NAME, FROM_OPERATION_SEQ_CODE, TO_OPERATION_SEQ_CODE) '

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

1598: 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));
1599: END;
1600:
1601: BEGIN
1602: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1603: application_short_name => 'MSC',
1604: statement_type => AD_DDL.CREATE_INDEX,
1605: statement =>
1606: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code

Line 1604: statement_type => AD_DDL.CREATE_INDEX,

1600:
1601: BEGIN
1602: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1603: application_short_name => 'MSC',
1604: statement_type => AD_DDL.CREATE_INDEX,
1605: statement =>
1606: 'create index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code
1607: ||' on MSC_ST_JOB_OPERATIONS '
1608: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE ) '

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

1615: 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));
1616: END;
1617:
1618: BEGIN
1619: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1620: application_short_name => 'MSC',
1621: statement_type => AD_DDL.CREATE_INDEX,
1622: statement =>
1623: 'create index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code

Line 1621: statement_type => AD_DDL.CREATE_INDEX,

1617:
1618: BEGIN
1619: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1620: application_short_name => 'MSC',
1621: statement_type => AD_DDL.CREATE_INDEX,
1622: statement =>
1623: 'create index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code
1624: ||' on MSC_ST_JOB_REQUIREMENT_OPS '
1625: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, COMPONENT_NAME, PRIMARY_COMPONENT_NAME ) '

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

1632: 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));
1633: END;
1634:
1635: BEGIN
1636: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1637: application_short_name => 'MSC',
1638: statement_type => AD_DDL.CREATE_INDEX,
1639: statement =>
1640: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code

Line 1638: statement_type => AD_DDL.CREATE_INDEX,

1634:
1635: BEGIN
1636: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1637: application_short_name => 'MSC',
1638: statement_type => AD_DDL.CREATE_INDEX,
1639: statement =>
1640: 'create index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code
1641: ||' on MSC_ST_JOB_OP_RESOURCES '
1642: ||'(SR_INSTANCE_CODE, ORGANIZATION_CODE, WIP_ENTITY_NAME, OPERATION_SEQ_CODE, RESOURCE_SEQ_CODE, ALTERNATE_NUM, RESOURCE_CODE ) '

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

1654: IF v_cal_assignment_enabled = SYS_YES THEN
1655:
1656: BEGIN
1657:
1658: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1659: application_short_name => 'MSC',
1660: statement_type => AD_DDL.CREATE_INDEX,
1661: statement =>
1662: 'create index MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code

Line 1660: statement_type => AD_DDL.CREATE_INDEX,

1656: BEGIN
1657:
1658: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1659: application_short_name => 'MSC',
1660: statement_type => AD_DDL.CREATE_INDEX,
1661: statement =>
1662: 'create index MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code
1663: ||' on MSC_ST_CALENDAR_ASSIGNMENTS '
1664: ||'(sr_instance_code,association_type, calendar_code, calendar_type, partner_name, partner_site_code, organization_code, ship_method_code) '

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

1680: ELSIF p_batch_index = 'ITEM' THEN
1681:
1682: BEGIN
1683:
1684: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1685: application_short_name => 'MSC',
1686: statement_type => AD_DDL.CREATE_INDEX,
1687: statement =>
1688: 'create index MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code

Line 1686: statement_type => AD_DDL.CREATE_INDEX,

1682: BEGIN
1683:
1684: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1685: application_short_name => 'MSC',
1686: statement_type => AD_DDL.CREATE_INDEX,
1687: statement =>
1688: 'create index MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code
1689: ||' on MSC_ST_SYSTEM_ITEMS '
1690: ||' (sr_instance_code,batch_id,sr_inventory_item_id, deleted_flag) '

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

1704: ELSIF p_batch_index = 'SUPPLY' THEN
1705:
1706: BEGIN
1707:
1708: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1709: application_short_name => 'MSC',
1710: statement_type => AD_DDL.CREATE_INDEX,
1711: statement =>
1712: 'create index MSC_ST_SUPPLIES_N5_'||v_instance_code

Line 1710: statement_type => AD_DDL.CREATE_INDEX,

1706: BEGIN
1707:
1708: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1709: application_short_name => 'MSC',
1710: statement_type => AD_DDL.CREATE_INDEX,
1711: statement =>
1712: 'create index MSC_ST_SUPPLIES_N5_'||v_instance_code
1713: ||' on MSC_ST_SUPPLIES '
1714: ||' (batch_id, order_type, sr_instance_code, deleted_flag) '

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

1727: ELSIF p_batch_index = 'DEMAND' THEN
1728:
1729: BEGIN
1730:
1731: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1732: application_short_name => 'MSC',
1733: statement_type => AD_DDL.CREATE_INDEX,
1734: statement =>
1735: 'create index MSC_ST_DEMANDS_N3_'||v_instance_code

Line 1733: statement_type => AD_DDL.CREATE_INDEX,

1729: BEGIN
1730:
1731: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1732: application_short_name => 'MSC',
1733: statement_type => AD_DDL.CREATE_INDEX,
1734: statement =>
1735: 'create index MSC_ST_DEMANDS_N3_'||v_instance_code
1736: ||' on MSC_ST_DEMANDS '
1737: ||' (batch_id, origination_type, sr_instance_code, deleted_flag) '

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

1749:
1750: ELSIF p_batch_index = 'SO' THEN
1751:
1752: BEGIN
1753: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1754: application_short_name => 'MSC',
1755: statement_type => AD_DDL.CREATE_INDEX,
1756: statement =>
1757: 'create index MSC_ST_SO_N2_'||v_instance_code

Line 1755: statement_type => AD_DDL.CREATE_INDEX,

1751:
1752: BEGIN
1753: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1754: application_short_name => 'MSC',
1755: statement_type => AD_DDL.CREATE_INDEX,
1756: statement =>
1757: 'create index MSC_ST_SO_N2_'||v_instance_code
1758: ||' on MSC_ST_SALES_ORDERS '
1759: ||' (sales_order_number, batch_id ,sr_instance_code, deleted_flag) '

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

1767: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SO_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1768: END;
1769:
1770: BEGIN
1771: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1772: application_short_name => 'MSC',
1773: statement_type => AD_DDL.CREATE_INDEX,
1774: statement =>
1775: 'create index MSC_ST_SO_N3_'||v_instance_code

Line 1773: statement_type => AD_DDL.CREATE_INDEX,

1769:
1770: BEGIN
1771: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1772: application_short_name => 'MSC',
1773: statement_type => AD_DDL.CREATE_INDEX,
1774: statement =>
1775: 'create index MSC_ST_SO_N3_'||v_instance_code
1776: ||' on MSC_ST_SALES_ORDERS '
1777: ||' (sr_instance_code, batch_id , deleted_flag) '

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

1800:
1801: IF v_item_enabled = SYS_YES THEN
1802:
1803: BEGIN
1804: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1805: application_short_name => 'MSC',
1806: statement_type => AD_DDL.DROP_INDEX,
1807: statement =>
1808: 'drop index MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code,

Line 1806: statement_type => AD_DDL.DROP_INDEX,

1802:
1803: BEGIN
1804: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1805: application_short_name => 'MSC',
1806: statement_type => AD_DDL.DROP_INDEX,
1807: statement =>
1808: 'drop index MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code,
1809: object_name => 'MSC_ST_SYSTEM_ITEMS_N1_'||v_instance_code);
1810:

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

1815: 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));
1816: END;
1817:
1818: BEGIN
1819: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1820: application_short_name => 'MSC',
1821: statement_type => AD_DDL.DROP_INDEX,
1822: statement =>
1823: 'drop index MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code,

Line 1821: statement_type => AD_DDL.DROP_INDEX,

1817:
1818: BEGIN
1819: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1820: application_short_name => 'MSC',
1821: statement_type => AD_DDL.DROP_INDEX,
1822: statement =>
1823: 'drop index MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code,
1824: object_name => 'MSC_ST_SYSTEM_ITEMS_N2_'||v_instance_code);
1825:

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

1836:
1837: IF v_mat_sup_enabled = SYS_YES THEN
1838:
1839: BEGIN
1840: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1841: application_short_name => 'MSC',
1842: statement_type => AD_DDL.DROP_INDEX,
1843: statement =>
1844: 'drop index MSC_ST_SUPPLIES_N1_'||v_instance_code,

Line 1842: statement_type => AD_DDL.DROP_INDEX,

1838:
1839: BEGIN
1840: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1841: application_short_name => 'MSC',
1842: statement_type => AD_DDL.DROP_INDEX,
1843: statement =>
1844: 'drop index MSC_ST_SUPPLIES_N1_'||v_instance_code,
1845: object_name => 'MSC_ST_SUPPLIES_N1_'||v_instance_code);
1846:

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

1851: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1852: END;
1853:
1854: BEGIN
1855: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1856: application_short_name => 'MSC',
1857: statement_type => AD_DDL.DROP_INDEX,
1858: statement =>
1859: 'drop index MSC_ST_SUPPLIES_N2_'||v_instance_code,

Line 1857: statement_type => AD_DDL.DROP_INDEX,

1853:
1854: BEGIN
1855: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1856: application_short_name => 'MSC',
1857: statement_type => AD_DDL.DROP_INDEX,
1858: statement =>
1859: 'drop index MSC_ST_SUPPLIES_N2_'||v_instance_code,
1860: object_name => 'MSC_ST_SUPPLIES_N2_'||v_instance_code);
1861:

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

1865: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1866: END;
1867:
1868: BEGIN
1869: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1870: application_short_name => 'MSC',
1871: statement_type => AD_DDL.DROP_INDEX,
1872: statement =>
1873: 'drop index MSC_ST_SUPPLIES_N3_'||v_instance_code,

Line 1871: statement_type => AD_DDL.DROP_INDEX,

1867:
1868: BEGIN
1869: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1870: application_short_name => 'MSC',
1871: statement_type => AD_DDL.DROP_INDEX,
1872: statement =>
1873: 'drop index MSC_ST_SUPPLIES_N3_'||v_instance_code,
1874: object_name => 'MSC_ST_SUPPLIES_N3_'||v_instance_code);
1875:

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

1879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1880: END;
1881:
1882: BEGIN
1883: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1884: application_short_name => 'MSC',
1885: statement_type => AD_DDL.DROP_INDEX,
1886: statement =>
1887: 'drop index MSC_ST_SUPPLIES_N4_'||v_instance_code,

Line 1885: statement_type => AD_DDL.DROP_INDEX,

1881:
1882: BEGIN
1883: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1884: application_short_name => 'MSC',
1885: statement_type => AD_DDL.DROP_INDEX,
1886: statement =>
1887: 'drop index MSC_ST_SUPPLIES_N4_'||v_instance_code,
1888: object_name => 'MSC_ST_SUPPLIES_N4_'||v_instance_code);
1889:

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

1893: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SUPPLIES_N4_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1894: END;
1895:
1896: BEGIN
1897: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1898: application_short_name => 'MSC',
1899: statement_type => AD_DDL.DROP_INDEX,
1900: statement =>
1901: 'drop index MSC_ST_SUPPLIES_N5_'||v_instance_code,

Line 1899: statement_type => AD_DDL.DROP_INDEX,

1895:
1896: BEGIN
1897: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1898: application_short_name => 'MSC',
1899: statement_type => AD_DDL.DROP_INDEX,
1900: statement =>
1901: 'drop index MSC_ST_SUPPLIES_N5_'||v_instance_code,
1902: object_name => 'MSC_ST_SUPPLIES_N5_'||v_instance_code);
1903:

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

1914:
1915: IF v_mat_dmd_enabled = SYS_YES THEN
1916:
1917: BEGIN
1918: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1919: application_short_name => 'MSC',
1920: statement_type => AD_DDL.DROP_INDEX,
1921: statement =>
1922: 'drop index MSC_ST_DEMANDS_N1_'||v_instance_code,

Line 1920: statement_type => AD_DDL.DROP_INDEX,

1916:
1917: BEGIN
1918: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1919: application_short_name => 'MSC',
1920: statement_type => AD_DDL.DROP_INDEX,
1921: statement =>
1922: 'drop index MSC_ST_DEMANDS_N1_'||v_instance_code,
1923: object_name => 'MSC_ST_DEMANDS_N1_'||v_instance_code);
1924:

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

1928: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_DEMANDS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1929: END;
1930:
1931: BEGIN
1932: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1933: application_short_name => 'MSC',
1934: statement_type => AD_DDL.DROP_INDEX,
1935: statement =>
1936: 'drop index MSC_ST_DEMANDS_N2_'||v_instance_code,

Line 1934: statement_type => AD_DDL.DROP_INDEX,

1930:
1931: BEGIN
1932: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1933: application_short_name => 'MSC',
1934: statement_type => AD_DDL.DROP_INDEX,
1935: statement =>
1936: 'drop index MSC_ST_DEMANDS_N2_'||v_instance_code,
1937: object_name => 'MSC_ST_DEMANDS_N2_'||v_instance_code);
1938:

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

1942: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_DEMANDS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1943: END;
1944:
1945: BEGIN
1946: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1947: application_short_name => 'MSC',
1948: statement_type => AD_DDL.DROP_INDEX,
1949: statement =>
1950: 'drop index MSC_ST_DEMANDS_N3_'||v_instance_code,

Line 1948: statement_type => AD_DDL.DROP_INDEX,

1944:
1945: BEGIN
1946: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1947: application_short_name => 'MSC',
1948: statement_type => AD_DDL.DROP_INDEX,
1949: statement =>
1950: 'drop index MSC_ST_DEMANDS_N3_'||v_instance_code,
1951: object_name => 'MSC_ST_DEMANDS_N3_'||v_instance_code);
1952:

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

1957: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_DEMANDS_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1958: END;
1959:
1960: BEGIN
1961: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1962: application_short_name => 'MSC',
1963: statement_type => AD_DDL.DROP_INDEX,
1964: statement =>
1965: 'drop index MSC_ST_SO_N1_'||v_instance_code,

Line 1963: statement_type => AD_DDL.DROP_INDEX,

1959:
1960: BEGIN
1961: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1962: application_short_name => 'MSC',
1963: statement_type => AD_DDL.DROP_INDEX,
1964: statement =>
1965: 'drop index MSC_ST_SO_N1_'||v_instance_code,
1966: object_name => 'MSC_ST_SO_N1_'||v_instance_code);
1967:

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

1971: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SO_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1972: END;
1973:
1974: BEGIN
1975: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1976: application_short_name => 'MSC',
1977: statement_type => AD_DDL.DROP_INDEX,
1978: statement =>
1979: 'drop index MSC_ST_SO_N2_'||v_instance_code,

Line 1977: statement_type => AD_DDL.DROP_INDEX,

1973:
1974: BEGIN
1975: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1976: application_short_name => 'MSC',
1977: statement_type => AD_DDL.DROP_INDEX,
1978: statement =>
1979: 'drop index MSC_ST_SO_N2_'||v_instance_code,
1980: object_name => 'MSC_ST_SO_N2_'||v_instance_code);
1981:

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

1985: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_SO_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1986: END;
1987:
1988: BEGIN
1989: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1990: application_short_name => 'MSC',
1991: statement_type => AD_DDL.DROP_INDEX,
1992: statement =>
1993: 'drop index MSC_ST_SO_N3_'||v_instance_code,

Line 1991: statement_type => AD_DDL.DROP_INDEX,

1987:
1988: BEGIN
1989: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1990: application_short_name => 'MSC',
1991: statement_type => AD_DDL.DROP_INDEX,
1992: statement =>
1993: 'drop index MSC_ST_SO_N3_'||v_instance_code,
1994: object_name => 'MSC_ST_SO_N3_'||v_instance_code);
1995:

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

2005: END IF;
2006:
2007: IF v_reserve_enabled = SYS_YES THEN
2008: BEGIN
2009: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2010: application_short_name => 'MSC',
2011: statement_type => AD_DDL.DROP_INDEX,
2012: statement =>
2013: 'drop index MSC_ST_RESERVE_N1_'||v_instance_code,

Line 2011: statement_type => AD_DDL.DROP_INDEX,

2007: IF v_reserve_enabled = SYS_YES THEN
2008: BEGIN
2009: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2010: application_short_name => 'MSC',
2011: statement_type => AD_DDL.DROP_INDEX,
2012: statement =>
2013: 'drop index MSC_ST_RESERVE_N1_'||v_instance_code,
2014: object_name => 'MSC_ST_RESERVE_N1_'||v_instance_code);
2015:

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

2022:
2023: IF v_bom_enabled = SYS_YES THEN
2024:
2025: BEGIN
2026: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2027: application_short_name => 'MSC',
2028: statement_type => AD_DDL.DROP_INDEX,
2029: statement =>
2030: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,

Line 2028: statement_type => AD_DDL.DROP_INDEX,

2024:
2025: BEGIN
2026: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2027: application_short_name => 'MSC',
2028: statement_type => AD_DDL.DROP_INDEX,
2029: statement =>
2030: 'drop index MSC_ST_BOMS_N1_'||v_instance_code,
2031: object_name => 'MSC_ST_BOMS_N1_'||v_instance_code);
2032:

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

2036: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_BOMS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2037: END;
2038:
2039: BEGIN
2040: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2041: application_short_name => 'MSC',
2042: statement_type => AD_DDL.DROP_INDEX,
2043: statement =>
2044: 'drop index MSC_ST_BOM_COMP_N1_'||v_instance_code,

Line 2042: statement_type => AD_DDL.DROP_INDEX,

2038:
2039: BEGIN
2040: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2041: application_short_name => 'MSC',
2042: statement_type => AD_DDL.DROP_INDEX,
2043: statement =>
2044: 'drop index MSC_ST_BOM_COMP_N1_'||v_instance_code,
2045: object_name => 'MSC_ST_BOM_COMP_N1_'||v_instance_code);
2046:

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

2050: 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));
2051: END;
2052:
2053: BEGIN
2054: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2055: application_short_name => 'MSC',
2056: statement_type => AD_DDL.DROP_INDEX,
2057: statement =>
2058: 'drop index MSC_ST_COMP_SUB_N1_'||v_instance_code,

Line 2056: statement_type => AD_DDL.DROP_INDEX,

2052:
2053: BEGIN
2054: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2055: application_short_name => 'MSC',
2056: statement_type => AD_DDL.DROP_INDEX,
2057: statement =>
2058: 'drop index MSC_ST_COMP_SUB_N1_'||v_instance_code,
2059: object_name => 'MSC_ST_COMP_SUB_N1_'||v_instance_code);
2060:

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

2066: END;
2067:
2068: -- Added for Co Products (OSFM Integration --
2069: BEGIN
2070: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2071: application_short_name => 'MSC',
2072: statement_type => AD_DDL.DROP_INDEX,
2073: statement =>
2074: 'drop index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code,

Line 2072: statement_type => AD_DDL.DROP_INDEX,

2068: -- Added for Co Products (OSFM Integration --
2069: BEGIN
2070: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2071: application_short_name => 'MSC',
2072: statement_type => AD_DDL.DROP_INDEX,
2073: statement =>
2074: 'drop index MSC_ST_CO_PRODUCTS_N1_'||v_instance_code,
2075: object_name => 'MSC_ST_CO_PRODUCTS_N1_'||v_instance_code);
2076:

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

2084:
2085: IF v_rtg_enabled = SYS_YES THEN
2086:
2087: BEGIN
2088: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2089: application_short_name => 'MSC',
2090: statement_type => AD_DDL.DROP_INDEX,
2091: statement =>
2092: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,

Line 2090: statement_type => AD_DDL.DROP_INDEX,

2086:
2087: BEGIN
2088: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2089: application_short_name => 'MSC',
2090: statement_type => AD_DDL.DROP_INDEX,
2091: statement =>
2092: 'drop index MSC_ST_ROUTINGS_N1_'||v_instance_code,
2093: object_name => 'MSC_ST_ROUTINGS_N1_'||v_instance_code);
2094:

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

2098: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ROUTINGS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2099: END;
2100:
2101: BEGIN
2102: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2103: application_short_name => 'MSC',
2104: statement_type => AD_DDL.DROP_INDEX,
2105: statement =>
2106: 'drop index MSC_ST_ROUTING_OPER_N1_'||v_instance_code,

Line 2104: statement_type => AD_DDL.DROP_INDEX,

2100:
2101: BEGIN
2102: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2103: application_short_name => 'MSC',
2104: statement_type => AD_DDL.DROP_INDEX,
2105: statement =>
2106: 'drop index MSC_ST_ROUTING_OPER_N1_'||v_instance_code,
2107: object_name => 'MSC_ST_ROUTING_OPER_N1_'||v_instance_code);
2108:

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

2113: 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));
2114: END;
2115:
2116: BEGIN
2117: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2118: application_short_name => 'MSC',
2119: statement_type => AD_DDL.DROP_INDEX,
2120: statement =>
2121: 'drop index MSC_ST_OPER_RES_N1_'||v_instance_code,

Line 2119: statement_type => AD_DDL.DROP_INDEX,

2115:
2116: BEGIN
2117: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2118: application_short_name => 'MSC',
2119: statement_type => AD_DDL.DROP_INDEX,
2120: statement =>
2121: 'drop index MSC_ST_OPER_RES_N1_'||v_instance_code,
2122: object_name => 'MSC_ST_OPER_RES_N1_'||v_instance_code);
2123:

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

2129: END;
2130:
2131: -- Added for Operation Networks (OSFM Integration)--
2132: BEGIN
2133: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2134: application_short_name => 'MSC',
2135: statement_type => AD_DDL.DROP_INDEX,
2136: statement =>
2137: 'drop index MSC_ST_OPER_NTWK_N1_'||v_instance_code,

Line 2135: statement_type => AD_DDL.DROP_INDEX,

2131: -- Added for Operation Networks (OSFM Integration)--
2132: BEGIN
2133: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2134: application_short_name => 'MSC',
2135: statement_type => AD_DDL.DROP_INDEX,
2136: statement =>
2137: 'drop index MSC_ST_OPER_NTWK_N1_'||v_instance_code,
2138: object_name => 'MSC_ST_OPER_NTWK_N1_'||v_instance_code);
2139:

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

2149:
2150: IF v_item_cat_enabled = SYS_YES THEN
2151:
2152: BEGIN
2153: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2154: application_short_name => 'MSC',
2155: statement_type => AD_DDL.DROP_INDEX,
2156: statement =>
2157: 'drop index MSC_ST_ITEM_CAT_N1_'||v_instance_code,

Line 2155: statement_type => AD_DDL.DROP_INDEX,

2151:
2152: BEGIN
2153: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2154: application_short_name => 'MSC',
2155: statement_type => AD_DDL.DROP_INDEX,
2156: statement =>
2157: 'drop index MSC_ST_ITEM_CAT_N1_'||v_instance_code,
2158: object_name => 'MSC_ST_ITEM_CAT_N1_'||v_instance_code);
2159:

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

2164: 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));
2165: END;
2166:
2167: BEGIN
2168: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2169: application_short_name => 'MSC',
2170: statement_type => AD_DDL.DROP_INDEX,
2171: statement =>
2172: 'drop index MSC_ST_ITEM_CAT_N2_'||v_instance_code,

Line 2170: statement_type => AD_DDL.DROP_INDEX,

2166:
2167: BEGIN
2168: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2169: application_short_name => 'MSC',
2170: statement_type => AD_DDL.DROP_INDEX,
2171: statement =>
2172: 'drop index MSC_ST_ITEM_CAT_N2_'||v_instance_code,
2173: object_name => 'MSC_ST_ITEM_CAT_N2_'||v_instance_code);
2174:

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

2183:
2184: IF v_resources_enabled = SYS_YES THEN
2185:
2186: BEGIN
2187: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2188: application_short_name => 'MSC',
2189: statement_type => AD_DDL.DROP_INDEX,
2190: statement =>
2191: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,

Line 2189: statement_type => AD_DDL.DROP_INDEX,

2185:
2186: BEGIN
2187: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2188: application_short_name => 'MSC',
2189: statement_type => AD_DDL.DROP_INDEX,
2190: statement =>
2191: 'drop index MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code,
2192: object_name => 'MSC_ST_RESOURCE_GROUPS_N1_'||v_instance_code);
2193:

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

2198: 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));
2199: END;
2200:
2201: BEGIN
2202: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2203: application_short_name => 'MSC',
2204: statement_type => AD_DDL.DROP_INDEX,
2205: statement =>
2206: 'drop index MSC_ST_DEPT_RES_N1_'||v_instance_code,

Line 2204: statement_type => AD_DDL.DROP_INDEX,

2200:
2201: BEGIN
2202: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2203: application_short_name => 'MSC',
2204: statement_type => AD_DDL.DROP_INDEX,
2205: statement =>
2206: 'drop index MSC_ST_DEPT_RES_N1_'||v_instance_code,
2207: object_name => 'MSC_ST_DEPT_RES_N1_'||v_instance_code);
2208:

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

2213: 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));
2214: END;
2215:
2216: BEGIN
2217: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2218: application_short_name => 'MSC',
2219: statement_type => AD_DDL.DROP_INDEX,
2220: statement =>
2221: 'drop index MSC_ST_RES_SHIFTS_N1_'||v_instance_code,

Line 2219: statement_type => AD_DDL.DROP_INDEX,

2215:
2216: BEGIN
2217: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2218: application_short_name => 'MSC',
2219: statement_type => AD_DDL.DROP_INDEX,
2220: statement =>
2221: 'drop index MSC_ST_RES_SHIFTS_N1_'||v_instance_code,
2222: object_name => 'MSC_ST_RES_SHIFTS_N1_'||v_instance_code);
2223:

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

2228: 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));
2229: END;
2230:
2231: BEGIN
2232: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2233: application_short_name => 'MSC',
2234: statement_type => AD_DDL.DROP_INDEX,
2235: statement =>
2236: 'drop index MSC_ST_RES_CHANGES_N1_'||v_instance_code,

Line 2234: statement_type => AD_DDL.DROP_INDEX,

2230:
2231: BEGIN
2232: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2233: application_short_name => 'MSC',
2234: statement_type => AD_DDL.DROP_INDEX,
2235: statement =>
2236: 'drop index MSC_ST_RES_CHANGES_N1_'||v_instance_code,
2237: object_name => 'MSC_ST_RES_CHANGES_N1_'||v_instance_code);
2238:

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

2250: IF v_project_enabled = SYS_YES THEN
2251:
2252: BEGIN
2253:
2254: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2255: application_short_name => 'MSC',
2256: statement_type => AD_DDL.DROP_INDEX,
2257: statement =>
2258: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,

Line 2256: statement_type => AD_DDL.DROP_INDEX,

2252: BEGIN
2253:
2254: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2255: application_short_name => 'MSC',
2256: statement_type => AD_DDL.DROP_INDEX,
2257: statement =>
2258: 'drop index MSC_ST_PROJECT_TASKS_N1_'||v_instance_code,
2259: object_name => 'MSC_ST_PROJECT_TASKS_N1_'||v_instance_code);
2260:

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

2270:
2271: IF v_dmd_class_enabled = SYS_YES THEN
2272:
2273: BEGIN
2274: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2275: application_short_name => 'MSC',
2276: statement_type => AD_DDL.DROP_INDEX,
2277: statement =>
2278: 'drop index MSC_ST_DMD_CLASS_N1_'||v_instance_code,

Line 2276: statement_type => AD_DDL.DROP_INDEX,

2272:
2273: BEGIN
2274: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2275: application_short_name => 'MSC',
2276: statement_type => AD_DDL.DROP_INDEX,
2277: statement =>
2278: 'drop index MSC_ST_DMD_CLASS_N1_'||v_instance_code,
2279: object_name => 'MSC_ST_DMD_CLASS_N1_'||v_instance_code);
2280:

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

2288:
2289: IF v_tp_enabled = SYS_YES THEN
2290:
2291: BEGIN
2292: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2293: application_short_name => 'MSC',
2294: statement_type => AD_DDL.DROP_INDEX,
2295: statement =>
2296: 'drop index MSC_ST_TRADING_PART_N1_'||v_instance_code,

Line 2294: statement_type => AD_DDL.DROP_INDEX,

2290:
2291: BEGIN
2292: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2293: application_short_name => 'MSC',
2294: statement_type => AD_DDL.DROP_INDEX,
2295: statement =>
2296: 'drop index MSC_ST_TRADING_PART_N1_'||v_instance_code,
2297: object_name => 'MSC_ST_TRADING_PART_N1_'||v_instance_code);
2298:

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

2303: 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));
2304: END;
2305:
2306: BEGIN
2307: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2308: application_short_name => 'MSC',
2309: statement_type => AD_DDL.DROP_INDEX,
2310: statement =>
2311: 'drop index MSC_ST_TRADING_PART_N2_'||v_instance_code,

Line 2309: statement_type => AD_DDL.DROP_INDEX,

2305:
2306: BEGIN
2307: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2308: application_short_name => 'MSC',
2309: statement_type => AD_DDL.DROP_INDEX,
2310: statement =>
2311: 'drop index MSC_ST_TRADING_PART_N2_'||v_instance_code,
2312: object_name => 'MSC_ST_TRADING_PART_N2_'||v_instance_code);
2313:

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

2318: 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));
2319: END;
2320:
2321: BEGIN
2322: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2323: application_short_name => 'MSC',
2324: statement_type => AD_DDL.DROP_INDEX,
2325: statement =>
2326: 'drop index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code,

Line 2324: statement_type => AD_DDL.DROP_INDEX,

2320:
2321: BEGIN
2322: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2323: application_short_name => 'MSC',
2324: statement_type => AD_DDL.DROP_INDEX,
2325: statement =>
2326: 'drop index MSC_ST_TRD_PART_SITES_N1_'||v_instance_code,
2327: object_name => 'MSC_ST_TRD_PART_SITES_N1_'||v_instance_code);
2328:

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

2333: 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));
2334: END;
2335:
2336: BEGIN
2337: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2338: application_short_name => 'MSC',
2339: statement_type => AD_DDL.DROP_INDEX,
2340: statement =>
2341: 'drop index MSC_ST_SUB_INV_N1_'||v_instance_code,

Line 2339: statement_type => AD_DDL.DROP_INDEX,

2335:
2336: BEGIN
2337: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2338: application_short_name => 'MSC',
2339: statement_type => AD_DDL.DROP_INDEX,
2340: statement =>
2341: 'drop index MSC_ST_SUB_INV_N1_'||v_instance_code,
2342: object_name => 'MSC_ST_SUB_INV_N1_'||v_instance_code);
2343:

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

2348: 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));
2349: END;
2350:
2351: BEGIN
2352: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2353: application_short_name => 'MSC',
2354: statement_type => AD_DDL.DROP_INDEX,
2355: statement =>
2356: 'drop index MSC_ST_LOC_ASC_N1_'||v_instance_code,

Line 2354: statement_type => AD_DDL.DROP_INDEX,

2350:
2351: BEGIN
2352: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2353: application_short_name => 'MSC',
2354: statement_type => AD_DDL.DROP_INDEX,
2355: statement =>
2356: 'drop index MSC_ST_LOC_ASC_N1_'||v_instance_code,
2357: object_name => 'MSC_ST_LOC_ASC_N1_'||v_instance_code);
2358:

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

2363: 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));
2364: END;
2365:
2366: BEGIN
2367: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2368: application_short_name => 'MSC',
2369: statement_type => AD_DDL.DROP_INDEX,
2370: statement =>
2371: 'drop index MSC_ST_PART_CONT_N1_'||v_instance_code,

Line 2369: statement_type => AD_DDL.DROP_INDEX,

2365:
2366: BEGIN
2367: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2368: application_short_name => 'MSC',
2369: statement_type => AD_DDL.DROP_INDEX,
2370: statement =>
2371: 'drop index MSC_ST_PART_CONT_N1_'||v_instance_code,
2372: object_name => 'MSC_ST_PART_CONT_N1_'||v_instance_code);
2373:

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

2380: -- For Aeroexchange
2381: -- Drop index of MSC_ST_GROUP_COMPANIES
2382:
2383: BEGIN
2384: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2385: application_short_name => 'MSC',
2386: statement_type => AD_DDL.DROP_INDEX,
2387: statement =>
2388: 'drop index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code,

Line 2386: statement_type => AD_DDL.DROP_INDEX,

2382:
2383: BEGIN
2384: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2385: application_short_name => 'MSC',
2386: statement_type => AD_DDL.DROP_INDEX,
2387: statement =>
2388: 'drop index MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code,
2389: object_name => 'MSC_ST_GROUP_COMPANIES_N1_'||v_instance_code);
2390:

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

2397:
2398:
2399: ---- Drop index of MSC_ST_GROUPS
2400: BEGIN
2401: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2402: application_short_name => 'MSC',
2403: statement_type => AD_DDL.DROP_INDEX,
2404: statement =>
2405: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,

Line 2403: statement_type => AD_DDL.DROP_INDEX,

2399: ---- Drop index of MSC_ST_GROUPS
2400: BEGIN
2401: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2402: application_short_name => 'MSC',
2403: statement_type => AD_DDL.DROP_INDEX,
2404: statement =>
2405: 'drop index MSC_ST_GROUPS_N1_'||v_instance_code,
2406: object_name => 'MSC_ST_GROUPS_N1_'||v_instance_code);
2407:

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

2418: -- For bug fix 2379391, dropping the indexes for MSC_ST_ITEM_CUSTOMERS
2419: IF v_item_cst_enabled = SYS_YES THEN
2420:
2421: BEGIN
2422: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2423: application_short_name => 'MSC',
2424: statement_type => AD_DDL.DROP_INDEX,
2425: statement =>
2426: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,

Line 2424: statement_type => AD_DDL.DROP_INDEX,

2420:
2421: BEGIN
2422: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2423: application_short_name => 'MSC',
2424: statement_type => AD_DDL.DROP_INDEX,
2425: statement =>
2426: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,
2427: object_name => 'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2428:

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

2433: 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));
2434: END;
2435:
2436: BEGIN
2437: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2438: application_short_name => 'MSC',
2439: statement_type => AD_DDL.DROP_INDEX,
2440: statement =>
2441: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,

Line 2439: statement_type => AD_DDL.DROP_INDEX,

2435:
2436: BEGIN
2437: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2438: application_short_name => 'MSC',
2439: statement_type => AD_DDL.DROP_INDEX,
2440: statement =>
2441: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,
2442: object_name => 'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2443:

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

2454:
2455: IF v_ship_mthd_enabled = SYS_YES THEN
2456:
2457: BEGIN
2458: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2459: application_short_name => 'MSC',
2460: statement_type => AD_DDL.DROP_INDEX,
2461: statement =>
2462: 'drop index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code,

Line 2460: statement_type => AD_DDL.DROP_INDEX,

2456:
2457: BEGIN
2458: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2459: application_short_name => 'MSC',
2460: statement_type => AD_DDL.DROP_INDEX,
2461: statement =>
2462: 'drop index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code,
2463: object_name => 'MSC_ST_INTERORG_SHIP_N1_'||v_instance_code);
2464:

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

2472:
2473: IF v_sourcing_enabled = SYS_YES THEN
2474:
2475: BEGIN
2476: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2477: application_short_name => 'MSC',
2478: statement_type => AD_DDL.DROP_INDEX,
2479: statement =>
2480: 'drop index MSC_ST_ITEM_SRC_N1_'||v_instance_code,

Line 2478: statement_type => AD_DDL.DROP_INDEX,

2474:
2475: BEGIN
2476: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2477: application_short_name => 'MSC',
2478: statement_type => AD_DDL.DROP_INDEX,
2479: statement =>
2480: 'drop index MSC_ST_ITEM_SRC_N1_'||v_instance_code,
2481: object_name => 'MSC_ST_ITEM_SRC_N1_'||v_instance_code);
2482:

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

2487: 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));
2488: END;
2489:
2490: BEGIN
2491: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2492: application_short_name => 'MSC',
2493: statement_type => AD_DDL.DROP_INDEX,
2494: statement =>
2495: 'drop index MSC_ST_REGIONS_N1_'||v_instance_code,

Line 2493: statement_type => AD_DDL.DROP_INDEX,

2489:
2490: BEGIN
2491: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2492: application_short_name => 'MSC',
2493: statement_type => AD_DDL.DROP_INDEX,
2494: statement =>
2495: 'drop index MSC_ST_REGIONS_N1_'||v_instance_code,
2496: object_name => 'MSC_ST_REGIONS_N1_'||v_instance_code);
2497:

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

2502: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_REGIONS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2503: END;
2504:
2505: BEGIN
2506: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2507: application_short_name => 'MSC',
2508: statement_type => AD_DDL.DROP_INDEX,
2509: statement =>
2510: 'drop index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code,

Line 2508: statement_type => AD_DDL.DROP_INDEX,

2504:
2505: BEGIN
2506: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2507: application_short_name => 'MSC',
2508: statement_type => AD_DDL.DROP_INDEX,
2509: statement =>
2510: 'drop index MSC_ST_ZONE_REGIONS_N1_'||v_instance_code,
2511: object_name => 'MSC_ST_ZONE_REGIONS_N1_'||v_instance_code);
2512:

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

2517: 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));
2518: END;
2519:
2520: BEGIN
2521: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2522: application_short_name => 'MSC',
2523: statement_type => AD_DDL.DROP_INDEX,
2524: statement =>
2525: 'drop index MSC_ST_REGION_LOC_N1_'||v_instance_code,

Line 2523: statement_type => AD_DDL.DROP_INDEX,

2519:
2520: BEGIN
2521: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2522: application_short_name => 'MSC',
2523: statement_type => AD_DDL.DROP_INDEX,
2524: statement =>
2525: 'drop index MSC_ST_REGION_LOC_N1_'||v_instance_code,
2526: object_name => 'MSC_ST_REGION_LOC_N1_'||v_instance_code);
2527:

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

2532: 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));
2533: END;
2534:
2535: BEGIN
2536: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2537: application_short_name => 'MSC',
2538: statement_type => AD_DDL.DROP_INDEX,
2539: statement =>
2540: 'drop index MSC_ST_REGION_SITE_N1_'||v_instance_code,

Line 2538: statement_type => AD_DDL.DROP_INDEX,

2534:
2535: BEGIN
2536: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2537: application_short_name => 'MSC',
2538: statement_type => AD_DDL.DROP_INDEX,
2539: statement =>
2540: 'drop index MSC_ST_REGION_SITE_N1_'||v_instance_code,
2541: object_name => 'MSC_ST_REGION_SITE_N1_'||v_instance_code);
2542:

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

2551:
2552: IF v_res_dmd_enabled = SYS_YES THEN
2553:
2554: BEGIN
2555: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2556: application_short_name => 'MSC',
2557: statement_type => AD_DDL.DROP_INDEX,
2558: statement =>
2559: 'drop index MSC_ST_RES_REQ_N1_'||v_instance_code,

Line 2557: statement_type => AD_DDL.DROP_INDEX,

2553:
2554: BEGIN
2555: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2556: application_short_name => 'MSC',
2557: statement_type => AD_DDL.DROP_INDEX,
2558: statement =>
2559: 'drop index MSC_ST_RES_REQ_N1_'||v_instance_code,
2560: object_name => 'MSC_ST_RES_REQ_N1_'||v_instance_code);
2561:

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

2569:
2570: IF v_sup_cap_enabled = SYS_YES THEN
2571:
2572: BEGIN
2573: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2574: application_short_name => 'MSC',
2575: statement_type => AD_DDL.DROP_INDEX,
2576: statement =>
2577: 'drop index MSC_ST_ITEM_SUP_N1_'||v_instance_code,

Line 2575: statement_type => AD_DDL.DROP_INDEX,

2571:
2572: BEGIN
2573: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2574: application_short_name => 'MSC',
2575: statement_type => AD_DDL.DROP_INDEX,
2576: statement =>
2577: 'drop index MSC_ST_ITEM_SUP_N1_'||v_instance_code,
2578: object_name => 'MSC_ST_ITEM_SUP_N1_'||v_instance_code);
2579:

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

2584: 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));
2585: END;
2586:
2587: BEGIN
2588: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2589: application_short_name => 'MSC',
2590: statement_type => AD_DDL.DROP_INDEX,
2591: statement =>
2592: 'drop index MSC_ST_SUP_CAP_N1_'||v_instance_code,

Line 2590: statement_type => AD_DDL.DROP_INDEX,

2586:
2587: BEGIN
2588: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2589: application_short_name => 'MSC',
2590: statement_type => AD_DDL.DROP_INDEX,
2591: statement =>
2592: 'drop index MSC_ST_SUP_CAP_N1_'||v_instance_code,
2593: object_name => 'MSC_ST_SUP_CAP_N1_'||v_instance_code);
2594:

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

2599: 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));
2600: END;
2601:
2602: BEGIN
2603: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2604: application_short_name => 'MSC',
2605: statement_type => AD_DDL.DROP_INDEX,
2606: statement =>
2607: 'drop index MSC_ST_SUP_FENCES_N1_'||v_instance_code,

Line 2605: statement_type => AD_DDL.DROP_INDEX,

2601:
2602: BEGIN
2603: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2604: application_short_name => 'MSC',
2605: statement_type => AD_DDL.DROP_INDEX,
2606: statement =>
2607: 'drop index MSC_ST_SUP_FENCES_N1_'||v_instance_code,
2608: object_name => 'MSC_ST_SUP_FENCES_N1_'||v_instance_code);
2609:

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

2619:
2620: IF v_safety_stk_enabled = SYS_YES THEN
2621:
2622: BEGIN
2623: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2624: application_short_name => 'MSC',
2625: statement_type => AD_DDL.DROP_INDEX,
2626: statement =>
2627: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,

Line 2625: statement_type => AD_DDL.DROP_INDEX,

2621:
2622: BEGIN
2623: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2624: application_short_name => 'MSC',
2625: statement_type => AD_DDL.DROP_INDEX,
2626: statement =>
2627: 'drop index MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code,
2628: object_name => 'MSC_ST_SAFETY_STOCKS_N1_'||v_instance_code);
2629:

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

2639:
2640: IF v_item_substitute_enabled = SYS_YES THEN
2641:
2642: BEGIN
2643: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2644: application_short_name => 'MSC',
2645: statement_type => AD_DDL.DROP_INDEX,
2646: statement =>
2647: 'drop index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code,

Line 2645: statement_type => AD_DDL.DROP_INDEX,

2641:
2642: BEGIN
2643: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2644: application_short_name => 'MSC',
2645: statement_type => AD_DDL.DROP_INDEX,
2646: statement =>
2647: 'drop index MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code,
2648: object_name => 'MSC_ST_ITEM_SUBSTITUTES_N1_'||v_instance_code);
2649:

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

2658:
2659: IF v_planners_enabled = SYS_YES THEN
2660:
2661: BEGIN
2662: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2663: application_short_name => 'MSC',
2664: statement_type => AD_DDL.DROP_INDEX,
2665: statement =>
2666: 'drop index MSC_ST_PLANNERS_N1_'||v_instance_code,

Line 2664: statement_type => AD_DDL.DROP_INDEX,

2660:
2661: BEGIN
2662: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2663: application_short_name => 'MSC',
2664: statement_type => AD_DDL.DROP_INDEX,
2665: statement =>
2666: 'drop index MSC_ST_PLANNERS_N1_'||v_instance_code,
2667: object_name => 'MSC_ST_PLANNERS_N1_'||v_instance_code);
2668:

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

2677:
2678: IF v_uom_class_enabled = SYS_YES THEN
2679:
2680: BEGIN
2681: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2682: application_short_name => 'MSC',
2683: statement_type => AD_DDL.DROP_INDEX,
2684: statement =>
2685: 'drop index MSC_ST_UOM_CLS_CONV_N1_'||v_instance_code,

Line 2683: statement_type => AD_DDL.DROP_INDEX,

2679:
2680: BEGIN
2681: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2682: application_short_name => 'MSC',
2683: statement_type => AD_DDL.DROP_INDEX,
2684: statement =>
2685: 'drop index MSC_ST_UOM_CLS_CONV_N1_'||v_instance_code,
2686: object_name => 'MSC_ST_UOM_CLS_CONV_N1_'||v_instance_code);
2687:

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

2696:
2697: IF v_mat_sup_enabled = SYS_YES THEN
2698:
2699: BEGIN
2700: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2701: application_short_name => 'MSC',
2702: statement_type => AD_DDL.DROP_INDEX,
2703: statement =>
2704: 'drop index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code,

Line 2702: statement_type => AD_DDL.DROP_INDEX,

2698:
2699: BEGIN
2700: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2701: application_short_name => 'MSC',
2702: statement_type => AD_DDL.DROP_INDEX,
2703: statement =>
2704: 'drop index MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code,
2705: object_name => 'MSC_ST_JOB_OP_NETWORKS_N1_'||v_instance_code);
2706:

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

2711: 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));
2712: END;
2713:
2714: BEGIN
2715: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2716: application_short_name => 'MSC',
2717: statement_type => AD_DDL.DROP_INDEX,
2718: statement =>
2719: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,

Line 2717: statement_type => AD_DDL.DROP_INDEX,

2713:
2714: BEGIN
2715: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2716: application_short_name => 'MSC',
2717: statement_type => AD_DDL.DROP_INDEX,
2718: statement =>
2719: 'drop index MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code,
2720: object_name => 'MSC_ST_JOB_OPERATIONS_N1_'||v_instance_code);
2721:

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

2726: 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));
2727: END;
2728:
2729: BEGIN
2730: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2731: application_short_name => 'MSC',
2732: statement_type => AD_DDL.DROP_INDEX,
2733: statement =>
2734: 'drop index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code,

Line 2732: statement_type => AD_DDL.DROP_INDEX,

2728:
2729: BEGIN
2730: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2731: application_short_name => 'MSC',
2732: statement_type => AD_DDL.DROP_INDEX,
2733: statement =>
2734: 'drop index MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code,
2735: object_name => 'MSC_ST_JOB_REQ_OPS_N1_'||v_instance_code);
2736:

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

2741: 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));
2742: END;
2743:
2744: BEGIN
2745: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2746: application_short_name => 'MSC',
2747: statement_type => AD_DDL.DROP_INDEX,
2748: statement =>
2749: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,

Line 2747: statement_type => AD_DDL.DROP_INDEX,

2743:
2744: BEGIN
2745: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2746: application_short_name => 'MSC',
2747: statement_type => AD_DDL.DROP_INDEX,
2748: statement =>
2749: 'drop index MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code,
2750: object_name => 'MSC_ST_JOB_OP_RESOURCES_N1_'||v_instance_code);
2751:

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

2760:
2761: IF v_cal_assignment_enabled = SYS_YES THEN
2762:
2763: BEGIN
2764: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2765: application_short_name => 'MSC',
2766: statement_type => AD_DDL.DROP_INDEX,
2767: statement =>
2768: 'drop index MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code,

Line 2766: statement_type => AD_DDL.DROP_INDEX,

2762:
2763: BEGIN
2764: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2765: application_short_name => 'MSC',
2766: statement_type => AD_DDL.DROP_INDEX,
2767: statement =>
2768: 'drop index MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code,
2769: object_name => 'MSC_ST_CAL_ASSIGNMENTS_N1_'||v_instance_code);
2770: