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 545: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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