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 545: ||' FROM MRP_AP_OP_RESOURCE_SEQS_V'||MSC_CL_PULL.v_dblink||' x'

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

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

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

Line 553: MSC_CL_PULL.v_msc_simul_res_seq,

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

Line 554: MSC_CL_PULL.v_refresh_id,

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

Line 555: MSC_CL_PULL.v_instance_id;

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

Line 566: END IF; -- MSC_CL_PULL.BOM_ENABLED

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

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

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

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

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

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

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

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

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

Line 589: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;

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

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

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

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

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

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

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

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

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

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

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

Line 653: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 705: WHERE INSTANCE_ID = MSC_CL_PULL.v_instance_id;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1115: MSC_CL_PULL.v_msc_alt_res_priority,

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

Line 1116: MSC_CL_PULL.v_refresh_id,

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

Line 1117: MSC_CL_PULL.v_instance_id;

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

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

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

Line 1122: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,

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

Line 1123: MSC_CL_PULL.v_msc_alt_res_priority,

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

Line 1124: MSC_CL_PULL.v_refresh_id,

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

Line 1125: MSC_CL_PULL.v_instance_id,

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

Line 1126: MSC_CL_PULL.v_msc_simul_res_seq,

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

Line 1127: MSC_CL_PULL.v_msc_alt_res_priority,

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

Line 1128: MSC_CL_PULL.v_refresh_id,

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

Line 1129: MSC_CL_PULL.v_instance_id,

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

Line 1130: MSC_CL_PULL.v_msc_simul_res_seq,

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

Line 1131: MSC_CL_PULL.v_msc_alt_res_priority,

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

Line 1132: MSC_CL_PULL.v_refresh_id,

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

Line 1133: MSC_CL_PULL.v_instance_id;

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

Line 1135: MSC_CL_PULL.v_msc_simul_res_seq,

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

Line 1136: MSC_CL_PULL.v_msc_alt_res_priority,

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

Line 1137: MSC_CL_PULL.v_refresh_id,

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

Line 1138: MSC_CL_PULL.v_instance_id,

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

Line 1139: MSC_CL_PULL.v_msc_simul_res_seq,

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

Line 1140: MSC_CL_PULL.v_msc_alt_res_priority,

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

Line 1141: MSC_CL_PULL.v_refresh_id,

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

Line 1142: MSC_CL_PULL.v_instance_id;

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

Line 1148: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_msc_simul_res_seq,

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

Line 1149: MSC_CL_PULL.v_msc_alt_res_priority,

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

Line 1150: MSC_CL_PULL.v_refresh_id,

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

Line 1151: MSC_CL_PULL.v_instance_id;

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

Line 1157: END IF; -- MSC_CL_PULL.BOM_ENABLED

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1303: || v_union_sql ;
1304:
1305: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1306:
1307: EXECUTE IMMEDIATE v_sql_stmt USING 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: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

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

1304:
1305: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1306:
1307: EXECUTE IMMEDIATE v_sql_stmt USING 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: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1312: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

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

1305: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1306:
1307: EXECUTE IMMEDIATE v_sql_stmt USING 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: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1312: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1313:

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

1306:
1307: EXECUTE IMMEDIATE v_sql_stmt USING 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: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1312: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1313:
1314: ELSE

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

1307: EXECUTE IMMEDIATE v_sql_stmt USING 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: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1312: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1313:
1314: ELSE
1315:

Line 1312: 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: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1312: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1313:
1314: ELSE
1315:
1316: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

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

Line 1322: END IF; -- MSC_CL_PULL.BOM_ENABLED

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