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_CL_PULL

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 30: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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:
32: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTINGS';
33: MSC_CL_PULL.v_view_name := 'MRP_AD_ROUTINGS_V';
34:

Line 32: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTINGS';

28:
29: --=================== Net Change Mode: Delete ==================
30: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
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;

Line 33: MSC_CL_PULL.v_view_name := 'MRP_AD_ROUTINGS_V';

29: --=================== Net Change Mode: Delete ==================
30: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
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

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 52: ||' FROM MRP_AD_ROUTINGS_V'||MSC_CL_PULL.v_dblink||' x'

48: ||' x.ROUTING_SEQUENCE_ID,'
49: ||' 1,'
50: ||' :v_refresh_id,'
51: ||' :v_instance_id'
52: ||' FROM MRP_AD_ROUTINGS_V'||MSC_CL_PULL.v_dblink||' x'
53: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
54: || v_temp_sql;
55:
56: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 53: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn

49: ||' 1,'
50: ||' :v_refresh_id,'
51: ||' :v_instance_id'
52: ||' FROM MRP_AD_ROUTINGS_V'||MSC_CL_PULL.v_dblink||' x'
53: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
54: || v_temp_sql;
55:
56: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
57:

Line 56: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

52: ||' FROM MRP_AD_ROUTINGS_V'||MSC_CL_PULL.v_dblink||' x'
53: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
54: || v_temp_sql;
55:
56: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
57:
58: COMMIT;
59:
60: END IF;

Line 62: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTINGS';

58: COMMIT;
59:
60: END IF;
61:
62: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTINGS';
63: MSC_CL_PULL.v_view_name := 'MRP_AP_ROUTINGS_V';
64:
65:
66:

Line 63: MSC_CL_PULL.v_view_name := 'MRP_AP_ROUTINGS_V';

59:
60: END IF;
61:
62: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTINGS';
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

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 73: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

69: ELSE
70: v_osfm_sql:= 'null,null,';
71: END IF ;
72:
73: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
74: v_union_sql :=
75: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn||')'
76: ||' UNION '
77: ||' SELECT '

Line 75: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn||')'

71: END IF ;
72:
73: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
74: v_union_sql :=
75: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn||')'
76: ||' UNION '
77: ||' SELECT '
78: ||' x.ROUTING_SEQUENCE_ID,'
79: ||' x.ASSEMBLY_ITEM_ID,'

Line 99: ||' FROM MRP_AP_ROUTINGS_V'||MSC_CL_PULL.v_dblink||' x'

95: ||' x.ORGANIZATION_ID,'
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 '

Line 101: ||' AND (x.RN2>'||MSC_CL_PULL.v_lrn||')';

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 '
105: ||' x.ROUTING_SEQUENCE_ID,'

Line 126: ||' FROM MRP_AP_ROUTINGS_V'||MSC_CL_PULL.v_dblink||' x'

122: ||' x.ORGANIZATION_ID,'
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

Line 128: ||' AND (x.RN3>'||MSC_CL_PULL.v_lrn||')' ;

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 :=
132: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn

Line 132: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn

128: ||' AND (x.RN3>'||MSC_CL_PULL.v_lrn||')' ;
129: */
130: ELSE
131: v_union_sql :=
132: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
133: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
134: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
135: END IF;
136:

Line 133: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

129: */
130: ELSE
131: v_union_sql :=
132: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
133: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
134: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
135: END IF;
136:
137: v_sql_stmt:=

Line 134: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';

130: ELSE
131: v_union_sql :=
132: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
133: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
134: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
135: END IF;
136:
137: v_sql_stmt:=
138: ' INSERT INTO MSC_ST_ROUTINGS'

Line 183: ||' FROM MRP_AP_ROUTINGS_V'||MSC_CL_PULL.v_dblink||' x'

179: ||' x.ORGANIZATION_ID,'
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

Line 187: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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:
189: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
190: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
191:

Line 189: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

185: || v_union_sql ;
186:
187: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
188:
189: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
190: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
191:
192: /* MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
193: */

Line 190: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

186:
187: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
188:
189: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
190: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
191:
192: /* MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
193: */
194:

Line 192: /* MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

188:
189: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
190: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
191:
192: /* MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
193: */
194:
195: ELSE
196:

Line 198: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

194:
195: ELSE
196:
197:
198: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
199:
200:
201: END IF;
202:

Line 206: END IF; -- MSC_CL_PULL.BOM_ENABLED

202:
203: COMMIT;
204:
205:
206: END IF; -- MSC_CL_PULL.BOM_ENABLED
207:
208: END LOAD_ROUTING;
209:
210:

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 217: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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';
220: MSC_CL_PULL.v_view_name := 'MRP_AD_ROUTING_OPERATIONS_V';
221:

Line 219: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTING_OPERATIONS';

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';
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;

Line 220: MSC_CL_PULL.v_view_name := 'MRP_AD_ROUTING_OPERATIONS_V';

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';
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

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 241: ||' FROM MRP_AD_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'

237: ||' x.ROUTING_SEQUENCE_ID, '
238: ||' 1,'
239: ||' :v_refresh_id,'
240: ||' :v_instance_id'
241: ||' FROM MRP_AD_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
242: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
243: || v_temp_sql;
244:
245: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 242: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn

238: ||' 1,'
239: ||' :v_refresh_id,'
240: ||' :v_instance_id'
241: ||' FROM MRP_AD_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
242: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
243: || v_temp_sql;
244:
245: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
246:

Line 245: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

241: ||' FROM MRP_AD_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
242: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
243: || v_temp_sql;
244:
245: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
246:
247: COMMIT;
248:
249: END IF;

Line 251: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTING_OPERATIONS';

247: COMMIT;
248:
249: END IF;
250:
251: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTING_OPERATIONS';
252: MSC_CL_PULL.v_view_name := 'MRP_AP_ROUTING_OPERATIONS_V';
253: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
254: v_union_sql :=
255: ' AND ( x.RN1>'||MSC_CL_PULL.v_lrn||')'

Line 252: MSC_CL_PULL.v_view_name := 'MRP_AP_ROUTING_OPERATIONS_V';

248:
249: END IF;
250:
251: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTING_OPERATIONS';
252: MSC_CL_PULL.v_view_name := 'MRP_AP_ROUTING_OPERATIONS_V';
253: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
254: v_union_sql :=
255: ' AND ( x.RN1>'||MSC_CL_PULL.v_lrn||')'
256: ||' UNION '

Line 253: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

249: END IF;
250:
251: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTING_OPERATIONS';
252: MSC_CL_PULL.v_view_name := 'MRP_AP_ROUTING_OPERATIONS_V';
253: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
254: v_union_sql :=
255: ' AND ( x.RN1>'||MSC_CL_PULL.v_lrn||')'
256: ||' UNION '
257: ||' SELECT '

Line 255: ' AND ( x.RN1>'||MSC_CL_PULL.v_lrn||')'

251: MSC_CL_PULL.v_table_name:= 'MSC_ST_ROUTING_OPERATIONS';
252: MSC_CL_PULL.v_view_name := 'MRP_AP_ROUTING_OPERATIONS_V';
253: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
254: v_union_sql :=
255: ' AND ( x.RN1>'||MSC_CL_PULL.v_lrn||')'
256: ||' UNION '
257: ||' SELECT '
258: ||' x.OPERATION_SEQUENCE_ID, '
259: ||' x.ROUTING_SEQUENCE_ID, '

Line 279: ||' FROM MRP_AP_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'

275: ||' x.STANDARD_OPERATION_CODE,'
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 '

Line 281: ||' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'

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, '
285: ||' x.ROUTING_SEQUENCE_ID, '

Line 305: ||' FROM MRP_AP_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'

301: ||' x.STANDARD_OPERATION_CODE,'
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 '

Line 307: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')';

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 '
311: ||' x.OPERATION_SEQUENCE_ID, '

Line 332: ||' FROM MRP_AP_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'

328: ||' x.STANDARD_OPERATION_CODE,'
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 :=

Line 334: ||' AND ( x.RN4>'||MSC_CL_PULL.v_lrn||')' ; */

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
338: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

Line 337: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn

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
338: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
339: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
340: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
341: END IF;

Line 338: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

334: ||' AND ( x.RN4>'||MSC_CL_PULL.v_lrn||')' ; */
335: ELSE
336: v_union_sql :=
337: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
338: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
339: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
340: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
341: END IF;
342:

Line 339: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn

335: ELSE
336: v_union_sql :=
337: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
338: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
339: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
340: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
341: END IF;
342:
343: v_sql_stmt:=

Line 340: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';

336: v_union_sql :=
337: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
338: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
339: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
340: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
341: END IF;
342:
343: v_sql_stmt:=
344: ' INSERT INTO MSC_ST_ROUTING_OPERATIONS'

Line 388: ||' FROM MRP_AP_ROUTING_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'

384: ||' x.STANDARD_OPERATION_CODE,'
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

Line 392: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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:
394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
395: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
396: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

390: || v_union_sql ;
391:
392: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
393:
394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
395: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
396: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
397: /*
398: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 395: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

391:
392: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
393:
394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
395: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
396: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
397: /*
398: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
399: */

Line 396: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

392: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
393:
394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
395: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
396: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
397: /*
398: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
399: */
400:

Line 398: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
395: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
396: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
397: /*
398: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
399: */
400:
401: ELSE
402:

Line 404: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

400:
401: ELSE
402:
403:
404: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
405:
406:
407: END IF;
408:

Line 411: END IF; -- MSC_CL_PULL.BOM_ENABLED

407: END IF;
408:
409: COMMIT;
410:
411: END IF; -- MSC_CL_PULL.BOM_ENABLED
412:
413: END LOAD_ROUTING_OPERATIONS;
414: PROCEDURE LOAD_OPERATION_RES_SEQS IS
415: v_get_apps_ver number;

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 423: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;

419: BEGIN
420: SELECT APPS_VER
421: INTO v_get_apps_ver
422: FROM MSC_APPS_INSTANCES
423: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
424: END;
425: --=================== Net Change Mode: Delete ==================
426: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
427:

Line 426: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

422: FROM MSC_APPS_INSTANCES
423: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
424: END;
425: --=================== Net Change Mode: Delete ==================
426: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
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:

Line 428: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCE_SEQS';

424: END;
425: --=================== Net Change Mode: Delete ==================
426: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
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;

Line 429: MSC_CL_PULL.v_view_name := 'MRP_AD_OP_RESOURCE_SEQS_V';

425: --=================== Net Change Mode: Delete ==================
426: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
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

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 452: ||' FROM MRP_AD_OP_RESOURCE_SEQS_V'||MSC_CL_PULL.v_dblink||' x'

448: ||' x.RESOURCE_SEQ_NUM,'
449: ||' 1,'
450: ||' :v_refresh_id,'
451: ||' :v_instance_id'
452: ||' FROM MRP_AD_OP_RESOURCE_SEQS_V'||MSC_CL_PULL.v_dblink||' x'
453: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
454: || v_temp_sql;
455:
456: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 453: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn

449: ||' 1,'
450: ||' :v_refresh_id,'
451: ||' :v_instance_id'
452: ||' FROM MRP_AD_OP_RESOURCE_SEQS_V'||MSC_CL_PULL.v_dblink||' x'
453: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
454: || v_temp_sql;
455:
456: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
457:

Line 456: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

452: ||' FROM MRP_AD_OP_RESOURCE_SEQS_V'||MSC_CL_PULL.v_dblink||' x'
453: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
454: || v_temp_sql;
455:
456: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
457:
458: COMMIT;
459:
460: END IF;

Line 462: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCE_SEQS';

458: COMMIT;
459:
460: END IF;
461:
462: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCE_SEQS';
463: MSC_CL_PULL.v_view_name := 'MRP_AP_OP_RESOURCE_SEQS_V';
464:
465: Begin
466:

Line 463: MSC_CL_PULL.v_view_name := 'MRP_AP_OP_RESOURCE_SEQS_V';

459:
460: END IF;
461:
462: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCE_SEQS';
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

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 486: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

482: END IF ;
483:
484: End;
485:
486: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
487: v_union_sql :=
488: ' AND (x.RN2>'||MSC_CL_PULL.v_lrn
489: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
490: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn

Line 488: ' AND (x.RN2>'||MSC_CL_PULL.v_lrn

484: End;
485:
486: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
487: v_union_sql :=
488: ' AND (x.RN2>'||MSC_CL_PULL.v_lrn
489: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
490: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
491: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
492: ELSE

Line 489: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn

485:
486: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
487: v_union_sql :=
488: ' AND (x.RN2>'||MSC_CL_PULL.v_lrn
489: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
490: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
491: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
492: ELSE
493: v_union_sql :=

Line 490: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn

486: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
487: v_union_sql :=
488: ' AND (x.RN2>'||MSC_CL_PULL.v_lrn
489: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
490: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
491: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
492: ELSE
493: v_union_sql :=
494: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn

Line 491: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';

487: v_union_sql :=
488: ' AND (x.RN2>'||MSC_CL_PULL.v_lrn
489: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
490: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
491: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
492: ELSE
493: v_union_sql :=
494: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
495: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

Line 494: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn

490: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
491: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
492: ELSE
493: v_union_sql :=
494: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
495: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
496: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
497: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
498: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';

Line 495: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

491: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
492: ELSE
493: v_union_sql :=
494: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
495: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
496: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
497: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
498: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
499: END IF;

Line 496: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn

492: ELSE
493: v_union_sql :=
494: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
495: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
496: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
497: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
498: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
499: END IF;
500:

Line 497: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn

493: v_union_sql :=
494: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
495: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
496: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
497: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
498: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
499: END IF;
500:
501: v_sql_stmt:=

Line 498: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';

494: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
495: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
496: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
497: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
498: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
499: END IF;
500:
501: v_sql_stmt:=
502: ' INSERT INTO MSC_ST_OPERATION_RESOURCE_SEQS'

Line 544: ||' FROM MRP_AP_OP_RESOURCE_SEQS_V'||MSC_CL_PULL.v_dblink||' x'

540: ||' 2,'
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

Line 548: --IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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:
550: EXECUTE IMMEDIATE v_sql_stmt
551: USING v_get_apps_ver,
552: MSC_CL_PULL.v_msc_simul_res_seq,

Line 552: MSC_CL_PULL.v_msc_simul_res_seq,

548: --IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
549:
550: EXECUTE IMMEDIATE v_sql_stmt
551: USING v_get_apps_ver,
552: MSC_CL_PULL.v_msc_simul_res_seq,
553: MSC_CL_PULL.v_refresh_id,
554: MSC_CL_PULL.v_instance_id;
555:
556:

Line 553: MSC_CL_PULL.v_refresh_id,

549:
550: EXECUTE IMMEDIATE v_sql_stmt
551: USING v_get_apps_ver,
552: MSC_CL_PULL.v_msc_simul_res_seq,
553: MSC_CL_PULL.v_refresh_id,
554: MSC_CL_PULL.v_instance_id;
555:
556:
557: --ELSE

Line 554: MSC_CL_PULL.v_instance_id;

550: EXECUTE IMMEDIATE v_sql_stmt
551: USING v_get_apps_ver,
552: MSC_CL_PULL.v_msc_simul_res_seq,
553: MSC_CL_PULL.v_refresh_id,
554: MSC_CL_PULL.v_instance_id;
555:
556:
557: --ELSE
558:

Line 565: END IF; -- MSC_CL_PULL.BOM_ENABLED

561: --END IF;
562:
563: COMMIT;
564:
565: END IF; -- MSC_CL_PULL.BOM_ENABLED
566:
567: END LOAD_OPERATION_RES_SEQS;
568: PROCEDURE LOAD_OPERATION_RESOURCES IS
569: v_get_apps_ver number;

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 577: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;

573: BEGIN
574: SELECT APPS_VER
575: INTO V_GET_APPS_VER
576: FROM MSC_APPS_INSTANCES
577: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
578: END;
579: --=================== Net Change Mode: Delete ==================
580: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
581:

Line 580: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

576: FROM MSC_APPS_INSTANCES
577: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
578: END;
579: --=================== Net Change Mode: Delete ==================
580: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
581:
582: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCES';
583: MSC_CL_PULL.v_view_name := 'MRP_AD_OPERATION_RESOURCES_V';
584: BEGIN

Line 582: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCES';

578: END;
579: --=================== Net Change Mode: Delete ==================
580: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
581:
582: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCES';
583: MSC_CL_PULL.v_view_name := 'MRP_AD_OPERATION_RESOURCES_V';
584: BEGIN
585: SELECT APPS_VER
586: INTO V_GET_APPS_VER

Line 583: MSC_CL_PULL.v_view_name := 'MRP_AD_OPERATION_RESOURCES_V';

579: --=================== Net Change Mode: Delete ==================
580: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
581:
582: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCES';
583: MSC_CL_PULL.v_view_name := 'MRP_AD_OPERATION_RESOURCES_V';
584: BEGIN
585: SELECT APPS_VER
586: INTO V_GET_APPS_VER
587: FROM MSC_APPS_INSTANCES

Line 588: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;

584: BEGIN
585: SELECT APPS_VER
586: INTO V_GET_APPS_VER
587: FROM MSC_APPS_INSTANCES
588: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
589: END;
590:
591: if v_get_apps_ver >= 3
592: then

Line 612: ||' FROM MRP_AD_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

608: ||' x.ALTERNATE_NUMBER,' -- **
609: ||' 1,'
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

Line 613: ||' WHERE x.RN > '||MSC_CL_PULL.v_lrn

609: ||' 1,'
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:

Line 638: ||' FROM MRP_AD_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

634: ||' x.ALTERNATE_NUMBER,' -- **
635: ||' 1,'
636: ||' :v_refresh_id,'
637: ||' :v_instance_id'
638: ||' FROM MRP_AD_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
639: ||' WHERE x.RN > '||MSC_CL_PULL.v_lrn;
640:
641: end if;
642:

Line 639: ||' WHERE x.RN > '||MSC_CL_PULL.v_lrn;

635: ||' 1,'
636: ||' :v_refresh_id,'
637: ||' :v_instance_id'
638: ||' FROM MRP_AD_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
639: ||' WHERE x.RN > '||MSC_CL_PULL.v_lrn;
640:
641: end if;
642:
643: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 643: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

639: ||' WHERE x.RN > '||MSC_CL_PULL.v_lrn;
640:
641: end if;
642:
643: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
644:
645: COMMIT;
646:
647:

Line 652: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;

648: BEGIN
649: SELECT APPS_VER
650: INTO V_GET_APPS_VER
651: FROM MSC_APPS_INSTANCES
652: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
653: END;
654:
655: if V_GET_APPS_VER >= 3
656: then

Line 657: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCES';

653: END;
654:
655: if V_GET_APPS_VER >= 3
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;

Line 658: MSC_CL_PULL.v_view_name := 'MRP_AD_SUB_OPER_RESS_V';

654:
655: if V_GET_APPS_VER >= 3
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

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 685: ||' FROM MRP_AD_SUB_OPER_RESS_V'||MSC_CL_PULL.v_dblink||' x'

681: ||' x.ALTERNATE_NUMBER,' -- **
682: ||' 1,'
683: ||' :v_refresh_id,'
684: ||' :v_instance_id'
685: ||' FROM MRP_AD_SUB_OPER_RESS_V'||MSC_CL_PULL.v_dblink||' x'
686: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
687: || v_temp_sql;
688:
689: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 686: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn

682: ||' 1,'
683: ||' :v_refresh_id,'
684: ||' :v_instance_id'
685: ||' FROM MRP_AD_SUB_OPER_RESS_V'||MSC_CL_PULL.v_dblink||' x'
686: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
687: || v_temp_sql;
688:
689: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
690:

Line 689: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

685: ||' FROM MRP_AD_SUB_OPER_RESS_V'||MSC_CL_PULL.v_dblink||' x'
686: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
687: || v_temp_sql;
688:
689: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
690:
691: COMMIT;
692:
693: END IF;

Line 697: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCES';

693: END IF;
694:
695: END IF;
696:
697: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCES';
698: MSC_CL_PULL.v_view_name := 'MRP_AP_OPERATION_RESOURCES_V';
699:
700: BEGIN
701: SELECT APPS_VER

Line 698: MSC_CL_PULL.v_view_name := 'MRP_AP_OPERATION_RESOURCES_V';

694:
695: END IF;
696:
697: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_RESOURCES';
698: MSC_CL_PULL.v_view_name := 'MRP_AP_OPERATION_RESOURCES_V';
699:
700: BEGIN
701: SELECT APPS_VER
702: INTO V_GET_APPS_VER

Line 704: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;

700: BEGIN
701: SELECT APPS_VER
702: INTO V_GET_APPS_VER
703: FROM MSC_APPS_INSTANCES
704: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;
705: END;
706:
707: if v_get_apps_ver >= 3
708: then

Line 802: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

798: ||' :v_instance_id,'
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

Line 804: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn

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
808: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';

Line 805: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

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
808: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
809:

Line 806: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn

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
808: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
809:
810:

Line 807: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn

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
808: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
809:
810:
811: else

Line 808: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';

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
808: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
809:
810:
811: else
812:

Line 813: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

809:
810:
811: else
812:
813: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
814: v_union_sql :=
815: ' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'
816: /*
817: ||' UNION '

Line 815: ' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'

811: else
812:
813: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
814: v_union_sql :=
815: ' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'
816: /*
817: ||' UNION '
818: ||' SELECT'
819: ||' x.ROUTING_SEQUENCE_ID,'

Line 864: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

860: ||' x.PRINCIPAL_FLAG,' -- **
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 '

Line 866: ||' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'

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'
870: ||' x.ROUTING_SEQUENCE_ID,'

Line 918: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

914: ||' :v_instance_id,'
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'

Line 920: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'

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,'
924: ||' x.OPERATION_SEQUENCE_ID,'

Line 971: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

967: ||' :v_instance_id,'
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 '

Line 973: ||' AND ( x.RN4>'||MSC_CL_PULL.v_lrn||')';

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'
977: ||' x.ROUTING_SEQUENCE_ID,'

Line 1022: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

1018: ||' x.PRINCIPAL_FLAG,' -- **
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

Line 1024: ||' AND ( x.RN5>'||MSC_CL_PULL.v_lrn||')' ;

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 :=
1028: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn

Line 1028: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn

1024: ||' AND ( x.RN5>'||MSC_CL_PULL.v_lrn||')' ;
1025: */
1026: ELSE
1027: v_union_sql :=
1028: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1029: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1030: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1031: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1032: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';

Line 1029: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn

1025: */
1026: ELSE
1027: v_union_sql :=
1028: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1029: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1030: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1031: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1032: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
1033: END IF;

Line 1030: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn

1026: ELSE
1027: v_union_sql :=
1028: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1029: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1030: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1031: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1032: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
1033: END IF;
1034: v_sql_stmt:=

Line 1031: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn

1027: v_union_sql :=
1028: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1029: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1030: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1031: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1032: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
1033: END IF;
1034: v_sql_stmt:=
1035: ' INSERT INTO MSC_ST_OPERATION_RESOURCES'

Line 1032: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';

1028: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1029: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1030: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1031: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1032: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn||')';
1033: END IF;
1034: v_sql_stmt:=
1035: ' INSERT INTO MSC_ST_OPERATION_RESOURCES'
1036: ||' ( ROUTING_SEQUENCE_ID,'

Line 1103: ||' FROM MRP_AP_OPERATION_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

1099: ||' :v_instance_id,'
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;

Line 1111: EXECUTE IMMEDIATE v_sql_stmt USING v_get_apps_ver,MSC_CL_PULL.v_msc_simul_res_seq,

1107: end if;
1108:
1109: if v_get_apps_ver >= 3
1110: then
1111: EXECUTE IMMEDIATE v_sql_stmt USING v_get_apps_ver,MSC_CL_PULL.v_msc_simul_res_seq,
1112: v_get_apps_ver,
1113: MSC_CL_PULL.v_msc_alt_res_priority,
1114: MSC_CL_PULL.v_refresh_id,
1115: MSC_CL_PULL.v_instance_id;

Line 1113: MSC_CL_PULL.v_msc_alt_res_priority,

1109: if v_get_apps_ver >= 3
1110: then
1111: EXECUTE IMMEDIATE v_sql_stmt USING v_get_apps_ver,MSC_CL_PULL.v_msc_simul_res_seq,
1112: v_get_apps_ver,
1113: MSC_CL_PULL.v_msc_alt_res_priority,
1114: MSC_CL_PULL.v_refresh_id,
1115: MSC_CL_PULL.v_instance_id;
1116:
1117: else

Line 1114: MSC_CL_PULL.v_refresh_id,

1110: then
1111: EXECUTE IMMEDIATE v_sql_stmt USING v_get_apps_ver,MSC_CL_PULL.v_msc_simul_res_seq,
1112: v_get_apps_ver,
1113: MSC_CL_PULL.v_msc_alt_res_priority,
1114: MSC_CL_PULL.v_refresh_id,
1115: MSC_CL_PULL.v_instance_id;
1116:
1117: else
1118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 1115: MSC_CL_PULL.v_instance_id;

1111: EXECUTE IMMEDIATE v_sql_stmt USING v_get_apps_ver,MSC_CL_PULL.v_msc_simul_res_seq,
1112: v_get_apps_ver,
1113: MSC_CL_PULL.v_msc_alt_res_priority,
1114: MSC_CL_PULL.v_refresh_id,
1115: MSC_CL_PULL.v_instance_id;
1116:
1117: else
1118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1119:

Line 1118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

1114: MSC_CL_PULL.v_refresh_id,
1115: MSC_CL_PULL.v_instance_id;
1116:
1117: else
1118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1119:
1120: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,
1121: MSC_CL_PULL.v_msc_alt_res_priority,
1122: MSC_CL_PULL.v_refresh_id,

Line 1120: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,

1116:
1117: else
1118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1119:
1120: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,
1121: MSC_CL_PULL.v_msc_alt_res_priority,
1122: MSC_CL_PULL.v_refresh_id,
1123: MSC_CL_PULL.v_instance_id,
1124: MSC_CL_PULL.v_msc_simul_res_seq,

Line 1121: MSC_CL_PULL.v_msc_alt_res_priority,

1117: else
1118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1119:
1120: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,
1121: MSC_CL_PULL.v_msc_alt_res_priority,
1122: MSC_CL_PULL.v_refresh_id,
1123: MSC_CL_PULL.v_instance_id,
1124: MSC_CL_PULL.v_msc_simul_res_seq,
1125: MSC_CL_PULL.v_msc_alt_res_priority,

Line 1122: MSC_CL_PULL.v_refresh_id,

1118: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1119:
1120: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,
1121: MSC_CL_PULL.v_msc_alt_res_priority,
1122: MSC_CL_PULL.v_refresh_id,
1123: MSC_CL_PULL.v_instance_id,
1124: MSC_CL_PULL.v_msc_simul_res_seq,
1125: MSC_CL_PULL.v_msc_alt_res_priority,
1126: MSC_CL_PULL.v_refresh_id,

Line 1123: MSC_CL_PULL.v_instance_id,

1119:
1120: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,
1121: MSC_CL_PULL.v_msc_alt_res_priority,
1122: MSC_CL_PULL.v_refresh_id,
1123: MSC_CL_PULL.v_instance_id,
1124: MSC_CL_PULL.v_msc_simul_res_seq,
1125: MSC_CL_PULL.v_msc_alt_res_priority,
1126: MSC_CL_PULL.v_refresh_id,
1127: MSC_CL_PULL.v_instance_id,

Line 1124: MSC_CL_PULL.v_msc_simul_res_seq,

1120: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,
1121: MSC_CL_PULL.v_msc_alt_res_priority,
1122: MSC_CL_PULL.v_refresh_id,
1123: MSC_CL_PULL.v_instance_id,
1124: MSC_CL_PULL.v_msc_simul_res_seq,
1125: MSC_CL_PULL.v_msc_alt_res_priority,
1126: MSC_CL_PULL.v_refresh_id,
1127: MSC_CL_PULL.v_instance_id,
1128: MSC_CL_PULL.v_msc_simul_res_seq,

Line 1125: MSC_CL_PULL.v_msc_alt_res_priority,

1121: MSC_CL_PULL.v_msc_alt_res_priority,
1122: MSC_CL_PULL.v_refresh_id,
1123: MSC_CL_PULL.v_instance_id,
1124: MSC_CL_PULL.v_msc_simul_res_seq,
1125: MSC_CL_PULL.v_msc_alt_res_priority,
1126: MSC_CL_PULL.v_refresh_id,
1127: MSC_CL_PULL.v_instance_id,
1128: MSC_CL_PULL.v_msc_simul_res_seq,
1129: MSC_CL_PULL.v_msc_alt_res_priority,

Line 1126: MSC_CL_PULL.v_refresh_id,

1122: MSC_CL_PULL.v_refresh_id,
1123: MSC_CL_PULL.v_instance_id,
1124: MSC_CL_PULL.v_msc_simul_res_seq,
1125: MSC_CL_PULL.v_msc_alt_res_priority,
1126: MSC_CL_PULL.v_refresh_id,
1127: MSC_CL_PULL.v_instance_id,
1128: MSC_CL_PULL.v_msc_simul_res_seq,
1129: MSC_CL_PULL.v_msc_alt_res_priority,
1130: MSC_CL_PULL.v_refresh_id,

Line 1127: MSC_CL_PULL.v_instance_id,

1123: MSC_CL_PULL.v_instance_id,
1124: MSC_CL_PULL.v_msc_simul_res_seq,
1125: MSC_CL_PULL.v_msc_alt_res_priority,
1126: MSC_CL_PULL.v_refresh_id,
1127: MSC_CL_PULL.v_instance_id,
1128: MSC_CL_PULL.v_msc_simul_res_seq,
1129: MSC_CL_PULL.v_msc_alt_res_priority,
1130: MSC_CL_PULL.v_refresh_id,
1131: MSC_CL_PULL.v_instance_id;

Line 1128: MSC_CL_PULL.v_msc_simul_res_seq,

1124: MSC_CL_PULL.v_msc_simul_res_seq,
1125: MSC_CL_PULL.v_msc_alt_res_priority,
1126: MSC_CL_PULL.v_refresh_id,
1127: MSC_CL_PULL.v_instance_id,
1128: MSC_CL_PULL.v_msc_simul_res_seq,
1129: MSC_CL_PULL.v_msc_alt_res_priority,
1130: MSC_CL_PULL.v_refresh_id,
1131: MSC_CL_PULL.v_instance_id;
1132: /*

Line 1129: MSC_CL_PULL.v_msc_alt_res_priority,

1125: MSC_CL_PULL.v_msc_alt_res_priority,
1126: MSC_CL_PULL.v_refresh_id,
1127: MSC_CL_PULL.v_instance_id,
1128: MSC_CL_PULL.v_msc_simul_res_seq,
1129: MSC_CL_PULL.v_msc_alt_res_priority,
1130: MSC_CL_PULL.v_refresh_id,
1131: MSC_CL_PULL.v_instance_id;
1132: /*
1133: MSC_CL_PULL.v_msc_simul_res_seq,

Line 1130: MSC_CL_PULL.v_refresh_id,

1126: MSC_CL_PULL.v_refresh_id,
1127: MSC_CL_PULL.v_instance_id,
1128: MSC_CL_PULL.v_msc_simul_res_seq,
1129: MSC_CL_PULL.v_msc_alt_res_priority,
1130: MSC_CL_PULL.v_refresh_id,
1131: MSC_CL_PULL.v_instance_id;
1132: /*
1133: MSC_CL_PULL.v_msc_simul_res_seq,
1134: MSC_CL_PULL.v_msc_alt_res_priority,

Line 1131: MSC_CL_PULL.v_instance_id;

1127: MSC_CL_PULL.v_instance_id,
1128: MSC_CL_PULL.v_msc_simul_res_seq,
1129: MSC_CL_PULL.v_msc_alt_res_priority,
1130: MSC_CL_PULL.v_refresh_id,
1131: MSC_CL_PULL.v_instance_id;
1132: /*
1133: MSC_CL_PULL.v_msc_simul_res_seq,
1134: MSC_CL_PULL.v_msc_alt_res_priority,
1135: MSC_CL_PULL.v_refresh_id,

Line 1133: MSC_CL_PULL.v_msc_simul_res_seq,

1129: MSC_CL_PULL.v_msc_alt_res_priority,
1130: MSC_CL_PULL.v_refresh_id,
1131: MSC_CL_PULL.v_instance_id;
1132: /*
1133: MSC_CL_PULL.v_msc_simul_res_seq,
1134: MSC_CL_PULL.v_msc_alt_res_priority,
1135: MSC_CL_PULL.v_refresh_id,
1136: MSC_CL_PULL.v_instance_id,
1137: MSC_CL_PULL.v_msc_simul_res_seq,

Line 1134: MSC_CL_PULL.v_msc_alt_res_priority,

1130: MSC_CL_PULL.v_refresh_id,
1131: MSC_CL_PULL.v_instance_id;
1132: /*
1133: MSC_CL_PULL.v_msc_simul_res_seq,
1134: MSC_CL_PULL.v_msc_alt_res_priority,
1135: MSC_CL_PULL.v_refresh_id,
1136: MSC_CL_PULL.v_instance_id,
1137: MSC_CL_PULL.v_msc_simul_res_seq,
1138: MSC_CL_PULL.v_msc_alt_res_priority,

Line 1135: MSC_CL_PULL.v_refresh_id,

1131: MSC_CL_PULL.v_instance_id;
1132: /*
1133: MSC_CL_PULL.v_msc_simul_res_seq,
1134: MSC_CL_PULL.v_msc_alt_res_priority,
1135: MSC_CL_PULL.v_refresh_id,
1136: MSC_CL_PULL.v_instance_id,
1137: MSC_CL_PULL.v_msc_simul_res_seq,
1138: MSC_CL_PULL.v_msc_alt_res_priority,
1139: MSC_CL_PULL.v_refresh_id,

Line 1136: MSC_CL_PULL.v_instance_id,

1132: /*
1133: MSC_CL_PULL.v_msc_simul_res_seq,
1134: MSC_CL_PULL.v_msc_alt_res_priority,
1135: MSC_CL_PULL.v_refresh_id,
1136: MSC_CL_PULL.v_instance_id,
1137: MSC_CL_PULL.v_msc_simul_res_seq,
1138: MSC_CL_PULL.v_msc_alt_res_priority,
1139: MSC_CL_PULL.v_refresh_id,
1140: MSC_CL_PULL.v_instance_id;

Line 1137: MSC_CL_PULL.v_msc_simul_res_seq,

1133: MSC_CL_PULL.v_msc_simul_res_seq,
1134: MSC_CL_PULL.v_msc_alt_res_priority,
1135: MSC_CL_PULL.v_refresh_id,
1136: MSC_CL_PULL.v_instance_id,
1137: MSC_CL_PULL.v_msc_simul_res_seq,
1138: MSC_CL_PULL.v_msc_alt_res_priority,
1139: MSC_CL_PULL.v_refresh_id,
1140: MSC_CL_PULL.v_instance_id;
1141: */

Line 1138: MSC_CL_PULL.v_msc_alt_res_priority,

1134: MSC_CL_PULL.v_msc_alt_res_priority,
1135: MSC_CL_PULL.v_refresh_id,
1136: MSC_CL_PULL.v_instance_id,
1137: MSC_CL_PULL.v_msc_simul_res_seq,
1138: MSC_CL_PULL.v_msc_alt_res_priority,
1139: MSC_CL_PULL.v_refresh_id,
1140: MSC_CL_PULL.v_instance_id;
1141: */
1142:

Line 1139: MSC_CL_PULL.v_refresh_id,

1135: MSC_CL_PULL.v_refresh_id,
1136: MSC_CL_PULL.v_instance_id,
1137: MSC_CL_PULL.v_msc_simul_res_seq,
1138: MSC_CL_PULL.v_msc_alt_res_priority,
1139: MSC_CL_PULL.v_refresh_id,
1140: MSC_CL_PULL.v_instance_id;
1141: */
1142:
1143: ELSE

Line 1140: MSC_CL_PULL.v_instance_id;

1136: MSC_CL_PULL.v_instance_id,
1137: MSC_CL_PULL.v_msc_simul_res_seq,
1138: MSC_CL_PULL.v_msc_alt_res_priority,
1139: MSC_CL_PULL.v_refresh_id,
1140: MSC_CL_PULL.v_instance_id;
1141: */
1142:
1143: ELSE
1144:

Line 1146: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,

1142:
1143: ELSE
1144:
1145:
1146: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,
1147: MSC_CL_PULL.v_msc_alt_res_priority,
1148: MSC_CL_PULL.v_refresh_id,
1149: MSC_CL_PULL.v_instance_id;
1150:

Line 1147: MSC_CL_PULL.v_msc_alt_res_priority,

1143: ELSE
1144:
1145:
1146: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,
1147: MSC_CL_PULL.v_msc_alt_res_priority,
1148: MSC_CL_PULL.v_refresh_id,
1149: MSC_CL_PULL.v_instance_id;
1150:
1151: END IF;

Line 1148: MSC_CL_PULL.v_refresh_id,

1144:
1145:
1146: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,
1147: MSC_CL_PULL.v_msc_alt_res_priority,
1148: MSC_CL_PULL.v_refresh_id,
1149: MSC_CL_PULL.v_instance_id;
1150:
1151: END IF;
1152: end if;

Line 1149: MSC_CL_PULL.v_instance_id;

1145:
1146: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,
1147: MSC_CL_PULL.v_msc_alt_res_priority,
1148: MSC_CL_PULL.v_refresh_id,
1149: MSC_CL_PULL.v_instance_id;
1150:
1151: END IF;
1152: end if;
1153: COMMIT;

Line 1155: END IF; -- MSC_CL_PULL.BOM_ENABLED

1151: END IF;
1152: end if;
1153: COMMIT;
1154:
1155: END IF; -- MSC_CL_PULL.BOM_ENABLED
1156:
1157: END LOAD_OPERATION_RESOURCES;
1158: PROCEDURE LOAD_OPERATION_COMPONENTS IS
1159: v_get_apps_ver number;

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 1164: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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';
1167: MSC_CL_PULL.v_view_name := 'MRP_AD_OPERATION_COMPONENTS_V';
1168:

Line 1166: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_COMPONENTS';

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';
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;

Line 1167: MSC_CL_PULL.v_view_name := 'MRP_AD_OPERATION_COMPONENTS_V';

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';
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

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 1194: ||' FROM MRP_AD_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'

1190: ||' x.ORGANIZATION_ID,'
1191: ||' 1,'
1192: ||' :v_refresh_id,'
1193: ||' :v_instance_id'
1194: ||' FROM MRP_AD_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'
1195: ||' WHERE x.RN> :v_lrn '
1196: || v_temp_sql;
1197:
1198: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

Line 1198: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

1194: ||' FROM MRP_AD_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'
1195: ||' WHERE x.RN> :v_lrn '
1196: || v_temp_sql;
1197:
1198: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1199:
1200: COMMIT;
1201:
1202: END IF;

Line 1204: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_COMPONENTS';

1200: COMMIT;
1201:
1202: END IF;
1203:
1204: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_COMPONENTS';
1205: MSC_CL_PULL.v_view_name := 'MRP_AP_OPERATION_COMPONENTS_V';
1206: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1207: v_union_sql :=
1208: ' AND (x.RN1> :v_lrn )'

Line 1205: MSC_CL_PULL.v_view_name := 'MRP_AP_OPERATION_COMPONENTS_V';

1201:
1202: END IF;
1203:
1204: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_COMPONENTS';
1205: MSC_CL_PULL.v_view_name := 'MRP_AP_OPERATION_COMPONENTS_V';
1206: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1207: v_union_sql :=
1208: ' AND (x.RN1> :v_lrn )'
1209: ||' UNION '

Line 1206: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

1202: END IF;
1203:
1204: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_COMPONENTS';
1205: MSC_CL_PULL.v_view_name := 'MRP_AP_OPERATION_COMPONENTS_V';
1206: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1207: v_union_sql :=
1208: ' AND (x.RN1> :v_lrn )'
1209: ||' UNION '
1210: ||' SELECT'

Line 1219: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'

1215: ||' x.ROUTING_SEQUENCE_ID,'
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'

Line 1232: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'

1228: ||' x.ROUTING_SEQUENCE_ID,'
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'

Line 1245: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'

1241: ||' x.ROUTING_SEQUENCE_ID,'
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'

Line 1258: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'

1254: ||' x.ROUTING_SEQUENCE_ID,'
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'

Line 1271: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'

1267: ||' x.ROUTING_SEQUENCE_ID,'
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 := ' ';

Line 1299: ||' FROM MRP_AP_OPERATION_COMPONENTS_V'||MSC_CL_PULL.v_dblink||' x'

1295: ||' x.ROUTING_SEQUENCE_ID,'
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

Line 1303: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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:
1305: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1306: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1307: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

Line 1305: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

1301: || v_union_sql ;
1302:
1303: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1304:
1305: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1306: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1307: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1308: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1309: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

Line 1306: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

1302:
1303: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1304:
1305: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1306: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1307: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1308: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1309: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1310: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

Line 1307: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

1303: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1304:
1305: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1306: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1307: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1308: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1309: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1310: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1311:

Line 1308: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

1304:
1305: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1306: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1307: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1308: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1309: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1310: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1311:
1312: ELSE

Line 1309: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

1305: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1306: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1307: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1308: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1309: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1310: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1311:
1312: ELSE
1313:

Line 1310: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

1306: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1307: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1308: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1309: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1310: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1311:
1312: ELSE
1313:
1314: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1314: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1310: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1311:
1312: ELSE
1313:
1314: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1315:
1316: END IF;
1317:
1318: COMMIT;

Line 1320: END IF; -- MSC_CL_PULL.BOM_ENABLED

1316: END IF;
1317:
1318: COMMIT;
1319:
1320: END IF; -- MSC_CL_PULL.BOM_ENABLED
1321:
1322: END LOAD_OPERATION_COMPONENTS;
1323:
1324: