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_SCN_UTILS dependencies on MFG_LOOKUPS

Line 27: from mfg_lookups

23:
24:
25: /************
26: select lookup_code, meaning
27: from mfg_lookups
28: where lookup_type='MSC_PROCESS_ACTIVITY_TYPES'
29:
30: LOOKUP_CODE MEANING
31: ----------- -----------------------------------

Line 111: 'from mfg_lookups '||

107: DISPLAY_NAME,
108: PARAM_VERSION)
109: VALUES(1,'LAUNCH_SNAPSHOT','NUMBER','FULL',2,
110: 'select decode(lookup_code, 1, ''FULL'',2,''NO'',3,''DP_ONLY'') hidden, meaning display '||
111: 'from mfg_lookups '||
112: 'where lookup_type = ''MSC_LAUNCH_SNAPSHOT''',
113: 1,SYSDATE,'Y','Y','Launch Snapshot',p_version);
114:
115: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

Line 129: 'from mfg_lookups '||

125: DISPLAY_NAME,
126: PARAM_VERSION)
127: VALUES(1,'LAUNCH_PLANNER','NUMBER','Y',3,
128: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display '||
129: 'from mfg_lookups '||
130: 'where lookup_type = ''SYS_YES_NO''',
131: 1,SYSDATE,'Y','Y','Launch Planner',p_version);
132:
133:

Line 163: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

159: DISPLAYED,
160: DISPLAY_NAME,
161: PARAM_VERSION)
162: VALUES(1,'ARCHIVE_FLAG','VARCHAR2','N',5,
163: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
164: 1,sysdate,'Y','Y','Archive Plan Summary',p_version);
165:
166:
167: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

Line 181: 'from mfg_lookups '||

177: DISPLAY_NAME,
178: PARAM_VERSION)
179: VALUES(1,'ENABLE_24X7ATP','NUMBER',NULL,6,
180: 'select decode(lookup_code, 1, ''YES_PURGE'',2,''NO'',3,''YES_NO_PURGE'') hidden, meaning display '||
181: 'from mfg_lookups '||
182: 'where lookup_type = ''MSC_24X7_PURGE''',
183: 1,SYSDATE,'Y','Y','Enable 24x7ATP',p_version);
184:
185:

Line 200: 'from mfg_lookups '||

196: DISPLAY_NAME,
197: PARAM_VERSION)
198: VALUES(1,'RELEASE_RESCHEDULES','NUMBER','N',7,
199: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display '||
200: 'from mfg_lookups '||
201: 'where lookup_type = ''SYS_YES_NO''',
202: 1,SYSDATE,'Y','Y','Release Reschedules',p_version);
203:
204: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

Line 218: 'from mfg_lookups '||

214: DISPLAY_NAME,
215: PARAM_VERSION)
216: VALUES(1,'SNAP_STATIC_ENTITIES','NUMBER','Y',8,
217: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display '||
218: 'from mfg_lookups '||
219: 'where lookup_type = ''SYS_YES_NO''',
220: 1,SYSDATE,'Y','Y','Snapshot Static Entities',p_version);
221:
222: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

Line 264: 'from mfg_lookups '||

260: DISPLAY_NAME,
261: PARAM_VERSION)
262: VALUES(6,'SOLVE_IN_SERVER','VARCHAR2','Y',2,
263: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display '||
264: 'from mfg_lookups '||
265: 'where lookup_type = ''SYS_YES_NO''',
266: 1,SYSDATE,'Y','Y','Solve in Server',p_version);
267:
268: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

Line 281: 'select decode(lookup_code, 1, ''SOP'',2,''SCRM'',3,''SNO'') hidden, meaning display from mfg_lookups where lookup_type=''MSC_SCN_SOP_PROFILE''',

277: DISPLAYED,
278: DISPLAY_NAME,
279: PARAM_VERSION)
280: VALUES(6,'appProfile','VARCHAR2',NULL,3,
281: 'select decode(lookup_code, 1, ''SOP'',2,''SCRM'',3,''SNO'') hidden, meaning display from mfg_lookups where lookup_type=''MSC_SCN_SOP_PROFILE''',
282: 1,SYSDATE,'Y','Y','AppProfile',p_version);
283:
284:
285:

Line 334: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

330: DISPLAYED,
331: DISPLAY_NAME,
332: PARAM_VERSION)
333: VALUES(4,'ARCHIVE_FLAG','VARCHAR2','N',3,
334: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
335: 1,sysdate,'Y','Y','Archive Plan Summary',p_version);
336:
337:
338: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

Line 413: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

409: DISPLAYED,
410: DISPLAY_NAME,
411: PARAM_VERSION)
412: VALUES(11,'ODS_PURGE_OPTION','VARCHAR2','Y',5,
413: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
414: 1,SYSDATE,'Y','Y','Purge Previously Collected Data',p_version);
415:
416: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
417: NAME,

Line 430: 'from mfg_lookups WHERE lookup_type = ''PARTIAL_YES_NO''',

426: DISPLAY_NAME,
427: PARAM_VERSION)
428: VALUES(11,'COLLECTION_METHOD','VARCHAR2','COMPLETE_REFRESH',6,
429: 'select decode(lookup_code, 1, ''COMPLETE_REFRESH'',2,''NET_CHANGE_REFRESH'',3,''TARGETED_REFRESH'') hidden, meaning display ' ||
430: 'from mfg_lookups WHERE lookup_type = ''PARTIAL_YES_NO''',
431: 1,SYSDATE,'Y','Y','Collection Method',p_version);
432:
433: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
434: NAME,

Line 446: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

442: DISPLAYED,
443: DISPLAY_NAME,
444: PARAM_VERSION)
445: VALUES(11,'ANALYZE_TABLES_ENABLED','VARCHAR2','N',7,
446: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
447: 1,SYSDATE,'Y','Y','Analyze Staging Tables',p_version);
448:
449: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
450: NAME,

Line 463: 'from mfg_lookups where lookup_type=''MSC_X_ASL_SYS_YES_NO''',

459: DISPLAY_NAME,
460: PARAM_VERSION)
461: VALUES(11,'APPROVED_SUPPLIER_LIST','VARCHAR2','YES_REPLACE',8,
462: ' select decode(lookup_code, 1, ''YES_REPLACE'',2,''NO'',3,''YES_BUT_RETAIN_CP'') hidden, meaning display '||
463: 'from mfg_lookups where lookup_type=''MSC_X_ASL_SYS_YES_NO''',
464: 1,SYSDATE,'Y','Y','Collect Approved Supplier Lists (Supplier Capacities)',p_version);
465:
466: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
467: NAME,

Line 479: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

475: DISPLAYED,
476: DISPLAY_NAME,
477: PARAM_VERSION)
478: VALUES(11,'ATP_RULES_ENABLED','VARCHAR2','Y',9,
479: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
480: 1,SYSDATE,'Y','Y','Collect ATP Rules',p_version);
481:
482: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
483: NAME,

Line 495: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

491: DISPLAYED,
492: DISPLAY_NAME,
493: PARAM_VERSION)
494: VALUES(11,'BOM_ENABLED','VARCHAR2','Y',10,
495: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
496: 1,SYSDATE,'Y','Y','Collect Bill of Materials/Routings/Resources',p_version);
497:
498: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
499: NAME,

Line 511: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

507: DISPLAYED,
508: DISPLAY_NAME,
509: PARAM_VERSION)
510: VALUES(11,'BOR_ENABLED','VARCHAR2','Y',11,
511: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
512: 1,SYSDATE,'Y','Y','Collect Bills of Resources',p_version);
513:
514: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
515: NAME,

Line 527: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

523: DISPLAYED,
524: DISPLAY_NAME,
525: PARAM_VERSION)
526: VALUES(11,'CALENDAR_ENABLED','VARCHAR2','Y',12,
527: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
528: 1,SYSDATE,'Y','Y','Collect Calendars',p_version);
529:
530: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
531: NAME,

Line 543: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

539: DISPLAYED,
540: DISPLAY_NAME,
541: PARAM_VERSION)
542: VALUES(11,'DEMAND_CLASS_ENABLED','VARCHAR2','Y',13,
543: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
544: 1,SYSDATE,'Y','Y','Collect Demand Classes',p_version);
545:
546: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
547: NAME,

Line 559: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

555: DISPLAYED,
556: DISPLAY_NAME,
557: PARAM_VERSION)
558: VALUES(11,'ITEM_SUBST_ENABLED','VARCHAR2','Y',14,
559: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
560: 1,SYSDATE,'Y','Y','Collect End Item Substitutions',p_version);
561:
562: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
563: NAME,

Line 575: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

571: DISPLAYED,
572: DISPLAY_NAME,
573: PARAM_VERSION)
574: VALUES(11,'FORECAST_ENABLED','VARCHAR2','Y',15,
575: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
576: 1,SYSDATE,'Y','Y','Collect Forecasts',p_version);
577:
578: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
579: NAME,

Line 591: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

587: DISPLAYED,
588: DISPLAY_NAME,
589: PARAM_VERSION)
590: VALUES(11,'ITEM_ENABLED','VARCHAR2','Y',16,
591: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
592: 1,SYSDATE,'Y','Y','Collect Items',p_version);
593:
594: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
595: NAME,

Line 607: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

603: DISPLAYED,
604: DISPLAY_NAME,
605: PARAM_VERSION)
606: VALUES(11,'KPI_BIS_ENABLED','VARCHAR2','Y',17,
607: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
608: 1,SYSDATE,'Y','Y','Collect Key Performance Indicator Targets',p_version);
609:
610: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
611: NAME,

Line 623: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

619: DISPLAYED,
620: DISPLAY_NAME,
621: PARAM_VERSION)
622: VALUES(11,'MDS_ENABLED','VARCHAR2','Y',18,
623: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
624: 1,SYSDATE,'Y','Y','Collect Master Demand Schedules',p_version);
625:
626: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
627: NAME,

Line 639: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

635: DISPLAYED,
636: DISPLAY_NAME,
637: PARAM_VERSION)
638: VALUES(11,'MPS_ENABLED','VARCHAR2','Y',19,
639: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
640: 1,SYSDATE,'Y','Y','Collect Master Production Schedules',p_version);
641:
642: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
643: NAME,

Line 655: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

651: DISPLAYED,
652: DISPLAY_NAME,
653: PARAM_VERSION)
654: VALUES(11,'ON_HAND_ENABLED','VARCHAR2','Y',20,
655: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
656: 1,SYSDATE,'Y','Y','Collect On Hand',p_version);
657:
658: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
659: NAME,

Line 671: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

667: DISPLAYED,
668: DISPLAY_NAME,
669: PARAM_VERSION)
670: VALUES(11,'PARAMETER_ENABLED','VARCHAR2','Y',21,
671: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
672: 1,SYSDATE,'Y','Y','Collect Planning Parameters',p_version);
673:
674: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
675: NAME,

Line 687: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

683: DISPLAYED,
684: DISPLAY_NAME,
685: PARAM_VERSION)
686: VALUES(11,'PLANNER_ENABLED','VARCHAR2','Y',22,
687: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
688: 1,SYSDATE,'Y','Y','Planner',p_version);
689:
690: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
691: NAME,

Line 703: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

699: DISPLAYED,
700: DISPLAY_NAME,
701: PARAM_VERSION)
702: VALUES(11,'PO_RECEIPTS_ENABLED','VARCHAR2','Y',23,
703: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
704: 1,SYSDATE,'Y','Y','Collect PO Receipts',p_version);
705:
706: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
707: NAME,

Line 719: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

715: DISPLAYED,
716: DISPLAY_NAME,
717: PARAM_VERSION)
718: VALUES(11,'PROJECT_ENABLED','VARCHAR2','Y',24,
719: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
720: 1,SYSDATE,'Y','Y','Collect Projects / Tasks',p_version);
721:
722: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
723: NAME,

Line 735: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

731: DISPLAYED,
732: DISPLAY_NAME,
733: PARAM_VERSION)
734: VALUES(11,'PUR_REQ_PO_ENABLED','VARCHAR2','Y',25,
735: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
736: 1,SYSDATE,'Y','Y','Collect Purchase Orders / Purchase Requisitions',p_version);
737:
738: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
739: NAME,

Line 751: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

747: DISPLAYED,
748: DISPLAY_NAME,
749: PARAM_VERSION)
750: VALUES(11,'RESERVES_HARD_ENABLED','VARCHAR2','Y',26,
751: 'select decode(lookup_code, 1, ''Y'',2,''N'')hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
752: 1,SYSDATE,'Y','Y','Reservations',p_version);
753:
754: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
755: NAME,

Line 767: 'select decode(lookup_code, 1, ''COLLECT_DATA'', 2, ''DO_NOT_COLLECT_DATA'', 3, ''REGENERATE_DATA'') hidden, meaning display from MFG_LOOKUPS where lookup_type=''MSC_NRA_ENABLED''',

763: DISPLAYED,
764: DISPLAY_NAME,
765: PARAM_VERSION)
766: VALUES(11,'RESOURCE_AVAILABILITY','VARCHAR2','COLLECT_DATA',27,
767: 'select decode(lookup_code, 1, ''COLLECT_DATA'', 2, ''DO_NOT_COLLECT_DATA'', 3, ''REGENERATE_DATA'') hidden, meaning display from MFG_LOOKUPS where lookup_type=''MSC_NRA_ENABLED''',
768: 1,SYSDATE,'Y','Y','Collect Resources Availability',p_version);
769:
770: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
771: NAME,

Line 783: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

779: DISPLAYED,
780: DISPLAY_NAME,
781: PARAM_VERSION)
782: VALUES(11,'SAFE_STOCK_ENABLED','VARCHAR2','Y',28,
783: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
784: 1,SYSDATE,'Y','Y','Collect Safety Stock',p_version);
785:
786: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
787: NAME,

Line 799: 'select decode(lookup_code, 1, ''Y'', 2, ''N'') hidden, meaning display from mfg_lookups WHERE lookup_type = ''SYS_YES_NO''',

795: DISPLAYED,
796: DISPLAY_NAME,
797: PARAM_VERSION)
798: VALUES(11,'SALES_ORDER_RTYPE','VARCHAR2','N',29,
799: 'select decode(lookup_code, 1, ''Y'', 2, ''N'') hidden, meaning display from mfg_lookups WHERE lookup_type = ''SYS_YES_NO''',
800: 1,SYSDATE,'Y','Y','Collect Sales Orders',p_version);
801:
802: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
803: NAME,

Line 815: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

811: DISPLAYED,
812: DISPLAY_NAME,
813: PARAM_VERSION)
814: VALUES(11,'SOURCING_HISTORY_ENABLED','VARCHAR2','N',30,
815: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
816: 1,SYSDATE,'Y','Y','Collect Sourcing History',p_version);
817:
818: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
819: NAME,

Line 831: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

827: DISPLAYED,
828: DISPLAY_NAME,
829: PARAM_VERSION)
830: VALUES(11,'SOURCING_ENABLED','VARCHAR2','Y',31,
831: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
832: 1,SYSDATE,'Y','Y','Collect Sourcing Rules',p_version);
833:
834: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
835: NAME,

Line 847: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

843: DISPLAYED,
844: DISPLAY_NAME,
845: PARAM_VERSION)
846: VALUES(11,'SUB_INV_ENABLED','VARCHAR2','Y',32,
847: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
848: 1,SYSDATE,'Y','Y','Collect Subinventories',p_version);
849:
850: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
851: NAME,

Line 863: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

859: DISPLAYED,
860: DISPLAY_NAME,
861: PARAM_VERSION)
862: VALUES(11,'SUPPLIER_RESPONSE_ENABLED','VARCHAR2','Y',33,
863: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
864: 1,SYSDATE,'Y','Y','Collect Supplier Responses',p_version);
865:
866: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
867: NAME,

Line 879: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

875: DISPLAYED,
876: DISPLAY_NAME,
877: PARAM_VERSION)
878: VALUES(11,'TP_CUSTOMER_ENABLED','VARCHAR2','Y',34,
879: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
880: 1,SYSDATE,'Y','Y','Collect Suppliers/Customers/Orgs',p_version);
881:
882: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
883: NAME,

Line 895: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

891: DISPLAYED,
892: DISPLAY_NAME,
893: PARAM_VERSION)
894: VALUES(11,'TRIP_ENABLED','VARCHAR2','Y',35,
895: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
896: 1,SYSDATE,'Y','Y','Collect Transportation Details',p_version);
897:
898: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
899: NAME,

Line 911: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

907: DISPLAYED,
908: DISPLAY_NAME,
909: PARAM_VERSION)
910: VALUES(11,'UNIT_NO_ENABLED','VARCHAR2','Y',36,
911: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
912: 1,SYSDATE,'Y','Y','Collect Unit Numbers',p_version);
913:
914: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
915: NAME,

Line 927: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

923: DISPLAYED,
924: DISPLAY_NAME,
925: PARAM_VERSION)
926: VALUES(11,'UOM_ENABLED','VARCHAR2','Y',37,
927: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
928: 1,SYSDATE,'Y','Y','Collect Units Of Measure',p_version);
929:
930: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
931: NAME,

Line 960: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

956: DISPLAYED,
957: DISPLAY_NAME,
958: PARAM_VERSION)
959: VALUES(11,'USER_SUPPLY_DEMAND','VARCHAR2','Y',39,
960: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
961: 1,SYSDATE,'Y','Y','Collect User Supplies and Demands',p_version);
962:
963: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
964: NAME,

Line 976: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

972: DISPLAYED,
973: DISPLAY_NAME,
974: PARAM_VERSION)
975: VALUES(11,'WIP_ENABLED','VARCHAR2','Y',40,
976: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
977: 1,SYSDATE,'Y','Y','Collect Work in Process',p_version);
978:
979: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
980: NAME,

Line 992: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

988: DISPLAYED,
989: DISPLAY_NAME,
990: PARAM_VERSION)
991: VALUES(11,'SALES_CHANNEL_ENABLED','VARCHAR2','N',41,
992: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
993: 1,SYSDATE,'Y','Y','Collect Sales Channel',p_version);
994:
995: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
996: NAME,

Line 1008: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1004: DISPLAYED,
1005: DISPLAY_NAME,
1006: PARAM_VERSION)
1007: VALUES(11,'FISCAL_CALENDAR_ENABLED','VARCHAR2','N',42,
1008: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1009: 1,SYSDATE,'Y','Y','Collect Fiscal Calendar',p_version);
1010:
1011: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1012: NAME,

Line 1024: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1020: DISPLAYED,
1021: DISPLAY_NAME,
1022: PARAM_VERSION)
1023: VALUES(11,'ITERNAL_REPAIR_ENABLED','VARCHAR2','N',43,
1024: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1025: 1,SYSDATE,'Y','Y','Collect Internal Repair Orders',p_version);
1026:
1027: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1028: NAME,

Line 1040: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1036: DISPLAYED,
1037: DISPLAY_NAME,
1038: PARAM_VERSION)
1039: VALUES(11,'ETERNAL_REPAIR_ENABLED','VARCHAR2','N',44,
1040: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1041: 1,SYSDATE,'Y','Y','Collect External Repair Orders',p_version);
1042:
1043: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1044: NAME,

Line 1056: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1052: DISPLAYED,
1053: DISPLAY_NAME,
1054: PARAM_VERSION)
1055: VALUES(11,'PAYBACK_DEMAND_SUPPLY_ENABLED','VARCHAR2','N',45,
1056: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1057: 1,SYSDATE,'Y','Y','Enable Pay Back Demand Supply',p_version);
1058:
1059: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1060: NAME,

Line 1072: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1068: DISPLAYED,
1069: DISPLAY_NAME,
1070: PARAM_VERSION)
1071: VALUES(11,'CURRENCY_CONVERSION_ENABLED','VARCHAR2','N',46,
1072: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1073: 1,SYSDATE,'Y','Y','Enable Currency Conversion',p_version);
1074:
1075: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1076: NAME,

Line 1088: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1084: DISPLAYED,
1085: DISPLAY_NAME,
1086: PARAM_VERSION)
1087: VALUES(11,'DELIVERY_DETAILS_ENABLED','VARCHAR2','N',47,
1088: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1089: 1,SYSDATE,'Y','Y','Enable Delivery Details',p_version);
1090:
1091:
1092:

Line 1122: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1118: DISPLAYED,
1119: DISPLAY_NAME,
1120: PARAM_VERSION)
1121: VALUES(11,'RECALC_RES_AVAILABILITY','VARCHAR2','Y',49,
1122: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1123: 1,SYSDATE,'Y','Y','Recalculate Sourcing History',p_version);
1124:
1125: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1126: NAME,

Line 1138: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1134: DISPLAYED,
1135: DISPLAY_NAME,
1136: PARAM_VERSION)
1137: VALUES(11,'PURGE_SOURCING_HISTORY','VARCHAR2','N',50,
1138: ' select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1139: 1,SYSDATE,'Y','Y','Purge Sourcing History',p_version);
1140:
1141:
1142:

Line 1266: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1262: DISPLAYED,
1263: DISPLAY_NAME,
1264: PARAM_VERSION)
1265: VALUES(10,'BH_BOOKED_ITEMS_BOOKED_DATE','VARCHAR','N',8,
1266: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1267: 1,SYSDATE,'Y','Y','Booking History - Booked Items - Booked Date',p_version);
1268:
1269: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1270: NAME,

Line 1282: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1278: DISPLAYED,
1279: DISPLAY_NAME,
1280: PARAM_VERSION)
1281: VALUES(10,'BH_BOOKED_ITEMS_REQUESTED_DATE','VARCHAR','N',9,
1282: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1283: 1,SYSDATE,'Y','Y','Booking History - Booked Items - Requested Date',p_version);
1284:
1285: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1286: NAME,

Line 1298: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1294: DISPLAYED,
1295: DISPLAY_NAME,
1296: PARAM_VERSION)
1297: VALUES(10,'BH_REQUESTED_ITEMS_BOOKED_DATE','VARCHAR','N',10,
1298: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1299: 1,SYSDATE,'Y','Y','Booking History - Requested Items - Booked Date',p_version);
1300:
1301: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1302: NAME,

Line 1314: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1310: DISPLAYED,
1311: DISPLAY_NAME,
1312: PARAM_VERSION)
1313: VALUES(10,'BH_REQUESTED_ITEMS_REQUESTED_DATE','VARCHAR','N',11,
1314: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1315: 1,SYSDATE,'Y','Y','Booking History - Requested Items - Requested Date',p_version);
1316:
1317: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1318: NAME,

Line 1330: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1326: DISPLAYED,
1327: DISPLAY_NAME,
1328: PARAM_VERSION)
1329: VALUES(10,'SH_SHIPPED_ITEMS_SHIPPED_DATE','VARCHAR','N',12,
1330: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1331: 1,SYSDATE,'Y','Y','ShipmentHistory - Shipped Items - Shipped Date',p_version);
1332:
1333: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1334: NAME,

Line 1346: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1342: DISPLAYED,
1343: DISPLAY_NAME,
1344: PARAM_VERSION)
1345: VALUES(10,'SH_SHIPPED_ITEMS_REQUESTED_DATE','VARCHAR','N',13,
1346: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1347: 1,SYSDATE,'Y','Y','ShipmentHistory - Shipped Items - Requested Date',p_version);
1348:
1349: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1350: NAME,

Line 1362: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1358: DISPLAYED,
1359: DISPLAY_NAME,
1360: PARAM_VERSION)
1361: VALUES(10,'SH_REQUESTED_ITEMS_SHIPPED_DATE','VARCHAR','N',14,
1362: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1363: 1,SYSDATE,'Y','Y','ShipmentHistory - Requested Items - Shipped Date',p_version);
1364:
1365: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1366: NAME,

Line 1378: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1374: DISPLAYED,
1375: DISPLAY_NAME,
1376: PARAM_VERSION)
1377: VALUES(10,'SH_REQUESTED_ITEMS_REQUESTED_DATE','VARCHAR','N',15,
1378: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1379: 1,SYSDATE,'Y','Y','ShipmentHistory - Requested Items - Requested Date',p_version);
1380:
1381: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1382: NAME,

Line 1394: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1390: DISPLAYED,
1391: DISPLAY_NAME,
1392: PARAM_VERSION)
1393: VALUES(10,'COLLECT_ISO','VARCHAR','N',16,
1394: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1395: 1,SYSDATE,'Y','Y','Collect Internal Sales Orders',p_version);
1396:
1397: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1398: NAME,

Line 1410: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1406: DISPLAYED,
1407: DISPLAY_NAME,
1408: PARAM_VERSION)
1409: VALUES(10,'COLLECT_ALL_ORDER_TYPES','VARCHAR','Y',17,
1410: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1411: 1,SYSDATE,'Y','Y','Collect All Order Types',p_version);
1412:
1413: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1414: NAME,

Line 1455: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1451: DISPLAYED,
1452: DISPLAY_NAME,
1453: PARAM_VERSION)
1454: VALUES(10,'LAUNCH_DOWNLOAD','VARCHAR','N',20,
1455: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1456: 1,SYSDATE,'Y','Y','Launch Download',p_version);
1457:
1458:
1459: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

Line 1502: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1498: DISPLAYED,
1499: DISPLAY_NAME,
1500: PARAM_VERSION)
1501: VALUES(10,'COLLECT_ALL_CURRENCIES','VARCHAR','N',23,
1502: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1503: 1,SYSDATE,'Y','Y','Collect All Currency Conversions',p_version);
1504:
1505: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1506: NAME,

Line 1548: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1544: DISPLAYED,
1545: DISPLAY_NAME,
1546: PARAM_VERSION)
1547: VALUES(10,'INCLUDE_ALL','VARCHAR','N',26,
1548: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1549: 1,SYSDATE,'Y','Y','Collect All Unit of Measures',p_version);
1550:
1551: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1552: NAME,

Line 1624: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1620: DISPLAYED,
1621: DISPLAY_NAME,
1622: PARAM_VERSION)
1623: VALUES(10,'INCLUDE_ALL1','VARCHAR','N',31,
1624: 'select decode(lookup_code, 1, ''Y'',2,''N'') hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1625: 1,SYSDATE,'Y','Y','Collect all Price Lists',p_version);
1626:
1627:
1628: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,

Line 1801: 'select lookup_code hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1797: DISPLAYED,
1798: DISPLAY_NAME,
1799: PARAM_VERSION)
1800: VALUES(13,'ARCHIVE_FLAG','NUMBER',2,3,
1801: 'select lookup_code hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1802: 1,sysdate,'Y','Y','Archive Forecast',p_version);
1803:
1804: INSERT INTO msc_activity_parameters(ACTIVITY_TYPE,
1805: NAME,

Line 1851: 'select lookup_code hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',

1847: DISPLAYED,
1848: DISPLAY_NAME,
1849: PARAM_VERSION)
1850: VALUES(19,'ARCHIVE_FLAG','NUMBER',2,3,
1851: 'select lookup_code hidden, meaning display from mfg_lookups where lookup_type = ''SYS_YES_NO''',
1852: 1,sysdate,'Y','Y','Archive Forecast',p_version);
1853:
1854: commit;
1855:

Line 1977: select meaning from mfg_lookups

1973: end;
1974:
1975: FUNCTION get_proc_act_name(p_activity_type in number) return varchar2 is
1976: cursor c_act_name is
1977: select meaning from mfg_lookups
1978: where lookup_type = 'MSC_PROCESS_ACTIVITY_TYPES'
1979: and lookup_code = p_activity_type;
1980:
1981: l_act_name varchar2(100);