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_BOM_PULL dependencies on MSC_UTIL

Line 17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;

13: v_temp_sql4 VARCHAR2(1000);
14: v_rounding_Sql varchar2(1000);
15:
16: --NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
18: -- ===============================================================
19:
20: PROCEDURE LOAD_BOM IS
21: v_applsys_schema VARCHAR2(32);

Line 30: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN

26: BEGIN
27: lv_retval := FND_INSTALLATION.GET_APP_INFO (
28: 'FND', lv_dummy1, lv_dummy2, v_applsys_schema);
29:
30: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
31:
32: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
33: v_temp_sql1 := ' x.BASIS_TYPE, x.Old_Component_Sequence_ID,';
34: ELSE

Line 32: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

28: 'FND', lv_dummy1, lv_dummy2, v_applsys_schema);
29:
30: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
31:
32: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
33: v_temp_sql1 := ' x.BASIS_TYPE, x.Old_Component_Sequence_ID,';
34: ELSE
35: v_temp_sql1 := ' NULL, NULL,';
36: END IF;

Line 44: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

40:
41: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOM_COMPONENTS';
42: MSC_CL_PULL.v_view_name := 'MRP_AD_BOM_COMPONENTS_V';
43:
44: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
45: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
46: ELSE
47: v_temp_sql := NULL;
48: END IF;

Line 45: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

41: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOM_COMPONENTS';
42: MSC_CL_PULL.v_view_name := 'MRP_AD_BOM_COMPONENTS_V';
43:
44: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
45: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
46: ELSE
47: v_temp_sql := NULL;
48: END IF;
49:

Line 78: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

74: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOM_COMPONENTS';
75:
76:
77:
78: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
79: v_rounding_sql := 'decode(x.rounding_direction,0,3,1,2,2,1,3),';
80: ELSE
81: v_rounding_sql :='3,';
82: END IF ;

Line 86: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

82: END IF ;
83:
84: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
85:
86: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
87: MSC_CL_PULL.v_view_name := 'MRP_AN_BOM_COMPONENTS_V';
88: ELSE
89: MSC_CL_PULL.v_view_name := 'MRP_AP_BOM_COMPONENTS_V';
90: END IF;

Line 125: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

121: || v_temp_sql1
122: ||' :v_refresh_id,'
123: ||' :v_instance_id'
124: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
125: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
126: ||' AND ( x.RN2> :v_lrn )'
127: /* NCP
128: ||' UNION '
129: ||' select '

Line 156: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

152: || v_rounding_sql
153: ||' :v_refresh_id,'
154: ||' :v_instance_id'
155: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
156: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
157: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'
158: */
159:
160: ||' UNION '

Line 190: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

186: || v_temp_sql1
187: ||' :v_refresh_id,'
188: ||' :v_instance_id'
189: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
190: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
191: ||' AND ( x.RN3> :v_lrn )'
192: ||' UNION '
193: ||' select '
194: ||' x.COMPONENT_SEQUENCE_ID,'

Line 222: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

218: || v_temp_sql1
219: ||' :v_refresh_id,'
220: ||' :v_instance_id'
221: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
222: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
223: ||' AND ( x.RN4> :v_lrn )';
224: /*
225: ||' UNION '
226: ||' select '

Line 253: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

249: || v_rounding_sql
250: ||' :v_refresh_id,'
251: ||' :v_instance_id'
252: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
253: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
254: ||' AND ( x.RN6>'||MSC_CL_PULL.v_lrn||')' ;
255: */
256:
257: ELSE

Line 321: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

317: || v_temp_sql1
318: ||' :v_refresh_id,'
319: ||' :v_instance_id'
320: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
321: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
322: || v_union_sql ;
323:
324: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
325:

Line 351: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

347:
348: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOMS';
349: MSC_CL_PULL.v_view_name := 'MRP_AD_BOMS_V';
350:
351: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
352: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
353: ELSE
354: v_temp_sql := NULL;
355: END IF;

Line 352: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

348: MSC_CL_PULL.v_table_name:= 'MSC_ST_BOMS';
349: MSC_CL_PULL.v_view_name := 'MRP_AD_BOMS_V';
350:
351: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
352: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
353: ELSE
354: v_temp_sql := NULL;
355: END IF;
356:

Line 400: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

396: ||' 2,'
397: ||' :v_refresh_id,'
398: ||' :v_instance_id'
399: ||' FROM MRP_AP_BOMS_V'||MSC_CL_PULL.v_dblink||' x'
400: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
401: ||' AND (x.RN2 > :v_lrn)';
402:
403: ELSE
404: v_union_sql := ' ';

Line 435: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

431: ||' 2,'
432: ||' :v_refresh_id,'
433: ||' :v_instance_id'
434: ||' FROM MRP_AP_BOMS_V'||MSC_CL_PULL.v_dblink||' x'
435: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
436: || v_union_sql;
437:
438: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
439:

Line 451: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

447:
448:
449: COMMIT;
450:
451: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
452: --=================== Net Change Mode: Delete ==================
453: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
454:
455: MSC_CL_PULL.v_table_name:= 'MSC_ST_COMPONENT_SUBSTITUTES';

Line 474: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str

470: ||' 1,'
471: ||' :v_refresh_id,'
472: ||' :v_instance_id'
473: ||' FROM MRP_AD_SUB_COMPS_V'||MSC_CL_PULL.v_dblink||' x'
474: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
475: ||' AND x.RN > :v_lrn';
476:
477: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
478:

Line 491: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

487: MSC_CL_PULL.v_view_name := 'MRP_AP_COMPONENT_SUBSTITUTES_V';
488:
489:
490:
491: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
492: v_rounding_sql := 'decode(x.rounding_direction,0,3,1,2,2,1,3),';
493: v_rounding_sql :='3,';
494: END IF ;
495:

Line 530: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

526: || v_rounding_sql
527: ||' :v_refresh_id,'
528: ||' :v_instance_id'
529: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
530: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
531: ||' AND (x.RN2 > :v_lrn)'
532: ||' UNION '
533: ||' SELECT'
534: ||' x.BILL_SEQUENCE_ID,'

Line 560: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

556: || v_rounding_sql
557: ||' :v_refresh_id,'
558: ||' :v_instance_id'
559: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
560: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
561: ||' AND (x.RN3 > :v_lrn)'
562: ||' UNION '
563: ||' SELECT'
564: ||' x.BILL_SEQUENCE_ID,'

Line 590: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

586: || v_rounding_sql
587: ||' :v_refresh_id,'
588: ||' :v_instance_id'
589: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
590: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
591: ||' AND (x.RN4 > :v_lrn)';
592:
593: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
594:

Line 593: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

589: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
590: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
591: ||' AND (x.RN4 > :v_lrn)';
592:
593: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
594:
595: v_union_sql :=
596: v_union_sql||' UNION '
597: ||' SELECT'

Line 624: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

620: || v_rounding_sql
621: ||' :v_refresh_id,'
622: ||' :v_instance_id'
623: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
624: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
625: ||' AND (x.RN5 > :v_lrn)';
626:
627:
628: END IF;

Line 674: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

670: || v_rounding_sql
671: ||' :v_refresh_id,'
672: ||' :v_instance_id'
673: ||' FROM MRP_AP_COMPONENT_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
674: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
675: || v_union_sql;
676:
677:
678: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 680: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

676:
677:
678: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
679:
680: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
681:
682: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_bom_subst_priority,MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_lrn,
683: MSC_CL_PULL.v_msc_bom_subst_priority,MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_lrn,
684: MSC_CL_PULL.v_msc_bom_subst_priority,MSC_CL_PULL.v_refresh_id,MSC_CL_PULL.v_instance_id,MSC_CL_PULL.v_lrn,

Line 705: if MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN /osfm change/

701:
702: COMMIT;
703:
704:
705: if MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN /*osfm change*/
706: select instance_code into lv_icode from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;
707: BEGIN
708:
709: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

716: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);
717:
718: EXCEPTION
719: WHEN OTHERS THEN
720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
721:
722: END;
723: msc_analyse_tables_pk.analyse_table( 'MSC_ST_BOM_COMPONENTS');
724:

Line 736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);

732: 'drop index MSC_ST_BOM_COMPONENTS_'||lv_icode,
733: object_name => 'MSC_ST_BOM_COMPONENTS_'||lv_icode);
734: EXCEPTION
735: WHEN OTHERS THEN
736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
737:
738: END;
739:
740: End If;

Line 752: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN

748: PROCEDURE LOAD_PROCESS_EFFECTIVITY IS
749: v_get_apps_ver number;
750: BEGIN
751:
752: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
753: --=================== Net Change Mode: Delete ==================
754: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
755:
756: MSC_CL_PULL.v_table_name:= 'MSC_ST_PROCESS_EFFECTIVITY';

Line 780: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

776: ||' :v_refresh_id,'
777: ||' :v_instance_id'
778: ||' FROM MRP_AD_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
779: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
780: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
781:
782: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
783:
784: COMMIT;

Line 826: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

822: ||' 2,'
823: ||' :v_refresh_id,'
824: ||' :v_instance_id'
825: ||' FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
826: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
827: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn||')'
828: */
829:
830: ||' UNION '

Line 862: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

858: ||' 2,'
859: ||' :v_refresh_id,'
860: ||' :v_instance_id'
861: ||' FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
862: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
863: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'
864: ||' UNION '
865: ||' SELECT'
866: ||' x.INVENTORY_ITEM_ID,'

Line 896: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

892: ||' 2,'
893: ||' :v_refresh_id,'
894: ||' :v_instance_id'
895: ||' FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
896: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
897: ||' AND ( x.RN4>'||MSC_CL_PULL.v_lrn||')';
898: /*
899: ||' UNION '
900: ||' SELECT'

Line 931: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

927: ||' 2,'
928: ||' :v_refresh_id,'
929: ||' :v_instance_id'
930: ||' FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
931: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
932: ||' AND ( x.RN5>'||MSC_CL_PULL.v_lrn||')' ;
933: */
934: ELSE
935: v_union_sql :=

Line 990: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

986: ||' 2,'
987: ||' :v_refresh_id,'
988: ||' :v_instance_id'
989: ||' FROM MRP_AP_PROCESS_EFFECTIVITY_V'||MSC_CL_PULL.v_dblink||' x'
990: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
991: || v_union_sql ;
992:
993: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
994:

Line 1056: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1052: ||' 2,'
1053: ||' :v_refresh_id,'
1054: ||' :v_instance_id'
1055: ||' from MRP_AP_BILL_OF_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
1056: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1057: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1058: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1059:
1060: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1108: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1104: ||' :v_refresh_id,'
1105: ||' :v_instance_id'
1106: ||' from MRP_AP_CRP_RESOURCE_HOURS_V'||MSC_CL_PULL.v_dblink||' x'
1107: ||' WHERE DECODE( :WIP_ENABLED, 2, LINE_ID) IS NULL'
1108: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1109: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
1110: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1111: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1112:

Line 1143: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1139: BEGIN
1140:
1141: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEPARTMENT_RESOURCES';
1142: MSC_CL_PULL.v_view_name := 'MRP_AP_DEPARTMENT_RESOURCES_V';
1143: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1144: v_temp_atp_rule_sql := 'x.ATP_RULE_ID,x.SCHEDULE_TO_INSTANCE,x.BATCHING_PENALTY,x.SETUP_TIME_PERCENT,x.UTILIZATION_CHANGE_PERCENT,x.SETUP_TIME_TYPE,x.UTILIZATION_CHANGE_TYPE,x.IDLE_TIME_TOLERANCE,x.SDS_SCHEDULING_WINDOW,';
1145: ELSE
1146: v_temp_atp_rule_sql := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1147: END IF;

Line 1148: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1144: v_temp_atp_rule_sql := 'x.ATP_RULE_ID,x.SCHEDULE_TO_INSTANCE,x.BATCHING_PENALTY,x.SETUP_TIME_PERCENT,x.UTILIZATION_CHANGE_PERCENT,x.SETUP_TIME_TYPE,x.UTILIZATION_CHANGE_TYPE,x.IDLE_TIME_TOLERANCE,x.SDS_SCHEDULING_WINDOW,';
1145: ELSE
1146: v_temp_atp_rule_sql := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1147: END IF;
1148: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1149: v_temp_atp_rule_sql1 := 'x.ATP_RULE_ID,x.SETUP_TIME_PERCENT,x.UTILIZATION_CHANGE_PERCENT,x.SETUP_TIME_TYPE,x.UTILIZATION_CHANGE_TYPE,';
1150: ELSE
1151: v_temp_atp_rule_sql1 := 'NULL,NULL,NULL,NULL,NULL,';
1152: END IF;

Line 1159: IF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN

1155: /* The code is forked since the Resource Batching flexfields are replaced by the columns
1156: in Patchset - G for 11i source only
1157: */
1158:
1159: IF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN
1160: v_sql_stmt:=
1161: ' insert into MSC_ST_DEPARTMENT_RESOURCES'
1162: ||' ( RESOURCE_ID,'
1163: ||' DEPARTMENT_ID,'

Line 1295: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1291: ||' :v_refresh_id,'
1292: || v_temp_atp_rule_sql
1293: ||' :v_instance_id'
1294: ||' from MRP_AP_DEPARTMENT_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
1295: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1296:
1297: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_aggreg_res_name,
1298: MSC_CL_PULL.v_msc_aggreg_res_name,
1299: MSC_CL_PULL.v_dgmt,

Line 1514: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1510: ||' :v_refresh_id,'
1511: || v_temp_atp_rule_sql
1512: ||' :v_instance_id'
1513: ||' FROM MRP_AP_DEPARTMENT_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
1514: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1515:
1516: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_aggreg_res_name,
1517: MSC_CL_PULL.v_msc_aggreg_res_name,
1518: MSC_CL_PULL.v_dgmt,

Line 1532: IF ((MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) OR (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES)) THEN

1528: END IF;
1529:
1530: COMMIT;
1531:
1532: IF ((MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) OR (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES)) THEN
1533:
1534: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEPARTMENT_RESOURCES';
1535: MSC_CL_PULL.v_view_name := 'MRP_AP_LINE_RESOURCES_V';
1536:

Line 1605: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1601: ||' :v_refresh_id,'
1602: || v_temp_atp_rule_sql1
1603: ||' :v_instance_id'
1604: ||' from MRP_AP_LINE_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
1605: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1606: || v_union_sql;
1607:
1608: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1609:

Line 1645: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1641: ||' 2,'
1642: ||' :v_refresh_id,'
1643: ||' :v_instance_id'
1644: ||' from MRP_AP_SIMULATION_SETS_V'||MSC_CL_PULL.v_dblink||' x'
1645: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1646:
1647: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1648:
1649: COMMIT;

Line 1685: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN

1681: COMMIT;
1682:
1683: END IF;
1684:
1685: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
1686:
1687: IF (nvl(fnd_profile.value('MSC_INFLATE_WIP') ,'N')= 'N') THEN
1688: lv_inflate_wip := 2 ;
1689: ELSE

Line 1696: IF lv_inflate_wip = 1 AND MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1692:
1693: -- if the profile MSC_INFLATE_WIP is set to YES then inflating the operation resource hours by
1694: -- efficiency and utilization. Not inflating the operation resource hours for SDS records.
1695: -- for bug fix 2877975. Lot based jobs should get inflated irrespective of the profile.
1696: IF lv_inflate_wip = 1 AND MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1697: v_res_hrs_sql := ' decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) ,';
1698: v_res_hrs_left := ' AND (x.ENTITY_TYPE <>5 or decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) - x.HOURS_EXPENDED >0) ';
1699: v_touch_time := ' decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) ,';
1700: ELSIF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

Line 1700: ELSIF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1696: IF lv_inflate_wip = 1 AND MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1697: v_res_hrs_sql := ' decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) ,';
1698: v_res_hrs_left := ' AND (x.ENTITY_TYPE <>5 or decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) - x.HOURS_EXPENDED >0) ';
1699: v_touch_time := ' decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) ,';
1700: ELSIF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1701: v_res_hrs_sql := ' decode(x.entity_type,5, (decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED)),x.OPERATION_HOURS_REQUIRED),';
1702: v_res_hrs_left := ' AND (x.ENTITY_TYPE <>5 or decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.utilization)* (1/x.efficiency),x.OPERATION_HOURS_REQUIRED) - x.HOURS_EXPENDED > 0) ';
1703: v_touch_time := ' decode(x.entity_type,5, (decode(nvl(x.PARENT_SEQ_NUM,-1),-1,x.OPERATION_HOURS_REQUIRED * (1/x.efficiency),x.OPERATION_HOURS_REQUIRED)),x.OPERATION_HOURS_REQUIRED),';
1704: ELSE

Line 1710: -- Pulling parent_seq_num and SETUP_ID from MRP_AP_RESOURCE_REQUIREMENTS_V if MSC_CL_PULL.v_apps_ver is MSC_UTIL.G_APPS115

1706: v_res_hrs_left := ' AND (x.ENTITY_TYPE <>5 or x.OPERATION_HOURS_REQUIRED - x.HOURS_EXPENDED > 0 ) ';
1707: v_touch_time := ' x.OPERATION_HOURS_REQUIRED ,';
1708: END IF;
1709:
1710: -- Pulling parent_seq_num and SETUP_ID from MRP_AP_RESOURCE_REQUIREMENTS_V if MSC_CL_PULL.v_apps_ver is MSC_UTIL.G_APPS115
1711: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1712: v_temp_parent_seq := 'x.PARENT_SEQ_NUM,x.SETUP_ID, x.ORIG_RESOURCE_SEQ_NUM,GROUP_SEQUENCE_ID,GROUP_SEQUENCE_NUMBER,BATCH_NUMBER,MAXIMUM_ASSIGNED_UNITS, ';
1713: ELSE
1714: v_temp_parent_seq := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,';

Line 1711: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1707: v_touch_time := ' x.OPERATION_HOURS_REQUIRED ,';
1708: END IF;
1709:
1710: -- Pulling parent_seq_num and SETUP_ID from MRP_AP_RESOURCE_REQUIREMENTS_V if MSC_CL_PULL.v_apps_ver is MSC_UTIL.G_APPS115
1711: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1712: v_temp_parent_seq := 'x.PARENT_SEQ_NUM,x.SETUP_ID, x.ORIG_RESOURCE_SEQ_NUM,GROUP_SEQUENCE_ID,GROUP_SEQUENCE_NUMBER,BATCH_NUMBER,MAXIMUM_ASSIGNED_UNITS, ';
1713: ELSE
1714: v_temp_parent_seq := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1715: END IF;

Line 1717: If MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then

1713: ELSE
1714: v_temp_parent_seq := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1715: END IF;
1716:
1717: If MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then
1718: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
1719: where instance_id = MSC_CL_PULL.v_instance_id ;
1720: end if;
1721:

Line 1728: if MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' and MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120 then

1724:
1725: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_REQUIREMENTS';
1726: --MSC_CL_PULL.v_view_name := 'MRP_AD_RESOURCE_REQUIREMENTS_V';
1727: -- bug5996354
1728: if MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' and MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120 then
1729: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_IRO_ERO_RES_REQ_V';
1730: else
1731: MSC_CL_PULL.v_view_name := 'MRP_AD_RESOURCE_REQUIREMENTS_V';
1732: end if;

Line 1735: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1731: MSC_CL_PULL.v_view_name := 'MRP_AD_RESOURCE_REQUIREMENTS_V';
1732: end if;
1733: --
1734:
1735: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1736: v_temp_sql1 := ' x.RESOURCE_SEQ_NUM, ';
1737: ELSE
1738: v_temp_sql1 := ' NULL, ';
1739: END IF;

Line 1743: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1739: END IF;
1740:
1741: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1742:
1743: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1744: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1745:
1746: if lv_lbj_details = 1 Then
1747: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';

Line 1744: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1740:
1741: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1742:
1743: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1744: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1745:
1746: if lv_lbj_details = 1 Then
1747: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';
1748: end if;

Line 1788: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then

1784: MSC_CL_PULL.v_mps_consume_profile_value;
1785:
1786: COMMIT;
1787:
1788: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then
1789:
1790: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';
1791: MSC_CL_PULL.v_view_name := 'MRP_AD_DJOB_SUB_OP_RESOURCES_V';
1792:

Line 1842: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

1838: ||' x.net_quantity) > 0' ;
1839: END IF;
1840:
1841: /* set the MTQ , Firm Flag, Scheduled flag */
1842: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1843: IF lv_lbj_details =1 Then
1844: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,x.scheduled_flag, x.QUANTITY_IN_QUEUE, x.QUANTITY_RUNNING, x.QUANTITY_WAITING_TO_MOVE, x.QUANTITY_COMPLETED,'
1845: ||' decode(x.ENTITY_TYPE,5,x.COPY_YIELD, x.YIELD), x.USAGE_RATE, x.Copy_op_seq_num, decode(x.ENTITY_TYPE,5,copy_STANDARD_OPERATION_CODE,Standard_Operation_Code), x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, '
1846: ||' x.ACTUAL_START_DATE, x.ROUTING_SEQUENCE_ID, ';

Line 1852: ELSIF MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 THEN

1848: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,x.scheduled_flag, x.QUANTITY_IN_QUEUE, x.QUANTITY_RUNNING, x.QUANTITY_WAITING_TO_MOVE, x.QUANTITY_COMPLETED,'
1849: ||' x.YIELD, x.USAGE_RATE, x.Operation_Seq_Num, x.Standard_Operation_Code, x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, x.ACTUAL_START_DATE, x.ROUTING_SEQUENCE_ID, ';
1850: lv_cond_sql := ' AND (x.ENTITY_TYPE <> 5 OR x.OPERATION_SEQUENCE_ID is not null) ';
1851: END IF;
1852: ELSIF MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 THEN
1853: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL, ';
1854: ELSE
1855: v_temp_sql := ' NULL ,NULL ,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL, ';
1856: END IF;

Line 1858: if MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' and MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120 then

1854: ELSE
1855: v_temp_sql := ' NULL ,NULL ,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL, ';
1856: END IF;
1857: -- bug5996354
1858: if MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' and MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120 then
1859: MSC_CL_PULL.v_view_name := 'MRP_AP_NON_IRO_ERO_RES_REQ_V';
1860: else
1861: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_REQUIREMENTS_V';
1862: end if;

Line 1907: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1903: ||' x.OPERATION_HOURS_REQUIRED,'
1904: || v_touch_time
1905: ||' :v_instance_id'
1906: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
1907: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1908: /*Bug#4704457 ||' AND DECODE( x.wip_job_type, '
1909: ||' 1, DECODE( :v_mps_consume_profile_value, '
1910: ||' 1, x.mps_net_quantity,'
1911: ||' x.net_quantity), '

Line 1947: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1943: ||' x.OPERATION_HOURS_REQUIRED,'
1944: || v_touch_time
1945: ||' :v_instance_id'
1946: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
1947: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1948: /*Bug#4704457 ||' AND DECODE( x.wip_job_type, '
1949: ||' 1, DECODE( :v_mps_consume_profile_value, '
1950: ||' 1, x.mps_net_quantity,'
1951: ||' x.net_quantity), '

Line 2044: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2040: ||' x.OPERATION_HOURS_REQUIRED,'
2041: || v_touch_time
2042: ||' :v_instance_id'
2043: ||' from '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
2044: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2045: /*Bug#4704457 ||' AND DECODE( x.wip_job_type, '
2046: ||' 1, DECODE( :v_mps_consume_profile_value, '
2047: ||' 1, x.mps_net_quantity,'
2048: ||' x.net_quantity), '

Line 2089: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then

2085: MSC_CL_PULL.v_hour_uom;
2086: END IF;
2087: COMMIT;
2088:
2089: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then
2090:
2091: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RESOURCES';
2092: MSC_CL_PULL.v_view_name := 'MRP_AP_DJOB_SUB_OP_RESOURCES_V';
2093:

Line 2145: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2141: ||' x.SETUP_ID,'
2142: ||' 2,'
2143: ||' :v_refresh_id'
2144: ||' FROM MRP_AP_DJOB_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2145: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2146: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2147: ||' OR x.RN2>' || MSC_CL_PULL.v_lrn
2148: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2149:

Line 2154: END IF; /* MSC_UTIL.G_APPS115 */

2150: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2151:
2152: COMMIT;
2153:
2154: END IF; /* MSC_UTIL.G_APPS115 */
2155:
2156:
2157: END IF; -- MSC_CL_PULL.WIP_ENABLED
2158:

Line 2173: IF ( ((MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) OR (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES)) AND

2169: lv_op_seq_num VARCHAR2(100) := null;
2170:
2171: BEGIN
2172:
2173: IF ( ((MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) OR (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES)) AND
2174: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN
2175: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEPT_RES_INSTANCES';
2176: MSC_CL_PULL.v_view_name := 'MRP_AP_DEPT_RES_INSTANCES_V';
2177:

Line 2174: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN

2170:
2171: BEGIN
2172:
2173: IF ( ((MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) OR (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES)) AND
2174: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN
2175: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEPT_RES_INSTANCES';
2176: MSC_CL_PULL.v_view_name := 'MRP_AP_DEPT_RES_INSTANCES_V';
2177:
2178: v_sql_stmt:=

Line 2206: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2202: ||' 2,'
2203: ||' :v_refresh_id,'
2204: ||' :v_instance_id'
2205: ||' from MRP_AP_DEPT_RES_INSTANCES_V'||MSC_CL_PULL.v_dblink||' x'
2206: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2207:
2208: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: dept_res_instance sql = '||v_sql_stmt);
2209: EXECUTE IMMEDIATE v_sql_stmt USING
2210: MSC_CL_PULL.v_refresh_id,

Line 2208: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: dept_res_instance sql = '||v_sql_stmt);

2204: ||' :v_instance_id'
2205: ||' from MRP_AP_DEPT_RES_INSTANCES_V'||MSC_CL_PULL.v_dblink||' x'
2206: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2207:
2208: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: dept_res_instance sql = '||v_sql_stmt);
2209: EXECUTE IMMEDIATE v_sql_stmt USING
2210: MSC_CL_PULL.v_refresh_id,
2211: MSC_CL_PULL.v_instance_id;
2212:

Line 2219: IF ( (MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) AND

2215:
2216: END IF;
2217:
2218:
2219: IF ( (MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) AND
2220: (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) ) THEN
2221:
2222: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2223: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_INSTANCE_REQS';

Line 2220: (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) ) THEN

2216: END IF;
2217:
2218:
2219: IF ( (MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES) AND
2220: (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) ) THEN
2221:
2222: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2223: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_INSTANCE_REQS';
2224: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INSTANCE_REQS_V';

Line 2225: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

2221:
2222: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2223: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_INSTANCE_REQS';
2224: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INSTANCE_REQS_V';
2225: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
2226:
2227: v_sql_stmt:=
2228: 'insert into MSC_ST_RESOURCE_INSTANCE_REQS'
2229: ||' ( WIP_ENTITY_ID,'

Line 2251: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance sql = '||v_sql_stmt);

2247: ||' WHERE x.RN > :v_lrn '
2248: || v_temp_sql;
2249:
2250:
2251: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance sql = '||v_sql_stmt);
2252: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2253: MSC_CL_PULL.v_instance_id,
2254: MSC_CL_PULL.v_lrn;
2255:

Line 2286: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: job res_instance sql = '||v_sql_stmt);

2282: ||' from MRP_AD_LJ_OPR_RES_INSTS_V'||MSC_CL_PULL.v_dblink||' x'
2283: ||' WHERE x.RN > :v_lrn '
2284: || v_temp_sql;
2285:
2286: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: job res_instance sql = '||v_sql_stmt);
2287: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2288: MSC_CL_PULL.v_instance_id,
2289: MSC_CL_PULL.v_lrn;
2290: COMMIT;

Line 2327: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str

2323: ||' 2,'
2324: ||' :v_refresh_id,'
2325: ||' :v_instance_id'
2326: ||' from MRP_AP_RES_INSTANCE_REQS_V' ||MSC_CL_PULL.v_dblink ||' x'
2327: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str
2328: || lv_cond_sql
2329: ||' AND ( x.RN2> :v_lrn )'
2330: ||' UNION '
2331: ||' select '

Line 2350: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str

2346: ||' 2,'
2347: ||' :v_refresh_id,'
2348: ||' :v_instance_id'
2349: ||' from MRP_AP_RES_INSTANCE_REQS_V' ||MSC_CL_PULL.v_dblink ||' x'
2350: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str
2351: || lv_cond_sql
2352: ||' AND ( x.RN3> :v_lrn )'
2353: ||' UNION '
2354: ||' select '

Line 2373: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str

2369: ||' 2,'
2370: ||' :v_refresh_id,'
2371: ||' :v_instance_id'
2372: ||' from MRP_AP_RES_INSTANCE_REQS_V' ||MSC_CL_PULL.v_dblink ||' x'
2373: ||' where x.ORGANIZATION_ID' ||MSC_UTIL.v_in_org_str
2374: || lv_cond_sql
2375: ||' AND ( x.RN4> :v_lrn )';
2376: ELSE -- full
2377:

Line 2421: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2417: ||' 2,'
2418: ||' :v_refresh_id,'
2419: ||' :v_instance_id'
2420: ||' from MRP_AP_RES_INSTANCE_REQS_V'||MSC_CL_PULL.v_dblink||' x'
2421: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2422: || lv_cond_sql
2423: || v_union_sql ;
2424:
2425:

Line 2426: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' Ds debug: insert from MRP_AP_RES_INSTANCE_REQS_V sql = '||v_sql_stmt);

2422: || lv_cond_sql
2423: || v_union_sql ;
2424:
2425:
2426: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, ' Ds debug: insert from MRP_AP_RES_INSTANCE_REQS_V sql = '||v_sql_stmt);
2427: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2428:
2429: EXECUTE IMMEDIATE v_sql_stmt USING
2430: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

Line 2441: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for Wip Job Res Instances='|| SQL%ROWCOUNT);

2437: EXECUTE IMMEDIATE v_sql_stmt USING
2438: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2439: END IF;
2440:
2441: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for Wip Job Res Instances='|| SQL%ROWCOUNT);
2442: COMMIT;
2443:
2444: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RES_INSTANCES';
2445: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_RES_INSTANCES_V';

Line 2482: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

2478: ||' x.BATCH_NUMBER,'
2479: ||' 2,'
2480: ||' :v_refresh_id'
2481: ||' FROM MRP_AP_JOB_RES_INSTANCES_V'||MSC_CL_PULL.v_dblink||' x'
2482: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2483: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2484: ||' OR x.RN2>' || MSC_CL_PULL.v_lrn
2485: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2486:

Line 2487: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: insert from MRP_AP_JOB_RES_INSTANCES_V job res_instance sql = '||v_sql_stmt);

2483: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2484: ||' OR x.RN2>' || MSC_CL_PULL.v_lrn
2485: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2486:
2487: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: insert from MRP_AP_JOB_RES_INSTANCES_V job res_instance sql = '||v_sql_stmt);
2488: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for lJob Res Instances= '||SQL%ROWCOUNT);
2490:
2491: COMMIT;

Line 2489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for lJob Res Instances= '||SQL%ROWCOUNT);

2485: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2486:
2487: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: insert from MRP_AP_JOB_RES_INSTANCES_V job res_instance sql = '||v_sql_stmt);
2488: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2489: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for lJob Res Instances= '||SQL%ROWCOUNT);
2490:
2491: COMMIT;
2492:
2493:

Line 2494: END IF; /* WI__ENABLED and MSC_UTIL.G_APPS115 */

2490:
2491: COMMIT;
2492:
2493:
2494: END IF; /* WI__ENABLED and MSC_UTIL.G_APPS115 */
2495:
2496: END LOAD_RESOURCE_INSTANCE;
2497:
2498:

Line 2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'WSM_COPRODUCT_SPLIT_PERC does not exist. Using split from WSM_CO_PRODUCTS');

2541:
2542: IF nvl(v_split_table_exist,0) = 0 THEN
2543:
2544: -- old behaviour
2545: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'WSM_COPRODUCT_SPLIT_PERC does not exist. Using split from WSM_CO_PRODUCTS');
2546:
2547: v_query_str := 'Select bill_sequence_id*2,co_product_id,split,decode(nvl(primary_flag,''N''),''N'',2,1) primary_flag from wsm_co_products'||MSC_CL_PULL.v_dblink||
2548: ' where bill_sequence_id <>:v_bill_seq_id and bill_sequence_id is not null
2549: and co_product_group_id = :v_co_prd_grp_id and split > 0';

Line 2565: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'WSM_COPRODUCT_SPLIT_PERC Exists');

2561: and wsc.split > 0 -- Added this for bug:2208074
2562: and wsc.bill_Sequence_id*2 = bom.bill_Sequence_id';
2563:
2564: ELSE
2565: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'WSM_COPRODUCT_SPLIT_PERC Exists');
2566:
2567: v_query_str := 'Select wsc.bill_sequence_id*2,
2568: wsc.co_product_id,
2569: perc.split,

Line 2721: IF (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES) THEN

2717:
2718: PROCEDURE LOAD_RESOURCE_SETUP IS
2719: BEGIN
2720:
2721: IF (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES) THEN
2722: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
2723:
2724: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_SETUPS';
2725: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_SETUPS_V';

Line 2722: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

2718: PROCEDURE LOAD_RESOURCE_SETUP IS
2719: BEGIN
2720:
2721: IF (MSC_CL_PULL.BOM_ENABLED=MSC_UTIL.SYS_YES) THEN
2722: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
2723:
2724: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESOURCE_SETUPS';
2725: MSC_CL_PULL.v_view_name := 'MRP_AP_RESOURCE_SETUPS_V';
2726:

Line 2749: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2745: ||' 2,'
2746: ||' :v_refresh_id,'
2747: ||' :v_instance_id'
2748: ||' from MRP_AP_RESOURCE_SETUPS_V'||MSC_CL_PULL.v_dblink||' x'
2749: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2750:
2751: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup = '||v_sql_stmt);
2752: EXECUTE IMMEDIATE v_sql_stmt
2753: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 2751: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup = '||v_sql_stmt);

2747: ||' :v_instance_id'
2748: ||' from MRP_AP_RESOURCE_SETUPS_V'||MSC_CL_PULL.v_dblink||' x'
2749: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2750:
2751: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup = '||v_sql_stmt);
2752: EXECUTE IMMEDIATE v_sql_stmt
2753: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RESOURCE_SETUPS_V = '|| SQL%ROWCOUNT);
2755:

Line 2754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RESOURCE_SETUPS_V = '|| SQL%ROWCOUNT);

2750:
2751: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup = '||v_sql_stmt);
2752: EXECUTE IMMEDIATE v_sql_stmt
2753: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2754: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RESOURCE_SETUPS_V = '|| SQL%ROWCOUNT);
2755:
2756: COMMIT;
2757:
2758: MSC_CL_PULL.v_table_name:= 'MSC_ST_SETUP_TRANSITIONS';

Line 2787: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2783: ||' 2,'
2784: ||' :v_refresh_id,'
2785: ||' :v_instance_id'
2786: ||' from MRP_AP_SETUP_TRANSITIONS_V'||MSC_CL_PULL.v_dblink||' x'
2787: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2788:
2789: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup transition = '||v_sql_stmt);
2790: EXECUTE IMMEDIATE v_sql_stmt
2791: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 2789: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup transition = '||v_sql_stmt);

2785: ||' :v_instance_id'
2786: ||' from MRP_AP_SETUP_TRANSITIONS_V'||MSC_CL_PULL.v_dblink||' x'
2787: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2788:
2789: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup transition = '||v_sql_stmt);
2790: EXECUTE IMMEDIATE v_sql_stmt
2791: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_SETUP_TRANSITIONS_V = '|| SQL%ROWCOUNT);
2793:

Line 2792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_SETUP_TRANSITIONS_V = '|| SQL%ROWCOUNT);

2788:
2789: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap resource setup transition = '||v_sql_stmt);
2790: EXECUTE IMMEDIATE v_sql_stmt
2791: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2792: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_SETUP_TRANSITIONS_V = '|| SQL%ROWCOUNT);
2793:
2794: COMMIT;
2795:
2796: MSC_CL_PULL.v_table_name:= 'MSC_ST_STD_OP_RESOURCES';

Line 2833: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2829: ||' 2,'
2830: ||' :v_refresh_id,'
2831: ||' :v_instance_id'
2832: ||' from MRP_AP_STD_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2833: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2834:
2835: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap std op resources = '||v_sql_stmt);
2836: EXECUTE IMMEDIATE v_sql_stmt
2837: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 2835: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap std op resources = '||v_sql_stmt);

2831: ||' :v_instance_id'
2832: ||' from MRP_AP_STD_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2833: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2834:
2835: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap std op resources = '||v_sql_stmt);
2836: EXECUTE IMMEDIATE v_sql_stmt
2837: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_STD_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2839:

Line 2838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_STD_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

2834:
2835: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap std op resources = '||v_sql_stmt);
2836: EXECUTE IMMEDIATE v_sql_stmt
2837: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_STD_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2839:
2840: COMMIT;
2841:
2842: END IF; /* MSC_UTIL.G_APPS115 */

Line 2842: END IF; /* MSC_UTIL.G_APPS115 */

2838: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_STD_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2839:
2840: COMMIT;
2841:
2842: END IF; /* MSC_UTIL.G_APPS115 */
2843:
2844: END IF; /* MSC_CL_PULL.BOM_ENABLED */
2845: END LOAD_RESOURCE_SETUP;
2846: