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

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

13: v_temp_sql4 VARCHAR2(1000);
14: v_osfm_Sql varchar2(1000);
15:
16: -- NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
17: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
18:
19:
20: --===============================================
21:

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

23: PROCEDURE LOAD_ROUTING IS
24: v_get_apps_ver number;
25: BEGIN
26:
27: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
28:
29: --=================== Net Change Mode: Delete ==================
30: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
31:

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

31:
32: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTINGS';
33: MSC_CL_PULL.v_view_name := 'MRP_AD_ROUTINGS_V';
34:
35: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
36: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
37: ELSE
38: v_temp_sql := NULL;
39: END IF;

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

32: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTINGS';
33: MSC_CL_PULL.v_view_name := 'MRP_AD_ROUTINGS_V';
34:
35: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
36: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
37: ELSE
38: v_temp_sql := NULL;
39: END IF;
40:

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

63: MSC_CL_PULL.v_view_name := 'MRP_AP_ROUTINGS_V';
64:
65:
66:
67: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
68: v_osfm_sql:= 'x.first_op_seq_num,x.last_op_seq_num,';
69: ELSE
70: v_osfm_sql:= 'null,null,';
71: END IF ;

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

96: ||' 2,'
97: ||' :v_refresh_id,'
98: ||' :v_instance_id'
99: ||' FROM MRP_AP_ROUTINGS_V'||MSC_CL_PULL.v_dblink||' x'
100: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
101: ||' AND (x.RN2>'||MSC_CL_PULL.v_lrn||')';
102: /* NCP
103: ||' UNION '
104: ||' SELECT '

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

123: ||' 2,'
124: ||' :v_refresh_id,'
125: ||' :v_instance_id'
126: ||' FROM MRP_AP_ROUTINGS_V'||MSC_CL_PULL.v_dblink||' x'
127: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
128: ||' AND (x.RN3>'||MSC_CL_PULL.v_lrn||')' ;
129: */
130: ELSE
131: v_union_sql :=

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

180: ||' 2,'
181: ||' :v_refresh_id,'
182: ||' :v_instance_id'
183: ||' FROM MRP_AP_ROUTINGS_V'||MSC_CL_PULL.v_dblink||' x'
184: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
185: || v_union_sql ;
186:
187: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
188:

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

211: PROCEDURE LOAD_ROUTING_OPERATIONS IS
212: v_get_apps_ver number;
213: BEGIN
214:
215: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
216: --=================== Net Change Mode: Delete ==================
217: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
218:
219: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTING_OPERATIONS';

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

218:
219: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTING_OPERATIONS';
220: MSC_CL_PULL.v_view_name := 'MRP_AD_ROUTING_OPERATIONS_V';
221:
222: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
223: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
224: ELSE
225: v_temp_sql := NULL;
226: END IF;

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

219: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTING_OPERATIONS';
220: MSC_CL_PULL.v_view_name := 'MRP_AD_ROUTING_OPERATIONS_V';
221:
222: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
223: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
224: ELSE
225: v_temp_sql := NULL;
226: END IF;
227:

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

276: ||' 2,'
277: ||' :v_refresh_id,'
278: ||' :v_instance_id'
279: ||' FROM MRP_AP_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
280: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
281: ||' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'
282: ||' UNION '
283: ||' SELECT '
284: ||' x.OPERATION_SEQUENCE_ID, '

Line 306: ||' WHERE x.ITEM_ORG'||MSC_UTIL.v_in_org_str

302: ||' 2,'
303: ||' :v_refresh_id,'
304: ||' :v_instance_id'
305: ||' FROM MRP_AP_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
306: ||' WHERE x.ITEM_ORG'||MSC_UTIL.v_in_org_str
307: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')';
308: /*
309: ||' UNION '
310: ||' SELECT '

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

329: ||' 2,'
330: ||' :v_refresh_id,'
331: ||' :v_instance_id'
332: ||' FROM MRP_AP_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
333: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
334: ||' AND ( x.RN4>'||MSC_CL_PULL.v_lrn||')' ; */
335: ELSE
336: v_union_sql :=
337: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn

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

385: ||' 2,'
386: ||' :v_refresh_id,'
387: ||' :v_instance_id'
388: ||' FROM MRP_AP_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
389: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
390: || v_union_sql ;
391:
392: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
393:

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

414: PROCEDURE LOAD_OPERATION_RES_SEQS IS
415: v_get_apps_ver number;
416: BEGIN
417:
418: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
419: BEGIN
420: SELECT APPS_VER
421: INTO v_get_apps_ver
422: FROM MSC_APPS_INSTANCES

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

427:
428: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCE_SEQS';
429: MSC_CL_PULL.v_view_name := 'MRP_AD_OP_RESOURCE_SEQS_V';
430:
431: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
432: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
433: ELSE
434: v_temp_sql := NULL;
435: END IF;

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

428: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCE_SEQS';
429: MSC_CL_PULL.v_view_name := 'MRP_AD_OP_RESOURCE_SEQS_V';
430:
431: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
432: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
433: ELSE
434: v_temp_sql := NULL;
435: END IF;
436:

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

463: MSC_CL_PULL.v_view_name := 'MRP_AP_OP_RESOURCE_SEQS_V';
464:
465: Begin
466:
467: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
468: v_temp_sql:= ' x.net_planning_percent,';
469: ELSE
470: v_temp_sql:='NULL,' ;
471: END IF ;

Line 478: IF MSC_CL_PULL.v_apps_ver=MSC_UTIL.G_APPS107 THEN

474:
475: Begin
476:
477:
478: IF MSC_CL_PULL.v_apps_ver=MSC_UTIL.G_APPS107 THEN
479: v_temp_sql1:= 'NULL , ' ;
480: ELSE
481: v_temp_sql1:= ' x.activity_group_id, ';
482: END IF ;

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

542: ||' :v_refresh_id,'
543: ||' :v_instance_id,'
544: ||' x.ORGANIZATION_ID'
545: ||' FROM MRP_AP_OP_RESOURCE_SEQS_V'||MSC_CL_PULL.v_dblink||' x'
546: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
547: || v_union_sql ;
548:
549: --IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
550:

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

569: PROCEDURE LOAD_OPERATION_RESOURCES IS
570: v_get_apps_ver number;
571: BEGIN
572:
573: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
574: BEGIN
575: SELECT APPS_VER
576: INTO V_GET_APPS_VER
577: FROM MSC_APPS_INSTANCES

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

611: ||' :v_refresh_id,'
612: ||' :v_instance_id'
613: ||' FROM MRP_AD_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
614: ||' WHERE x.RN > '||MSC_CL_PULL.v_lrn
615: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
616:
617: else
618:
619:

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

657: then
658: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCES';
659: MSC_CL_PULL.v_view_name := 'MRP_AD_SUB_OPER_RESS_V';
660:
661: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
662: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
663: ELSE
664: v_temp_sql := NULL;
665: END IF;

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

658: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCES';
659: MSC_CL_PULL.v_view_name := 'MRP_AD_SUB_OPER_RESS_V';
660:
661: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
662: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
663: ELSE
664: v_temp_sql := NULL;
665: END IF;
666:

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

801: ||' x.ORGANIZATION_ID,'
802: ||' x.SETUP_ID,'
803: ||' x.resource_seq_num'
804: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
805: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
806: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
807: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
808: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
809: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn

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

863: ||' 2,'
864: ||' :v_refresh_id,'
865: ||' :v_instance_id'
866: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
867: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
868: ||' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'
869: */
870: ||' UNION '
871: ||' SELECT'

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

917: ||' x.ORGANIZATION_ID,'
918: ||' x.SETUP_ID,'
919: ||' x.resource_seq_num'
920: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
921: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
922: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'
923: ||' UNION '
924: ||' SELECT'
925: ||' x.ROUTING_SEQUENCE_ID,'

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

970: ||' x.ORGANIZATION_ID,'
971: ||' x.SETUP_ID,'
972: ||' x.resource_seq_num'
973: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
974: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
975: ||' AND ( x.RN4>'||MSC_CL_PULL.v_lrn||')';
976: /*
977: ||' UNION '
978: ||' SELECT'

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

1021: ||' 2,'
1022: ||' :v_refresh_id,'
1023: ||' :v_instance_id'
1024: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
1025: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1026: ||' AND ( x.RN5>'||MSC_CL_PULL.v_lrn||')' ;
1027: */
1028: ELSE
1029: v_union_sql :=

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

1102: ||' x.ORGANIZATION_ID,'
1103: ||' x.SETUP_ID,'
1104: ||' x.resource_seq_num'
1105: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
1106: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1107: || v_union_sql ;
1108:
1109: end if;
1110:

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

1160: PROCEDURE LOAD_OPERATION_COMPONENTS IS
1161: v_get_apps_ver number;
1162: BEGIN
1163:
1164: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
1165: --=================== Net Change Mode: Delete ==================
1166: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1167:
1168: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_COMPONENTS';

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

1167:
1168: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_COMPONENTS';
1169: MSC_CL_PULL.v_view_name := 'MRP_AD_OPERATION_COMPONENTS_V';
1170:
1171: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1172: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1173: ELSE
1174: v_temp_sql := NULL;
1175: END IF;

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

1168: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_COMPONENTS';
1169: MSC_CL_PULL.v_view_name := 'MRP_AD_OPERATION_COMPONENTS_V';
1170:
1171: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1172: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1173: ELSE
1174: v_temp_sql := NULL;
1175: END IF;
1176:

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

1218: ||' 2,'
1219: ||' :v_refresh_id,'
1220: ||' :v_instance_id'
1221: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'
1222: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1223: ||' AND (x.RN2> :v_lrn )'
1224: ||' UNION '
1225: ||' SELECT'
1226: ||' x.ORGANIZATION_ID,'

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

1231: ||' 2,'
1232: ||' :v_refresh_id,'
1233: ||' :v_instance_id'
1234: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'
1235: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1236: ||' AND (x.RN3> :v_lrn )'
1237: ||' UNION '
1238: ||' SELECT'
1239: ||' x.ORGANIZATION_ID,'

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

1244: ||' 2,'
1245: ||' :v_refresh_id,'
1246: ||' :v_instance_id'
1247: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'
1248: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1249: ||' AND (x.RN4> :v_lrn )'
1250: ||' UNION '
1251: ||' SELECT'
1252: ||' x.ORGANIZATION_ID,'

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

1257: ||' 2,'
1258: ||' :v_refresh_id,'
1259: ||' :v_instance_id'
1260: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'
1261: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1262: ||' AND (x.RN5> :v_lrn )'
1263: ||' UNION '
1264: ||' SELECT'
1265: ||' x.ORGANIZATION_ID,'

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

1270: ||' 2,'
1271: ||' :v_refresh_id,'
1272: ||' :v_instance_id'
1273: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'
1274: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1275: ||' AND (x.RN6> :v_lrn )' ;
1276: ELSE
1277: v_union_sql := ' ';
1278:

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

1298: ||' 2,'
1299: ||' :v_refresh_id,'
1300: ||' :v_instance_id'
1301: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'
1302: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1303: || v_union_sql ;
1304:
1305: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1306: