APPS.MSC_CL_DEMAND_PULL dependencies on MSC_CL_PULL

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

23: PROCEDURE LOAD_FORECASTS IS
24:
25: BEGIN
26:
27: IF MSC_CL_PULL.FORECAST_ENABLED= MSC_UTIL.SYS_YES THEN
28:
29: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';
30: MSC_CL_PULL.v_view_name := 'MRP_AP_FORECAST_DSGN_V';
31:

Line 29: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';

25: BEGIN
26:
27: IF MSC_CL_PULL.FORECAST_ENABLED= MSC_UTIL.SYS_YES THEN
28:
29: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';
30: MSC_CL_PULL.v_view_name := 'MRP_AP_FORECAST_DSGN_V';
31:
32: v_sql_stmt :=
33: 'insert into MSC_ST_DESIGNATORS'

Line 30: MSC_CL_PULL.v_view_name := 'MRP_AP_FORECAST_DSGN_V';

26:
27: IF MSC_CL_PULL.FORECAST_ENABLED= MSC_UTIL.SYS_YES THEN
28:
29: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';
30: MSC_CL_PULL.v_view_name := 'MRP_AP_FORECAST_DSGN_V';
31:
32: v_sql_stmt :=
33: 'insert into MSC_ST_DESIGNATORS'
34: ||' ( DESIGNATOR,'

Line 77: ||' from MRP_AP_FORECAST_DSGN_V'||MSC_CL_PULL.v_dblink||' x'

73: ||' x.DESIGNATOR_TYPE,'
74: ||' 2,'
75: ||' :v_refresh_id,'
76: ||' :v_instance_id'
77: ||' from MRP_AP_FORECAST_DSGN_V'||MSC_CL_PULL.v_dblink||' x'
78: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
79: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
80:
81: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 79: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;

75: ||' :v_refresh_id,'
76: ||' :v_instance_id'
77: ||' from MRP_AP_FORECAST_DSGN_V'||MSC_CL_PULL.v_dblink||' x'
78: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
79: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
80:
81: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
82:
83: COMMIT;

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

77: ||' from MRP_AP_FORECAST_DSGN_V'||MSC_CL_PULL.v_dblink||' x'
78: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
79: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
80:
81: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
82:
83: COMMIT;
84:
85: -- IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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

81: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
82:
83: COMMIT;
84:
85: -- IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
86:
87: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';
88: MSC_CL_PULL.v_view_name := 'MRP_AD_FORECAST_DSGN_V';
89:

Line 87: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';

83: COMMIT;
84:
85: -- IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
86:
87: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';
88: MSC_CL_PULL.v_view_name := 'MRP_AD_FORECAST_DSGN_V';
89:
90: v_sql_stmt :=
91: 'insert into MSC_ST_DESIGNATORS'

Line 88: MSC_CL_PULL.v_view_name := 'MRP_AD_FORECAST_DSGN_V';

84:
85: -- IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
86:
87: MSC_CL_PULL.v_table_name:= 'MSC_ST_DESIGNATORS';
88: MSC_CL_PULL.v_view_name := 'MRP_AD_FORECAST_DSGN_V';
89:
90: v_sql_stmt :=
91: 'insert into MSC_ST_DESIGNATORS'
92: ||' ( DESIGNATOR,'

Line 105: ||' from MRP_AD_FORECAST_DSGN_V'||MSC_CL_PULL.v_dblink||' x'

101: ||' x.ORGANIZATION_ID,'
102: ||' 1,'
103: ||' :v_refresh_id,'
104: ||' :v_instance_id'
105: ||' from MRP_AD_FORECAST_DSGN_V'||MSC_CL_PULL.v_dblink||' x'
106: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
107: ||' AND x.RN> '||MSC_CL_PULL.v_lrn
108: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
109:

Line 107: ||' AND x.RN> '||MSC_CL_PULL.v_lrn

103: ||' :v_refresh_id,'
104: ||' :v_instance_id'
105: ||' from MRP_AD_FORECAST_DSGN_V'||MSC_CL_PULL.v_dblink||' x'
106: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
107: ||' AND x.RN> '||MSC_CL_PULL.v_lrn
108: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
109:
110:
111: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

107: ||' AND x.RN> '||MSC_CL_PULL.v_lrn
108: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
109:
110:
111: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
112:
113: COMMIT;
114: -- END IF ; -- Incremental Refresh
115:

Line 124: IF MSC_CL_PULL.FORECAST_ENABLED = MSC_UTIL.SYS_YES THEN

120:
121: PROCEDURE LOAD_ITEM_FORECASTS IS
122: BEGIN
123:
124: IF MSC_CL_PULL.FORECAST_ENABLED = MSC_UTIL.SYS_YES THEN
125:
126: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
127:
128: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

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

122: BEGIN
123:
124: IF MSC_CL_PULL.FORECAST_ENABLED = MSC_UTIL.SYS_YES THEN
125:
126: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
127:
128: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
129: MSC_CL_PULL.v_view_name := 'MRP_AD_FORECAST_DEMAND_V';
130:

Line 128: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

124: IF MSC_CL_PULL.FORECAST_ENABLED = MSC_UTIL.SYS_YES THEN
125:
126: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
127:
128: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
129: MSC_CL_PULL.v_view_name := 'MRP_AD_FORECAST_DEMAND_V';
130:
131: v_sql_stmt :=
132: 'insert into MSC_ST_DEMANDS'

Line 129: MSC_CL_PULL.v_view_name := 'MRP_AD_FORECAST_DEMAND_V';

125:
126: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
127:
128: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
129: MSC_CL_PULL.v_view_name := 'MRP_AD_FORECAST_DEMAND_V';
130:
131: v_sql_stmt :=
132: 'insert into MSC_ST_DEMANDS'
133: ||' ( INVENTORY_ITEM_ID,'

Line 150: ||' from MRP_AD_FORECAST_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'

146: ||' x.forecast_designator,'
147: ||' 1,'
148: ||' :v_refresh_id,'
149: ||' :v_instance_id'
150: ||' from MRP_AD_FORECAST_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
151: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
152: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
153:
154: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 152: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;

148: ||' :v_refresh_id,'
149: ||' :v_instance_id'
150: ||' from MRP_AD_FORECAST_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
151: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
152: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
153:
154: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
155:
156: COMMIT;

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

150: ||' from MRP_AD_FORECAST_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
151: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
152: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
153:
154: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
155:
156: COMMIT;
157: END IF; -- Incremental Refresh.
158:

Line 159: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

155:
156: COMMIT;
157: END IF; -- Incremental Refresh.
158:
159: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
160: MSC_CL_PULL.v_view_name := 'MRP_AP_FORECAST_DEMAND_V';
161:
162: v_sql_stmt:=
163: 'insert into MSC_ST_DEMANDS'

Line 160: MSC_CL_PULL.v_view_name := 'MRP_AP_FORECAST_DEMAND_V';

156: COMMIT;
157: END IF; -- Incremental Refresh.
158:
159: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
160: MSC_CL_PULL.v_view_name := 'MRP_AP_FORECAST_DEMAND_V';
161:
162: v_sql_stmt:=
163: 'insert into MSC_ST_DEMANDS'
164: ||' ( INVENTORY_ITEM_ID,'

Line 228: ||' from MRP_AP_FORECAST_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'

224: ||' :v_refresh_id,'
225: ||' x.PLANNING_GROUP,'
226: ||' :v_instance_id,'
227: ||' x.TRANSACTION_ID '
228: ||' from MRP_AP_FORECAST_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
229: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
230: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
231:
232:

Line 230: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;

226: ||' :v_instance_id,'
227: ||' x.TRANSACTION_ID '
228: ||' from MRP_AP_FORECAST_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
229: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
230: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
231:
232:
233: EXECUTE IMMEDIATE v_sql_stmt
234: USING MSC_CL_PULL.v_msc_fcst_priority_flex_num,

Line 234: USING MSC_CL_PULL.v_msc_fcst_priority_flex_num,

230: ||' AND x.RN1>'||MSC_CL_PULL.v_lrn;
231:
232:
233: EXECUTE IMMEDIATE v_sql_stmt
234: USING MSC_CL_PULL.v_msc_fcst_priority_flex_num,
235: MSC_CL_PULL.v_refresh_id,
236: MSC_CL_PULL.v_instance_id;
237:
238: COMMIT;

Line 235: MSC_CL_PULL.v_refresh_id,

231:
232:
233: EXECUTE IMMEDIATE v_sql_stmt
234: USING MSC_CL_PULL.v_msc_fcst_priority_flex_num,
235: MSC_CL_PULL.v_refresh_id,
236: MSC_CL_PULL.v_instance_id;
237:
238: COMMIT;
239:

Line 236: MSC_CL_PULL.v_instance_id;

232:
233: EXECUTE IMMEDIATE v_sql_stmt
234: USING MSC_CL_PULL.v_msc_fcst_priority_flex_num,
235: MSC_CL_PULL.v_refresh_id,
236: MSC_CL_PULL.v_instance_id;
237:
238: COMMIT;
239:
240: END IF;

Line 249: IF MSC_CL_PULL.MDS_ENABLED= MSC_UTIL.SYS_YES THEN

245:
246: PROCEDURE LOAD_MDS_DEMAND IS
247: BEGIN
248:
249: IF MSC_CL_PULL.MDS_ENABLED= MSC_UTIL.SYS_YES THEN
250:
251: --=================== Net Change Mode: Delete ==================
252:
253: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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

249: IF MSC_CL_PULL.MDS_ENABLED= MSC_UTIL.SYS_YES THEN
250:
251: --=================== Net Change Mode: Delete ==================
252:
253: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
254:
255: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
256: MSC_CL_PULL.v_view_name := 'MRP_AD_MDS_DEMANDS_V';
257:

Line 255: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

251: --=================== Net Change Mode: Delete ==================
252:
253: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
254:
255: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
256: MSC_CL_PULL.v_view_name := 'MRP_AD_MDS_DEMANDS_V';
257:
258: v_sql_stmt:=
259: 'insert into MSC_ST_DEMANDS'

Line 256: MSC_CL_PULL.v_view_name := 'MRP_AD_MDS_DEMANDS_V';

252:
253: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
254:
255: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
256: MSC_CL_PULL.v_view_name := 'MRP_AD_MDS_DEMANDS_V';
257:
258: v_sql_stmt:=
259: 'insert into MSC_ST_DEMANDS'
260: ||' ( DISPOSITION_ID,'

Line 277: ||' from MRP_AD_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

273: ||' x.ORIGINATION_TYPE,'
274: ||' 1,'
275: ||' :v_refresh_id,'
276: ||' :v_instance_id'
277: ||' from MRP_AD_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
278: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
279: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
280:
281: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

274: ||' 1,'
275: ||' :v_refresh_id,'
276: ||' :v_instance_id'
277: ||' from MRP_AD_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
278: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
279: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
280:
281: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
282:

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

277: ||' from MRP_AD_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
278: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
279: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
280:
281: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
282:
283: COMMIT;
284:
285: END IF;

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

283: COMMIT;
284:
285: END IF;
286:
287: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
288:
289: v_temp_sql := 'x.original_system_line_reference,x.original_system_reference,x.demand_source_type,x.demand_class,x.PROMISE_DATE,x.LINK_TO_LINE_ID,x.ORDER_DATE_TYPE_CODE,x.SCHEDULE_ARRIVAL_DATE,x.LATEST_ACCEPTABLE_DATE,x.SHIPPING_METHOD_CODE, ';
290:
291:

Line 312: IF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110) THEN

308: ||' 15, x.Attribute15,NULL),'
309: ||' 3,x.LATE_DEMAND_PENALTY_FACTOR) ), ';
310: ELSE
311:
312: IF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110) THEN
313: v_temp_sql :='x.original_system_line_reference ,x.original_system_reference,x.demand_source_type,NULL,x.PROMISE_DATE,NULL,';
314: ELSE
315: v_temp_sql :=' NULL, NULL,NULL,NULL,NULL,NULL,NULL, NULL,NULL,NULL, ';
316: END IF;

Line 339: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

335: ||' 14, x.Attribute14,'
336: ||' 15, x.Attribute15)),';
337: END IF;
338:
339: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
340: MSC_CL_PULL.v_view_name := 'MRP_AP_MDS_DEMANDS_V';
341: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
342: v_union_sql :=
343: ' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')' --NCP: changed to RN2

Line 340: MSC_CL_PULL.v_view_name := 'MRP_AP_MDS_DEMANDS_V';

336: ||' 15, x.Attribute15)),';
337: END IF;
338:
339: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
340: MSC_CL_PULL.v_view_name := 'MRP_AP_MDS_DEMANDS_V';
341: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
342: v_union_sql :=
343: ' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')' --NCP: changed to RN2
344: ||' UNION '

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

337: END IF;
338:
339: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
340: MSC_CL_PULL.v_view_name := 'MRP_AP_MDS_DEMANDS_V';
341: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
342: v_union_sql :=
343: ' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')' --NCP: changed to RN2
344: ||' UNION '
345: ||' select'

Line 343: ' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')' --NCP: changed to RN2

339: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
340: MSC_CL_PULL.v_view_name := 'MRP_AP_MDS_DEMANDS_V';
341: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
342: v_union_sql :=
343: ' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')' --NCP: changed to RN2
344: ||' UNION '
345: ||' select'
346: ||' x.INVENTORY_ITEM_ID,'
347: ||' x.ORGANIZATION_ID,'

Line 410: ||' from MRP_AP_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

406: ||' 2,'
407: || v_temp_sql
408: ||' :v_refresh_id,'
409: ||' :v_instance_id'
410: ||' from MRP_AP_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
411: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
412: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'; --NCP: changed to RN3
413:
414: ELSE

Line 412: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'; --NCP: changed to RN3

408: ||' :v_refresh_id,'
409: ||' :v_instance_id'
410: ||' from MRP_AP_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
411: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
412: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'; --NCP: changed to RN3
413:
414: ELSE
415: v_union_sql :=
416: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn

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

412: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'; --NCP: changed to RN3
413:
414: ELSE
415: v_union_sql :=
416: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
417: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
418: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
419: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
420:

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

413:
414: ELSE
415: v_union_sql :=
416: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
417: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
418: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
419: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
420:
421: END IF;

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

414: ELSE
415: v_union_sql :=
416: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
417: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
418: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
419: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
420:
421: END IF;
422:

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

415: v_union_sql :=
416: ' AND (x.RN1>'||MSC_CL_PULL.v_lrn
417: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
418: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
419: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
420:
421: END IF;
422:
423: v_sql_stmt:=

Line 530: ||' from MRP_AP_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

526: ||' 2,'
527: || v_temp_sql
528: ||' :v_refresh_id,'
529: ||' :v_instance_id'
530: ||' from MRP_AP_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
531: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
532: || v_union_sql ;
533:
534: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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

530: ||' from MRP_AP_MDS_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
531: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
532: || v_union_sql ;
533:
534: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
535: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
536: EXECUTE IMMEDIATE v_sql_stmt
537: USING MSC_CL_PULL.v_dgmt,
538: MSC_CL_PULL.v_dgmt,

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

531: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
532: || v_union_sql ;
533:
534: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
535: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
536: EXECUTE IMMEDIATE v_sql_stmt
537: USING MSC_CL_PULL.v_dgmt,
538: MSC_CL_PULL.v_dgmt,
539: MSC_CL_PULL.v_dgmt,

Line 537: USING MSC_CL_PULL.v_dgmt,

533:
534: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
535: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
536: EXECUTE IMMEDIATE v_sql_stmt
537: USING MSC_CL_PULL.v_dgmt,
538: MSC_CL_PULL.v_dgmt,
539: MSC_CL_PULL.v_dgmt,
540: MSC_CL_PULL.v_mso_fcst_penalty,
541: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

Line 538: MSC_CL_PULL.v_dgmt,

534: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
535: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
536: EXECUTE IMMEDIATE v_sql_stmt
537: USING MSC_CL_PULL.v_dgmt,
538: MSC_CL_PULL.v_dgmt,
539: MSC_CL_PULL.v_dgmt,
540: MSC_CL_PULL.v_mso_fcst_penalty,
541: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
542: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

Line 539: MSC_CL_PULL.v_dgmt,

535: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
536: EXECUTE IMMEDIATE v_sql_stmt
537: USING MSC_CL_PULL.v_dgmt,
538: MSC_CL_PULL.v_dgmt,
539: MSC_CL_PULL.v_dgmt,
540: MSC_CL_PULL.v_mso_fcst_penalty,
541: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
542: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
543: MSC_CL_PULL.v_refresh_id,

Line 540: MSC_CL_PULL.v_mso_fcst_penalty,

536: EXECUTE IMMEDIATE v_sql_stmt
537: USING MSC_CL_PULL.v_dgmt,
538: MSC_CL_PULL.v_dgmt,
539: MSC_CL_PULL.v_dgmt,
540: MSC_CL_PULL.v_mso_fcst_penalty,
541: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
542: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
543: MSC_CL_PULL.v_refresh_id,
544: MSC_CL_PULL.v_instance_id,

Line 541: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

537: USING MSC_CL_PULL.v_dgmt,
538: MSC_CL_PULL.v_dgmt,
539: MSC_CL_PULL.v_dgmt,
540: MSC_CL_PULL.v_mso_fcst_penalty,
541: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
542: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
543: MSC_CL_PULL.v_refresh_id,
544: MSC_CL_PULL.v_instance_id,
545: MSC_CL_PULL.v_dgmt,

Line 542: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

538: MSC_CL_PULL.v_dgmt,
539: MSC_CL_PULL.v_dgmt,
540: MSC_CL_PULL.v_mso_fcst_penalty,
541: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
542: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
543: MSC_CL_PULL.v_refresh_id,
544: MSC_CL_PULL.v_instance_id,
545: MSC_CL_PULL.v_dgmt,
546: MSC_CL_PULL.v_dgmt,

Line 543: MSC_CL_PULL.v_refresh_id,

539: MSC_CL_PULL.v_dgmt,
540: MSC_CL_PULL.v_mso_fcst_penalty,
541: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
542: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
543: MSC_CL_PULL.v_refresh_id,
544: MSC_CL_PULL.v_instance_id,
545: MSC_CL_PULL.v_dgmt,
546: MSC_CL_PULL.v_dgmt,
547: MSC_CL_PULL.v_dgmt,

Line 544: MSC_CL_PULL.v_instance_id,

540: MSC_CL_PULL.v_mso_fcst_penalty,
541: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
542: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
543: MSC_CL_PULL.v_refresh_id,
544: MSC_CL_PULL.v_instance_id,
545: MSC_CL_PULL.v_dgmt,
546: MSC_CL_PULL.v_dgmt,
547: MSC_CL_PULL.v_dgmt,
548: MSC_CL_PULL.v_mso_fcst_penalty,

Line 545: MSC_CL_PULL.v_dgmt,

541: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
542: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
543: MSC_CL_PULL.v_refresh_id,
544: MSC_CL_PULL.v_instance_id,
545: MSC_CL_PULL.v_dgmt,
546: MSC_CL_PULL.v_dgmt,
547: MSC_CL_PULL.v_dgmt,
548: MSC_CL_PULL.v_mso_fcst_penalty,
549: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

Line 546: MSC_CL_PULL.v_dgmt,

542: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
543: MSC_CL_PULL.v_refresh_id,
544: MSC_CL_PULL.v_instance_id,
545: MSC_CL_PULL.v_dgmt,
546: MSC_CL_PULL.v_dgmt,
547: MSC_CL_PULL.v_dgmt,
548: MSC_CL_PULL.v_mso_fcst_penalty,
549: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
550: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

Line 547: MSC_CL_PULL.v_dgmt,

543: MSC_CL_PULL.v_refresh_id,
544: MSC_CL_PULL.v_instance_id,
545: MSC_CL_PULL.v_dgmt,
546: MSC_CL_PULL.v_dgmt,
547: MSC_CL_PULL.v_dgmt,
548: MSC_CL_PULL.v_mso_fcst_penalty,
549: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
550: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
551: MSC_CL_PULL.v_refresh_id,

Line 548: MSC_CL_PULL.v_mso_fcst_penalty,

544: MSC_CL_PULL.v_instance_id,
545: MSC_CL_PULL.v_dgmt,
546: MSC_CL_PULL.v_dgmt,
547: MSC_CL_PULL.v_dgmt,
548: MSC_CL_PULL.v_mso_fcst_penalty,
549: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
550: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
551: MSC_CL_PULL.v_refresh_id,
552: MSC_CL_PULL.v_instance_id;

Line 549: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

545: MSC_CL_PULL.v_dgmt,
546: MSC_CL_PULL.v_dgmt,
547: MSC_CL_PULL.v_dgmt,
548: MSC_CL_PULL.v_mso_fcst_penalty,
549: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
550: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
551: MSC_CL_PULL.v_refresh_id,
552: MSC_CL_PULL.v_instance_id;
553: ELSE

Line 550: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

546: MSC_CL_PULL.v_dgmt,
547: MSC_CL_PULL.v_dgmt,
548: MSC_CL_PULL.v_mso_fcst_penalty,
549: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
550: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
551: MSC_CL_PULL.v_refresh_id,
552: MSC_CL_PULL.v_instance_id;
553: ELSE
554: EXECUTE IMMEDIATE v_sql_stmt

Line 551: MSC_CL_PULL.v_refresh_id,

547: MSC_CL_PULL.v_dgmt,
548: MSC_CL_PULL.v_mso_fcst_penalty,
549: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
550: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
551: MSC_CL_PULL.v_refresh_id,
552: MSC_CL_PULL.v_instance_id;
553: ELSE
554: EXECUTE IMMEDIATE v_sql_stmt
555: USING MSC_CL_PULL.v_dgmt,

Line 552: MSC_CL_PULL.v_instance_id;

548: MSC_CL_PULL.v_mso_fcst_penalty,
549: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
550: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
551: MSC_CL_PULL.v_refresh_id,
552: MSC_CL_PULL.v_instance_id;
553: ELSE
554: EXECUTE IMMEDIATE v_sql_stmt
555: USING MSC_CL_PULL.v_dgmt,
556: MSC_CL_PULL.v_dgmt,

Line 555: USING MSC_CL_PULL.v_dgmt,

551: MSC_CL_PULL.v_refresh_id,
552: MSC_CL_PULL.v_instance_id;
553: ELSE
554: EXECUTE IMMEDIATE v_sql_stmt
555: USING MSC_CL_PULL.v_dgmt,
556: MSC_CL_PULL.v_dgmt,
557: MSC_CL_PULL.v_dgmt,
558: MSC_CL_PULL.v_mso_fcst_penalty,
559: MSC_CL_PULL.v_mso_so_penalty,

Line 556: MSC_CL_PULL.v_dgmt,

552: MSC_CL_PULL.v_instance_id;
553: ELSE
554: EXECUTE IMMEDIATE v_sql_stmt
555: USING MSC_CL_PULL.v_dgmt,
556: MSC_CL_PULL.v_dgmt,
557: MSC_CL_PULL.v_dgmt,
558: MSC_CL_PULL.v_mso_fcst_penalty,
559: MSC_CL_PULL.v_mso_so_penalty,
560: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

Line 557: MSC_CL_PULL.v_dgmt,

553: ELSE
554: EXECUTE IMMEDIATE v_sql_stmt
555: USING MSC_CL_PULL.v_dgmt,
556: MSC_CL_PULL.v_dgmt,
557: MSC_CL_PULL.v_dgmt,
558: MSC_CL_PULL.v_mso_fcst_penalty,
559: MSC_CL_PULL.v_mso_so_penalty,
560: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
561: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

Line 558: MSC_CL_PULL.v_mso_fcst_penalty,

554: EXECUTE IMMEDIATE v_sql_stmt
555: USING MSC_CL_PULL.v_dgmt,
556: MSC_CL_PULL.v_dgmt,
557: MSC_CL_PULL.v_dgmt,
558: MSC_CL_PULL.v_mso_fcst_penalty,
559: MSC_CL_PULL.v_mso_so_penalty,
560: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
561: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
562: MSC_CL_PULL.v_refresh_id,

Line 559: MSC_CL_PULL.v_mso_so_penalty,

555: USING MSC_CL_PULL.v_dgmt,
556: MSC_CL_PULL.v_dgmt,
557: MSC_CL_PULL.v_dgmt,
558: MSC_CL_PULL.v_mso_fcst_penalty,
559: MSC_CL_PULL.v_mso_so_penalty,
560: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
561: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
562: MSC_CL_PULL.v_refresh_id,
563: MSC_CL_PULL.v_instance_id,

Line 560: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

556: MSC_CL_PULL.v_dgmt,
557: MSC_CL_PULL.v_dgmt,
558: MSC_CL_PULL.v_mso_fcst_penalty,
559: MSC_CL_PULL.v_mso_so_penalty,
560: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
561: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
562: MSC_CL_PULL.v_refresh_id,
563: MSC_CL_PULL.v_instance_id,
564: MSC_CL_PULL.v_dgmt,

Line 561: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

557: MSC_CL_PULL.v_dgmt,
558: MSC_CL_PULL.v_mso_fcst_penalty,
559: MSC_CL_PULL.v_mso_so_penalty,
560: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
561: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
562: MSC_CL_PULL.v_refresh_id,
563: MSC_CL_PULL.v_instance_id,
564: MSC_CL_PULL.v_dgmt,
565: MSC_CL_PULL.v_dgmt,

Line 562: MSC_CL_PULL.v_refresh_id,

558: MSC_CL_PULL.v_mso_fcst_penalty,
559: MSC_CL_PULL.v_mso_so_penalty,
560: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
561: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
562: MSC_CL_PULL.v_refresh_id,
563: MSC_CL_PULL.v_instance_id,
564: MSC_CL_PULL.v_dgmt,
565: MSC_CL_PULL.v_dgmt,
566: MSC_CL_PULL.v_dgmt,

Line 563: MSC_CL_PULL.v_instance_id,

559: MSC_CL_PULL.v_mso_so_penalty,
560: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
561: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
562: MSC_CL_PULL.v_refresh_id,
563: MSC_CL_PULL.v_instance_id,
564: MSC_CL_PULL.v_dgmt,
565: MSC_CL_PULL.v_dgmt,
566: MSC_CL_PULL.v_dgmt,
567: MSC_CL_PULL.v_mso_fcst_penalty,

Line 564: MSC_CL_PULL.v_dgmt,

560: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
561: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
562: MSC_CL_PULL.v_refresh_id,
563: MSC_CL_PULL.v_instance_id,
564: MSC_CL_PULL.v_dgmt,
565: MSC_CL_PULL.v_dgmt,
566: MSC_CL_PULL.v_dgmt,
567: MSC_CL_PULL.v_mso_fcst_penalty,
568: MSC_CL_PULL.v_mso_so_penalty,

Line 565: MSC_CL_PULL.v_dgmt,

561: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
562: MSC_CL_PULL.v_refresh_id,
563: MSC_CL_PULL.v_instance_id,
564: MSC_CL_PULL.v_dgmt,
565: MSC_CL_PULL.v_dgmt,
566: MSC_CL_PULL.v_dgmt,
567: MSC_CL_PULL.v_mso_fcst_penalty,
568: MSC_CL_PULL.v_mso_so_penalty,
569: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

Line 566: MSC_CL_PULL.v_dgmt,

562: MSC_CL_PULL.v_refresh_id,
563: MSC_CL_PULL.v_instance_id,
564: MSC_CL_PULL.v_dgmt,
565: MSC_CL_PULL.v_dgmt,
566: MSC_CL_PULL.v_dgmt,
567: MSC_CL_PULL.v_mso_fcst_penalty,
568: MSC_CL_PULL.v_mso_so_penalty,
569: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
570: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

Line 567: MSC_CL_PULL.v_mso_fcst_penalty,

563: MSC_CL_PULL.v_instance_id,
564: MSC_CL_PULL.v_dgmt,
565: MSC_CL_PULL.v_dgmt,
566: MSC_CL_PULL.v_dgmt,
567: MSC_CL_PULL.v_mso_fcst_penalty,
568: MSC_CL_PULL.v_mso_so_penalty,
569: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
570: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
571: MSC_CL_PULL.v_refresh_id,

Line 568: MSC_CL_PULL.v_mso_so_penalty,

564: MSC_CL_PULL.v_dgmt,
565: MSC_CL_PULL.v_dgmt,
566: MSC_CL_PULL.v_dgmt,
567: MSC_CL_PULL.v_mso_fcst_penalty,
568: MSC_CL_PULL.v_mso_so_penalty,
569: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
570: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
571: MSC_CL_PULL.v_refresh_id,
572: MSC_CL_PULL.v_instance_id;

Line 569: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

565: MSC_CL_PULL.v_dgmt,
566: MSC_CL_PULL.v_dgmt,
567: MSC_CL_PULL.v_mso_fcst_penalty,
568: MSC_CL_PULL.v_mso_so_penalty,
569: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
570: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
571: MSC_CL_PULL.v_refresh_id,
572: MSC_CL_PULL.v_instance_id;
573: END IF;

Line 570: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

566: MSC_CL_PULL.v_dgmt,
567: MSC_CL_PULL.v_mso_fcst_penalty,
568: MSC_CL_PULL.v_mso_so_penalty,
569: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
570: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
571: MSC_CL_PULL.v_refresh_id,
572: MSC_CL_PULL.v_instance_id;
573: END IF;
574:

Line 571: MSC_CL_PULL.v_refresh_id,

567: MSC_CL_PULL.v_mso_fcst_penalty,
568: MSC_CL_PULL.v_mso_so_penalty,
569: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
570: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
571: MSC_CL_PULL.v_refresh_id,
572: MSC_CL_PULL.v_instance_id;
573: END IF;
574:
575: ELSE -- Targeted - Complete Refresh collections

Line 572: MSC_CL_PULL.v_instance_id;

568: MSC_CL_PULL.v_mso_so_penalty,
569: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
570: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
571: MSC_CL_PULL.v_refresh_id,
572: MSC_CL_PULL.v_instance_id;
573: END IF;
574:
575: ELSE -- Targeted - Complete Refresh collections
576: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN

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

572: MSC_CL_PULL.v_instance_id;
573: END IF;
574:
575: ELSE -- Targeted - Complete Refresh collections
576: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
577: EXECUTE IMMEDIATE v_sql_stmt
578: USING MSC_CL_PULL.v_dgmt,
579: MSC_CL_PULL.v_dgmt,
580: MSC_CL_PULL.v_dgmt,

Line 578: USING MSC_CL_PULL.v_dgmt,

574:
575: ELSE -- Targeted - Complete Refresh collections
576: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
577: EXECUTE IMMEDIATE v_sql_stmt
578: USING MSC_CL_PULL.v_dgmt,
579: MSC_CL_PULL.v_dgmt,
580: MSC_CL_PULL.v_dgmt,
581: MSC_CL_PULL.v_mso_fcst_penalty,
582: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

Line 579: MSC_CL_PULL.v_dgmt,

575: ELSE -- Targeted - Complete Refresh collections
576: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
577: EXECUTE IMMEDIATE v_sql_stmt
578: USING MSC_CL_PULL.v_dgmt,
579: MSC_CL_PULL.v_dgmt,
580: MSC_CL_PULL.v_dgmt,
581: MSC_CL_PULL.v_mso_fcst_penalty,
582: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
583: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

Line 580: MSC_CL_PULL.v_dgmt,

576: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) THEN
577: EXECUTE IMMEDIATE v_sql_stmt
578: USING MSC_CL_PULL.v_dgmt,
579: MSC_CL_PULL.v_dgmt,
580: MSC_CL_PULL.v_dgmt,
581: MSC_CL_PULL.v_mso_fcst_penalty,
582: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
583: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
584: MSC_CL_PULL.v_refresh_id,

Line 581: MSC_CL_PULL.v_mso_fcst_penalty,

577: EXECUTE IMMEDIATE v_sql_stmt
578: USING MSC_CL_PULL.v_dgmt,
579: MSC_CL_PULL.v_dgmt,
580: MSC_CL_PULL.v_dgmt,
581: MSC_CL_PULL.v_mso_fcst_penalty,
582: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
583: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
584: MSC_CL_PULL.v_refresh_id,
585: MSC_CL_PULL.v_instance_id;

Line 582: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

578: USING MSC_CL_PULL.v_dgmt,
579: MSC_CL_PULL.v_dgmt,
580: MSC_CL_PULL.v_dgmt,
581: MSC_CL_PULL.v_mso_fcst_penalty,
582: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
583: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
584: MSC_CL_PULL.v_refresh_id,
585: MSC_CL_PULL.v_instance_id;
586: ELSE

Line 583: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

579: MSC_CL_PULL.v_dgmt,
580: MSC_CL_PULL.v_dgmt,
581: MSC_CL_PULL.v_mso_fcst_penalty,
582: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
583: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
584: MSC_CL_PULL.v_refresh_id,
585: MSC_CL_PULL.v_instance_id;
586: ELSE
587: EXECUTE IMMEDIATE v_sql_stmt

Line 584: MSC_CL_PULL.v_refresh_id,

580: MSC_CL_PULL.v_dgmt,
581: MSC_CL_PULL.v_mso_fcst_penalty,
582: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
583: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
584: MSC_CL_PULL.v_refresh_id,
585: MSC_CL_PULL.v_instance_id;
586: ELSE
587: EXECUTE IMMEDIATE v_sql_stmt
588: USING MSC_CL_PULL.v_dgmt,

Line 585: MSC_CL_PULL.v_instance_id;

581: MSC_CL_PULL.v_mso_fcst_penalty,
582: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
583: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
584: MSC_CL_PULL.v_refresh_id,
585: MSC_CL_PULL.v_instance_id;
586: ELSE
587: EXECUTE IMMEDIATE v_sql_stmt
588: USING MSC_CL_PULL.v_dgmt,
589: MSC_CL_PULL.v_dgmt,

Line 588: USING MSC_CL_PULL.v_dgmt,

584: MSC_CL_PULL.v_refresh_id,
585: MSC_CL_PULL.v_instance_id;
586: ELSE
587: EXECUTE IMMEDIATE v_sql_stmt
588: USING MSC_CL_PULL.v_dgmt,
589: MSC_CL_PULL.v_dgmt,
590: MSC_CL_PULL.v_dgmt,
591: MSC_CL_PULL.v_mso_fcst_penalty,
592: MSC_CL_PULL.v_mso_so_penalty,

Line 589: MSC_CL_PULL.v_dgmt,

585: MSC_CL_PULL.v_instance_id;
586: ELSE
587: EXECUTE IMMEDIATE v_sql_stmt
588: USING MSC_CL_PULL.v_dgmt,
589: MSC_CL_PULL.v_dgmt,
590: MSC_CL_PULL.v_dgmt,
591: MSC_CL_PULL.v_mso_fcst_penalty,
592: MSC_CL_PULL.v_mso_so_penalty,
593: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

Line 590: MSC_CL_PULL.v_dgmt,

586: ELSE
587: EXECUTE IMMEDIATE v_sql_stmt
588: USING MSC_CL_PULL.v_dgmt,
589: MSC_CL_PULL.v_dgmt,
590: MSC_CL_PULL.v_dgmt,
591: MSC_CL_PULL.v_mso_fcst_penalty,
592: MSC_CL_PULL.v_mso_so_penalty,
593: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
594: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

Line 591: MSC_CL_PULL.v_mso_fcst_penalty,

587: EXECUTE IMMEDIATE v_sql_stmt
588: USING MSC_CL_PULL.v_dgmt,
589: MSC_CL_PULL.v_dgmt,
590: MSC_CL_PULL.v_dgmt,
591: MSC_CL_PULL.v_mso_fcst_penalty,
592: MSC_CL_PULL.v_mso_so_penalty,
593: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
594: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
595: MSC_CL_PULL.v_refresh_id,

Line 592: MSC_CL_PULL.v_mso_so_penalty,

588: USING MSC_CL_PULL.v_dgmt,
589: MSC_CL_PULL.v_dgmt,
590: MSC_CL_PULL.v_dgmt,
591: MSC_CL_PULL.v_mso_fcst_penalty,
592: MSC_CL_PULL.v_mso_so_penalty,
593: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
594: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
595: MSC_CL_PULL.v_refresh_id,
596: MSC_CL_PULL.v_instance_id;

Line 593: MSC_CL_PULL.v_msc_dmd_priority_flex_num,

589: MSC_CL_PULL.v_dgmt,
590: MSC_CL_PULL.v_dgmt,
591: MSC_CL_PULL.v_mso_fcst_penalty,
592: MSC_CL_PULL.v_mso_so_penalty,
593: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
594: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
595: MSC_CL_PULL.v_refresh_id,
596: MSC_CL_PULL.v_instance_id;
597: END IF;

Line 594: MSC_CL_PULL.v_msc_fcst_priority_flex_num,

590: MSC_CL_PULL.v_dgmt,
591: MSC_CL_PULL.v_mso_fcst_penalty,
592: MSC_CL_PULL.v_mso_so_penalty,
593: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
594: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
595: MSC_CL_PULL.v_refresh_id,
596: MSC_CL_PULL.v_instance_id;
597: END IF;
598:

Line 595: MSC_CL_PULL.v_refresh_id,

591: MSC_CL_PULL.v_mso_fcst_penalty,
592: MSC_CL_PULL.v_mso_so_penalty,
593: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
594: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
595: MSC_CL_PULL.v_refresh_id,
596: MSC_CL_PULL.v_instance_id;
597: END IF;
598:
599: END IF;

Line 596: MSC_CL_PULL.v_instance_id;

592: MSC_CL_PULL.v_mso_so_penalty,
593: MSC_CL_PULL.v_msc_dmd_priority_flex_num,
594: MSC_CL_PULL.v_msc_fcst_priority_flex_num,
595: MSC_CL_PULL.v_refresh_id,
596: MSC_CL_PULL.v_instance_id;
597: END IF;
598:
599: END IF;
600:

Line 603: END IF; -- MSC_CL_PULL.MDS_ENABLED

599: END IF;
600:
601: COMMIT;
602:
603: END IF; -- MSC_CL_PULL.MDS_ENABLED
604:
605: END LOAD_MDS_DEMAND;
606:
607:

Line 616: if(MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) then

612:
613: v_union_sql := ' ';
614: v_temp_sql4 := NULL;
615:
616: if(MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) then
617: v_temp_sql1:='x.SCHEDULE_ARRIVAL_DATE,x.LATEST_ACCEPTABLE_DATE,x.SHIPPING_METHOD_CODE,x.ATO_LINE_ID,x.ORDER_DATE_TYPE_CODE,x.DELIVERY_LEAD_TIME ';
618: else
619: v_temp_sql1:='NULL,NULL,NULL,NULL,NULL,NULL ';
620: end if;

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

621:
622:
623: IF ( p_worker_num = 3) THEN
624:
625: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
626:
627: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
628: MSC_CL_PULL.v_view_name := 'MRP_AD_SALES_ORDERS_V';
629:

Line 627: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';

623: IF ( p_worker_num = 3) THEN
624:
625: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
626:
627: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
628: MSC_CL_PULL.v_view_name := 'MRP_AD_SALES_ORDERS_V';
629:
630: Begin
631:

Line 628: MSC_CL_PULL.v_view_name := 'MRP_AD_SALES_ORDERS_V';

624:
625: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
626:
627: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
628: MSC_CL_PULL.v_view_name := 'MRP_AD_SALES_ORDERS_V';
629:
630: Begin
631:
632: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN

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

628: MSC_CL_PULL.v_view_name := 'MRP_AD_SALES_ORDERS_V';
629:
630: Begin
631:
632: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN
633: v_temp_sql:= ' 2 ,';
634: ELSE
635: v_temp_sql:= ' x.CTO_FLAG,';
636: END IF ;

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

638:
639: End;
640: /*Added By raraghav */
641:
642: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
643: lv_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
644: ELSE
645: lv_temp_sql := NULL;
646: END IF;

Line 667: ||' from MRP_AD_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'

663: ||' 2,'
664: ||' 2,'
665: ||' :v_refresh_id,'
666: ||' :v_instance_id'
667: ||' from MRP_AD_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
668: ||' where x.RN> :v_lrn '
669: || lv_temp_sql;
670:
671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);

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

668: ||' where x.RN> :v_lrn '
669: || lv_temp_sql;
670:
671: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
672: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
673:
674: COMMIT;
675:
676: v_sql_stmt:=

Line 695: ||' from MRP_AD_SALES_ORDERS_V'||MSC_CL_PULL.v_dblink||' x'

691: ||' 1,'
692: || v_temp_sql
693: ||' :v_refresh_id,'
694: ||' :v_instance_id'
695: ||' from MRP_AD_SALES_ORDERS_V'||MSC_CL_PULL.v_dblink||' x'
696: ||' WHERE x.RN> :v_lrn '
697: || lv_temp_sql;
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
699: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

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

695: ||' from MRP_AD_SALES_ORDERS_V'||MSC_CL_PULL.v_dblink||' x'
696: ||' WHERE x.RN> :v_lrn '
697: || lv_temp_sql;
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
699: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
700:
701: COMMIT;
702:
703: END IF; --- MSC_CL_PULL.v_lrnn<> -1

Line 703: END IF; --- MSC_CL_PULL.v_lrnn<> -1

699: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
700:
701: COMMIT;
702:
703: END IF; --- MSC_CL_PULL.v_lrnn<> -1
704:
705: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
706:
707: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN -- 107 or 110 source instance

Line 705: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';

701: COMMIT;
702:
703: END IF; --- MSC_CL_PULL.v_lrnn<> -1
704:
705: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
706:
707: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN -- 107 or 110 source instance
708: MSC_CL_PULL.v_view_name := 'MRP_AP_SALES_ORDERS_V';
709: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn OR x.RN3> :v_lrn )';

Line 707: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN -- 107 or 110 source instance

703: END IF; --- MSC_CL_PULL.v_lrnn<> -1
704:
705: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
706:
707: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN -- 107 or 110 source instance
708: MSC_CL_PULL.v_view_name := 'MRP_AP_SALES_ORDERS_V';
709: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn OR x.RN3> :v_lrn )';
710:
711: /* Changed for the fix 2521038, */

Line 708: MSC_CL_PULL.v_view_name := 'MRP_AP_SALES_ORDERS_V';

704:
705: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
706:
707: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN -- 107 or 110 source instance
708: MSC_CL_PULL.v_view_name := 'MRP_AP_SALES_ORDERS_V';
709: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn OR x.RN3> :v_lrn )';
710:
711: /* Changed for the fix 2521038, */
712: v_temp_sql2 := ' AND (x.PRIMARY_UOM_QUANTITY > x.COMPLETED_QUANTITY '

Line 726: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections

722: v_temp_sql := ' x.END_ITEM_UNIT_NUMBER , x.ordered_item_id,x.ORIGINAL_INVENTORY_ITEM_ID, '
723: || ' x.LINK_TO_LINE_ID, x.cust_po_number,x.customer_line_number, x.MFG_LEAD_TIME, x.FIRM_DEMAND_FLAG, x.SHIP_SET_ID, x.ARRIVAL_SET_ID, x.SHIP_SET_NAME, x.ARRIVAL_SET_NAME, ';
724:
725:
726: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
727: v_temp_sql2 := ' AND (x.ORIGINAL_ORDERED_QUANTITY >= x.ORIGINAL_COMPLETED_QUANTITY) ';
728: MSC_CL_PULL.v_view_name := 'MRP_AN3_SALES_ORDERS_V';
729: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn )';
730:

Line 728: MSC_CL_PULL.v_view_name := 'MRP_AN3_SALES_ORDERS_V';

724:
725:
726: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
727: v_temp_sql2 := ' AND (x.ORIGINAL_ORDERED_QUANTITY >= x.ORIGINAL_COMPLETED_QUANTITY) ';
728: MSC_CL_PULL.v_view_name := 'MRP_AN3_SALES_ORDERS_V';
729: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn )';
730:
731: ELSE --- complete/targeted collections
732: v_temp_sql2 := ' AND (x.ORIGINAL_ORDERED_QUANTITY > x.ORIGINAL_COMPLETED_QUANTITY '

Line 735: MSC_CL_PULL.v_view_name := 'MRP_AP3_SALES_ORDERS_V';

731: ELSE --- complete/targeted collections
732: v_temp_sql2 := ' AND (x.ORIGINAL_ORDERED_QUANTITY > x.ORIGINAL_COMPLETED_QUANTITY '
733: ||' OR (x.ORIGINAL_ORDERED_QUANTITY = x.ORIGINAL_COMPLETED_QUANTITY '
734: ||' AND x.requirement_date >= trunc(sysdate - (' || v_msc_so_offset_days ||' )))) ';
735: MSC_CL_PULL.v_view_name := 'MRP_AP3_SALES_ORDERS_V';
736: v_temp_sql3 := ' ';
737: END IF;
738: END IF;
739:

Line 743: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';

739:
740:
741: ELSIF ( p_worker_num in (1,2) ) THEN
742:
743: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
744:
745: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
746: MSC_CL_PULL.v_view_name := 'MRP_AN'||p_worker_num||'_SALES_ORDERS_V';
747:

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

741: ELSIF ( p_worker_num in (1,2) ) THEN
742:
743: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
744:
745: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
746: MSC_CL_PULL.v_view_name := 'MRP_AN'||p_worker_num||'_SALES_ORDERS_V';
747:
748: if p_worker_num <> 2 then
749: if p_worker_num = 1 then

Line 746: MSC_CL_PULL.v_view_name := 'MRP_AN'||p_worker_num||'_SALES_ORDERS_V';

742:
743: MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
744:
745: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
746: MSC_CL_PULL.v_view_name := 'MRP_AN'||p_worker_num||'_SALES_ORDERS_V';
747:
748: if p_worker_num <> 2 then
749: if p_worker_num = 1 then
750: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn OR x.RN3> :v_lrn )';

Line 789: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 then

785: ||' x.FORECAST_VISIBLE,'
786: ||' x.DEMAND_VISIBLE,'
787: ||' x.SALESREP_CONTACT,';
788:
789: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 then
790: v_union_sql := v_union_sql ||' x.SALESREP_ID,';
791: else
792: v_union_sql := v_union_sql ||' NULL,';
793: end if;

Line 827: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'

823: ||' x.PROMISE_DATE,'
824: ||' :v_refresh_id,'
825: ||' :v_instance_id, '
826: || v_temp_sql1
827: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
828: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
829: || v_temp_sql2
830: ||' and ( x.rn2 > :v_lrn ) ' ;
831:

Line 837: MSC_CL_PULL.v_view_name := 'MRP_AP'||p_worker_num||'_SALES_ORDERS_V';

833:
834: end if;
835:
836: ELSE
837: MSC_CL_PULL.v_view_name := 'MRP_AP'||p_worker_num||'_SALES_ORDERS_V';
838: v_temp_sql3 := ' ';
839:
840: END IF;
841:

Line 846: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)

842: v_temp_sql := ' x.END_ITEM_UNIT_NUMBER , x.ordered_item_id,x.ORIGINAL_INVENTORY_ITEM_ID , '
843: ||' x.LINK_TO_LINE_ID, x.cust_po_number,x.customer_line_number,x.MFG_LEAD_TIME,x.FIRM_DEMAND_FLAG,x.SHIP_SET_ID,x.ARRIVAL_SET_ID,x.SHIP_SET_NAME,x.ARRIVAL_SET_NAME, ';
844:
845: IF (p_worker_num = 2 AND -- Bug 4245915
846: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)
847: v_temp_sql4 := ' AND ( x.visible_demand_flag = ''Y'' OR (x.visible_demand_flag = ''N'' AND x.order_type='''||v_msc_x_vmi_om_order_type||''')) ';
848: END IF;
849:
850: END IF; --- (p_worker_num = 4 ) condition

Line 853: IF (MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 OR

849:
850: END IF; --- (p_worker_num = 4 ) condition
851:
852:
853: IF (MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 OR
854: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN
855:
856: /* Changed for the fix 2521038, note the views MRP_AP_SALES_ORDERS_V and MRP_AN_SALES_ORDERS_V
857: have also been changed for this. Only if the source is 115 the new columns ORIGINAL_ORDERED_QUANTITY,

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

850: END IF; --- (p_worker_num = 4 ) condition
851:
852:
853: IF (MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 OR
854: MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115) THEN
855:
856: /* Changed for the fix 2521038, note the views MRP_AP_SALES_ORDERS_V and MRP_AN_SALES_ORDERS_V
857: have also been changed for this. Only if the source is 115 the new columns ORIGINAL_ORDERED_QUANTITY,
858: ORIGINAL_COMPLETED_QUANTITY are applicable.

Line 861: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110 THEN

857: have also been changed for this. Only if the source is 115 the new columns ORIGINAL_ORDERED_QUANTITY,
858: ORIGINAL_COMPLETED_QUANTITY are applicable.
859: */
860:
861: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110 THEN
862:
863: v_temp_sql2 := ' AND (x.PRIMARY_UOM_QUANTITY > x.COMPLETED_QUANTITY '
864: ||' OR (x.PRIMARY_UOM_QUANTITY = x.COMPLETED_QUANTITY ';
865:

Line 870: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 AND (p_worker_num <> 2) THEN

866: v_temp_sql2 := v_temp_sql2 ||' AND x.requirement_date >= trunc( sysdate - (' || v_msc_so_offset_days ||' )))) ';
867:
868: END IF; /* MSC_UTIL.G_APPS110 */
869:
870: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 AND (p_worker_num <> 2) THEN
871: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
872: v_temp_sql2 := ' AND (x.ORIGINAL_ORDERED_QUANTITY >= x.ORIGINAL_COMPLETED_QUANTITY) ';
873:
874: ELSE

Line 871: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections

867:
868: END IF; /* MSC_UTIL.G_APPS110 */
869:
870: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 AND (p_worker_num <> 2) THEN
871: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
872: v_temp_sql2 := ' AND (x.ORIGINAL_ORDERED_QUANTITY >= x.ORIGINAL_COMPLETED_QUANTITY) ';
873:
874: ELSE
875: v_temp_sql2 := 'AND (x.ORIGINAL_ORDERED_QUANTITY > x.ORIGINAL_COMPLETED_QUANTITY '

Line 889: IF MSC_CL_PULL.v_view_name = 'MRP_AP2_SALES_ORDERS_V' THEN /* Bug 3019053 */

885: /* This will handle AP2 and AN2 - first union */
886: v_temp_sql2 := ' ';
887: END IF;
888:
889: IF MSC_CL_PULL.v_view_name = 'MRP_AP2_SALES_ORDERS_V' THEN /* Bug 3019053 */
890: v_temp_sql2 := ' ';
891: END IF;
892:
893: IF MSC_CL_PULL.v_view_name = 'MRP_AN2_SALES_ORDERS_V' THEN

Line 893: IF MSC_CL_PULL.v_view_name = 'MRP_AN2_SALES_ORDERS_V' THEN

889: IF MSC_CL_PULL.v_view_name = 'MRP_AP2_SALES_ORDERS_V' THEN /* Bug 3019053 */
890: v_temp_sql2 := ' ';
891: END IF;
892:
893: IF MSC_CL_PULL.v_view_name = 'MRP_AN2_SALES_ORDERS_V' THEN
894: v_select_sql := ' SELECT /*+ index( x.ool oe_odr_lines_sn_n1) */ ';
895: ELSE
896: v_select_sql := ' SELECT ';
897: END IF;

Line 988: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 then

984: ||' x.FORECAST_VISIBLE,'
985: ||' x.DEMAND_VISIBLE,'
986: ||' x.SALESREP_CONTACT,';
987:
988: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 then
989: v_sql_stmt := v_sql_stmt ||' x.SALESREP_ID,';
990: else
991: v_sql_stmt := v_sql_stmt ||' NULL,';
992: end if;

Line 1015: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'

1011: ||' x.PROMISE_DATE,'
1012: ||' :v_refresh_id,'
1013: ||' :v_instance_id,'
1014: || v_temp_sql1
1015: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
1016: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1017: || v_temp_sql2
1018: || v_temp_sql3
1019: || v_temp_sql4

Line 1022: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN

1018: || v_temp_sql3
1019: || v_temp_sql4
1020: || v_union_sql ;
1021:
1022: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
1024: EXECUTE IMMEDIATE v_sql_stmt
1025: USING MSC_CL_PULL.v_refresh_id,
1026: MSC_CL_PULL.v_instance_id,

Line 1025: USING MSC_CL_PULL.v_refresh_id,

1021:
1022: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
1024: EXECUTE IMMEDIATE v_sql_stmt
1025: USING MSC_CL_PULL.v_refresh_id,
1026: MSC_CL_PULL.v_instance_id,
1027: MSC_CL_PULL.v_lrn,
1028: MSC_CL_PULL.v_lrn,
1029: MSC_CL_PULL.v_lrn;

Line 1026: MSC_CL_PULL.v_instance_id,

1022: IF MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS115 THEN
1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
1024: EXECUTE IMMEDIATE v_sql_stmt
1025: USING MSC_CL_PULL.v_refresh_id,
1026: MSC_CL_PULL.v_instance_id,
1027: MSC_CL_PULL.v_lrn,
1028: MSC_CL_PULL.v_lrn,
1029: MSC_CL_PULL.v_lrn;
1030:

Line 1027: MSC_CL_PULL.v_lrn,

1023: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,v_sql_stmt);
1024: EXECUTE IMMEDIATE v_sql_stmt
1025: USING MSC_CL_PULL.v_refresh_id,
1026: MSC_CL_PULL.v_instance_id,
1027: MSC_CL_PULL.v_lrn,
1028: MSC_CL_PULL.v_lrn,
1029: MSC_CL_PULL.v_lrn;
1030:
1031: ELSE -- 11i source instance

Line 1028: MSC_CL_PULL.v_lrn,

1024: EXECUTE IMMEDIATE v_sql_stmt
1025: USING MSC_CL_PULL.v_refresh_id,
1026: MSC_CL_PULL.v_instance_id,
1027: MSC_CL_PULL.v_lrn,
1028: MSC_CL_PULL.v_lrn,
1029: MSC_CL_PULL.v_lrn;
1030:
1031: ELSE -- 11i source instance
1032:

Line 1029: MSC_CL_PULL.v_lrn;

1025: USING MSC_CL_PULL.v_refresh_id,
1026: MSC_CL_PULL.v_instance_id,
1027: MSC_CL_PULL.v_lrn,
1028: MSC_CL_PULL.v_lrn,
1029: MSC_CL_PULL.v_lrn;
1030:
1031: ELSE -- 11i source instance
1032:
1033: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections

Line 1033: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections

1029: MSC_CL_PULL.v_lrn;
1030:
1031: ELSE -- 11i source instance
1032:
1033: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
1034: if (p_worker_num = 2) then
1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1036: EXECUTE IMMEDIATE v_sql_stmt
1037: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

Line 1037: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

1033: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
1034: if (p_worker_num = 2) then
1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1036: EXECUTE IMMEDIATE v_sql_stmt
1037: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1038: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1039: elsif (p_worker_num in (3)) then
1040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1041: EXECUTE IMMEDIATE v_sql_stmt USING

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

1034: if (p_worker_num = 2) then
1035: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1036: EXECUTE IMMEDIATE v_sql_stmt
1037: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1038: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1039: elsif (p_worker_num in (3)) then
1040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1041: EXECUTE IMMEDIATE v_sql_stmt USING
1042: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id

Line 1042: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id

1038: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1039: elsif (p_worker_num in (3)) then
1040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1041: EXECUTE IMMEDIATE v_sql_stmt USING
1042: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id
1043: ,MSC_CL_PULL.v_lrn,MSC_CL_PULL.v_lrn;
1044:
1045: else
1046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);

Line 1043: ,MSC_CL_PULL.v_lrn,MSC_CL_PULL.v_lrn;

1039: elsif (p_worker_num in (3)) then
1040: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1041: EXECUTE IMMEDIATE v_sql_stmt USING
1042: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id
1043: ,MSC_CL_PULL.v_lrn,MSC_CL_PULL.v_lrn;
1044:
1045: else
1046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1047: EXECUTE IMMEDIATE v_sql_stmt

Line 1048: USING MSC_CL_PULL.v_refresh_id,

1044:
1045: else
1046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1047: EXECUTE IMMEDIATE v_sql_stmt
1048: USING MSC_CL_PULL.v_refresh_id,
1049: MSC_CL_PULL.v_instance_id,
1050: MSC_CL_PULL.v_lrn,
1051: MSC_CL_PULL.v_lrn,
1052: MSC_CL_PULL.v_lrn;

Line 1049: MSC_CL_PULL.v_instance_id,

1045: else
1046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1047: EXECUTE IMMEDIATE v_sql_stmt
1048: USING MSC_CL_PULL.v_refresh_id,
1049: MSC_CL_PULL.v_instance_id,
1050: MSC_CL_PULL.v_lrn,
1051: MSC_CL_PULL.v_lrn,
1052: MSC_CL_PULL.v_lrn;
1053: end if;

Line 1050: MSC_CL_PULL.v_lrn,

1046: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1047: EXECUTE IMMEDIATE v_sql_stmt
1048: USING MSC_CL_PULL.v_refresh_id,
1049: MSC_CL_PULL.v_instance_id,
1050: MSC_CL_PULL.v_lrn,
1051: MSC_CL_PULL.v_lrn,
1052: MSC_CL_PULL.v_lrn;
1053: end if;
1054:

Line 1051: MSC_CL_PULL.v_lrn,

1047: EXECUTE IMMEDIATE v_sql_stmt
1048: USING MSC_CL_PULL.v_refresh_id,
1049: MSC_CL_PULL.v_instance_id,
1050: MSC_CL_PULL.v_lrn,
1051: MSC_CL_PULL.v_lrn,
1052: MSC_CL_PULL.v_lrn;
1053: end if;
1054:
1055: ELSE --- complete/targeted collections

Line 1052: MSC_CL_PULL.v_lrn;

1048: USING MSC_CL_PULL.v_refresh_id,
1049: MSC_CL_PULL.v_instance_id,
1050: MSC_CL_PULL.v_lrn,
1051: MSC_CL_PULL.v_lrn,
1052: MSC_CL_PULL.v_lrn;
1053: end if;
1054:
1055: ELSE --- complete/targeted collections
1056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);

Line 1058: USING MSC_CL_PULL.v_refresh_id,

1054:
1055: ELSE --- complete/targeted collections
1056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1057: EXECUTE IMMEDIATE v_sql_stmt
1058: USING MSC_CL_PULL.v_refresh_id,
1059: MSC_CL_PULL.v_instance_id;
1060: END IF;
1061: END IF;
1062:

Line 1059: MSC_CL_PULL.v_instance_id;

1055: ELSE --- complete/targeted collections
1056: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1057: EXECUTE IMMEDIATE v_sql_stmt
1058: USING MSC_CL_PULL.v_refresh_id,
1059: MSC_CL_PULL.v_instance_id;
1060: END IF;
1061: END IF;
1062:
1063: ELSE -- 107 source instance

Line 1126: ||' FROM MRP_AP_SALES_ORDERS_V'||MSC_CL_PULL.v_dblink||' x'

1122: ||' x.PROJECT_ID,'
1123: ||' x.TASK_ID,'
1124: ||' x.PLANNING_GROUP,'
1125: ||' :v_instance_id'
1126: ||' FROM MRP_AP_SALES_ORDERS_V'||MSC_CL_PULL.v_dblink||' x'
1127: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1128: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1129: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1130: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';

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

1124: ||' x.PLANNING_GROUP,'
1125: ||' :v_instance_id'
1126: ||' FROM MRP_AP_SALES_ORDERS_V'||MSC_CL_PULL.v_dblink||' x'
1127: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1128: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1129: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1130: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1131:
1132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);

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

1125: ||' :v_instance_id'
1126: ||' FROM MRP_AP_SALES_ORDERS_V'||MSC_CL_PULL.v_dblink||' x'
1127: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1128: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1129: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1130: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1131:
1132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1133: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

1126: ||' FROM MRP_AP_SALES_ORDERS_V'||MSC_CL_PULL.v_dblink||' x'
1127: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1128: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1129: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1130: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1131:
1132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1133: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1134:

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

1129: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1130: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1131:
1132: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_2,v_sql_stmt);
1133: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1134:
1135: END IF;
1136: COMMIT;
1137: END LOAD_SALES_ORDER;

Line 1145: IF MSC_CL_PULL.HARD_RESRVS_ENABLED= MSC_UTIL.SYS_YES THEN

1141:
1142: PROCEDURE LOAD_HARD_RESERVATION IS
1143: BEGIN
1144:
1145: IF MSC_CL_PULL.HARD_RESRVS_ENABLED= MSC_UTIL.SYS_YES THEN
1146:
1147: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1148:
1149: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';

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

1143: BEGIN
1144:
1145: IF MSC_CL_PULL.HARD_RESRVS_ENABLED= MSC_UTIL.SYS_YES THEN
1146:
1147: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1148:
1149: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
1150: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
1151:

Line 1149: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';

1145: IF MSC_CL_PULL.HARD_RESRVS_ENABLED= MSC_UTIL.SYS_YES THEN
1146:
1147: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1148:
1149: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
1150: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
1151:
1152: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1153: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1150: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';

1146:
1147: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1148:
1149: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
1150: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
1151:
1152: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1153: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1154: ELSE

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

1148:
1149: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
1150: MSC_CL_PULL.v_view_name := 'MRP_AD_HARD_RESERVATIONS_V';
1151:
1152: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1153: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1154: ELSE
1155: v_temp_sql := NULL;
1156: END IF;

Line 1171: ||' from MRP_AD_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'

1167: ||' x.PARENT_DEMAND_ID,'
1168: ||' 1,'
1169: ||' :v_refresh_id,'
1170: ||' :v_instance_id'
1171: ||' from MRP_AD_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1172: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1173: || v_temp_sql;
1174:
1175: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

1168: ||' 1,'
1169: ||' :v_refresh_id,'
1170: ||' :v_instance_id'
1171: ||' from MRP_AD_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1172: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1173: || v_temp_sql;
1174:
1175: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1176:

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

1171: ||' from MRP_AD_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1172: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1173: || v_temp_sql;
1174:
1175: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1176:
1177: COMMIT;
1178: /* Changes For Bug 6147734 */
1179: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then

Line 1179: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then

1175: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1176:
1177: COMMIT;
1178: /* Changes For Bug 6147734 */
1179: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then
1180: v_sql_stmt:=
1181: 'insert into MSC_ST_RESERVATIONS'
1182: ||' ( TRANSACTION_ID,'
1183: ||' SUPPLY_SOURCE_TYPE_ID,'

Line 1205: ||' from MRP_AD_REPAIR_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'

1201: ||' x.ORDER2_INVENTORY_ITEM_ID,'
1202: ||' 1,'
1203: ||' :v_refresh_id,'
1204: ||' :v_instance_id'
1205: ||' from MRP_AD_REPAIR_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1206: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1207: ;
1208:
1209:

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

1202: ||' 1,'
1203: ||' :v_refresh_id,'
1204: ||' :v_instance_id'
1205: ||' from MRP_AD_REPAIR_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1206: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1207: ;
1208:
1209:
1210: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

1206: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1207: ;
1208:
1209:
1210: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1211: COMMIT;
1212: End If; -- Srp Profile Check
1213: END IF; -- Incremental Refresh
1214:

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

1211: COMMIT;
1212: End If; -- Srp Profile Check
1213: END IF; -- Incremental Refresh
1214:
1215: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1216: v_temp_sql := ' AND x.GET_ORDERED_QUANTITY > x.GET_SHIPPED_QUANTITY ';
1217: ELSE
1218: v_temp_sql := ' ';
1219: END IF;

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

1217: ELSE
1218: v_temp_sql := ' ';
1219: END IF;
1220:
1221: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1222: v_temp_sql1 := ' AND x.RN1 > :v_lrn';
1223: /* ds change */
1224: v_temp_sql2 := ' SUPPLY_SOURCE_HEADER_ID,SUPPLY_SOURCE_TYPE_ID, ';
1225: v_temp_sql3 := ' x.SUPPLY_SOURCE_HEADER_ID,x.SUPPLY_SOURCE_TYPE_ID, ';

Line 1232: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';

1228: v_temp_sql2 := ' NULL,NULL, ';
1229: v_temp_sql3 := ' NULL.NULL, ';
1230: END IF;
1231:
1232: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
1233: MSC_CL_PULL.v_view_name := 'MRP_AP_HARD_RESERVATIONS_V';
1234:
1235: v_sql_stmt:=
1236: 'insert into MSC_ST_RESERVATIONS'

Line 1233: MSC_CL_PULL.v_view_name := 'MRP_AP_HARD_RESERVATIONS_V';

1229: v_temp_sql3 := ' NULL.NULL, ';
1230: END IF;
1231:
1232: MSC_CL_PULL.v_table_name:= 'MSC_ST_RESERVATIONS';
1233: MSC_CL_PULL.v_view_name := 'MRP_AP_HARD_RESERVATIONS_V';
1234:
1235: v_sql_stmt:=
1236: 'insert into MSC_ST_RESERVATIONS'
1237: ||' ( INVENTORY_ITEM_ID,'

Line 1281: ||' from MRP_AP_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'

1277: || v_temp_sql3
1278: ||' 2,'
1279: ||' :v_refresh_id,'
1280: ||' :v_instance_id'
1281: ||' from MRP_AP_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1282: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str|| v_temp_sql || v_temp_sql1;
1283:
1284: /*||' AND (' -- NCP: x.RN1>'||MSC_CL_PULL.v_lrn
1285: ||' x.RN2>'||MSC_CL_PULL.v_lrn||')';

Line 1284: /*||' AND (' -- NCP: x.RN1>'||MSC_CL_PULL.v_lrn

1280: ||' :v_instance_id'
1281: ||' from MRP_AP_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1282: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str|| v_temp_sql || v_temp_sql1;
1283:
1284: /*||' AND (' -- NCP: x.RN1>'||MSC_CL_PULL.v_lrn
1285: ||' x.RN2>'||MSC_CL_PULL.v_lrn||')';
1286:
1287: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1288: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn

Line 1285: ||' x.RN2>'||MSC_CL_PULL.v_lrn||')';

1281: ||' from MRP_AP_HARD_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1282: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str|| v_temp_sql || v_temp_sql1;
1283:
1284: /*||' AND (' -- NCP: x.RN1>'||MSC_CL_PULL.v_lrn
1285: ||' x.RN2>'||MSC_CL_PULL.v_lrn||')';
1286:
1287: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1288: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1289: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn

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

1283:
1284: /*||' AND (' -- NCP: x.RN1>'||MSC_CL_PULL.v_lrn
1285: ||' x.RN2>'||MSC_CL_PULL.v_lrn||')';
1286:
1287: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1288: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1289: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
1290: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')'; */
1291:

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

1284: /*||' AND (' -- NCP: x.RN1>'||MSC_CL_PULL.v_lrn
1285: ||' x.RN2>'||MSC_CL_PULL.v_lrn||')';
1286:
1287: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1288: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1289: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
1290: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')'; */
1291:
1292: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1289: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn

1285: ||' x.RN2>'||MSC_CL_PULL.v_lrn||')';
1286:
1287: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1288: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1289: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
1290: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')'; */
1291:
1292: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1293: -- EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1290: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')'; */

1286:
1287: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
1288: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1289: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
1290: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')'; */
1291:
1292: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1293: -- EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1294:

Line 1292: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1288: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
1289: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
1290: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')'; */
1291:
1292: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1293: -- EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1294:
1295: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1296: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

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

1289: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
1290: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')'; */
1291:
1292: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1293: -- EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1294:
1295: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1296: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1297: ELSE

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

1291:
1292: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1293: -- EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1294:
1295: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1296: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1297: ELSE
1298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn;
1299: END IF;

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

1292: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1293: -- EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1294:
1295: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1296: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1297: ELSE
1298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn;
1299: END IF;
1300:

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

1294:
1295: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1296: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1297: ELSE
1298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn, MSC_CL_PULL.v_lrn;
1299: END IF;
1300:
1301: COMMIT;
1302:

Line 1304: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then -- SRP Changes For Bug 5988024

1300:
1301: COMMIT;
1302:
1303:
1304: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then -- SRP Changes For Bug 5988024
1305:
1306: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1307: v_temp_sql1 := ' OR x.date1 > :date1 OR x.date2 > :date2 ';
1308: ELSE

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

1302:
1303:
1304: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then -- SRP Changes For Bug 5988024
1305:
1306: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1307: v_temp_sql1 := ' OR x.date1 > :date1 OR x.date2 > :date2 ';
1308: ELSE
1309: v_temp_sql1 := NULL;
1310: END IF;

Line 1345: ||' from MRP_AP_REPAIR_TRANSFERS_RESV_V'||MSC_CL_PULL.v_dblink||' x'

1341: ||' x.TASK_ID,'
1342: ||' 2,'
1343: ||' :v_refresh_id,'
1344: ||' :v_instance_id'
1345: ||' from MRP_AP_REPAIR_TRANSFERS_RESV_V'||MSC_CL_PULL.v_dblink||' x'
1346: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str
1347: ||' AND x.RN1 > :v_lrn'
1348: || v_temp_sql1;
1349:

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

1348: || v_temp_sql1;
1349:
1350:
1351:
1352: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1353: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1354: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1355: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME,MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;
1356: /* For Bug 6144734 */

Line 1353: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1349:
1350:
1351:
1352: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1353: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1354: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1355: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME,MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;
1356: /* For Bug 6144734 */
1357: v_sql_stmt:=

Line 1354: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

1350:
1351:
1352: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1353: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1354: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1355: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME,MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;
1356: /* For Bug 6144734 */
1357: v_sql_stmt:=
1358: 'Insert into MSC_ST_RESERVATIONS'

Line 1355: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME,MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;

1351:
1352: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1353: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1354: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
1355: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME,MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;
1356: /* For Bug 6144734 */
1357: v_sql_stmt:=
1358: 'Insert into MSC_ST_RESERVATIONS'
1359: ||' ( TRANSACTION_ID,'

Line 1382: ||' from MRP_AP_REPAIR_ORDERS_V'||MSC_CL_PULL.v_dblink ||' x'

1378: ||' null,'
1379: ||' 1,'
1380: ||' :v_refresh_id,'
1381: ||' :v_instance_id'
1382: ||' from MRP_AP_REPAIR_ORDERS_V'||MSC_CL_PULL.v_dblink ||' x'
1383: ||' where x.organization_id '||MSC_UTIL.v_depot_org_str
1384: || ' AND x.RO_STATUS_CODE = '||'''C'''
1385: ||' AND x. LAST_UPDATE_DATE > :date1' ;
1386:

Line 1389: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1385: ||' AND x. LAST_UPDATE_DATE > :date1' ;
1386:
1387:
1388:
1389: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1390: MSC_CL_PULL.v_instance_id,
1391: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;
1392:
1393: ELSE

Line 1390: MSC_CL_PULL.v_instance_id,

1386:
1387:
1388:
1389: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1390: MSC_CL_PULL.v_instance_id,
1391: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;
1392:
1393: ELSE
1394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 1391: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;

1387:
1388:
1389: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1390: MSC_CL_PULL.v_instance_id,
1391: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;
1392:
1393: ELSE
1394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1395: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

Line 1394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1390: MSC_CL_PULL.v_instance_id,
1391: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;
1392:
1393: ELSE
1394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1395: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1396: END IF;
1397:
1398:

Line 1395: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

1391: MSC_CL_PULL.g_LAST_SUCC_RES_REF_TIME;
1392:
1393: ELSE
1394: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1395: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1396: END IF;
1397:
1398:
1399: commit;

Line 1435: ||' from MRP_AP_EXT_REP_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'

1431: ||' x.TASK_ID,'
1432: ||' 2,'
1433: ||' :v_refresh_id,'
1434: ||' :v_instance_id'
1435: ||' from MRP_AP_EXT_REP_RESERVATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1436: ||' WHERE x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str
1437: ||' AND ((x.RN > :v_lrn) OR (x.RN1 > :v_lrn) OR (x.RN2 > :v_lrn) OR (x.RN3 > :v_lrn)
1438: OR (x.RN4 > :v_lrn) OR (x.RN5 > :v_lrn) OR (x.RN6 > :v_lrn))'
1439: ;

Line 1442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1438: OR (x.RN4 > :v_lrn) OR (x.RN5 > :v_lrn) OR (x.RN6 > :v_lrn))'
1439: ;
1440:
1441: /* Changed For bug 6144734 */
1442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1443: MSC_CL_PULL.v_instance_id,
1444: MSC_CL_PULL.v_lrn,
1445: MSC_CL_PULL.v_lrn,
1446: MSC_CL_PULL.v_lrn,

Line 1443: MSC_CL_PULL.v_instance_id,

1439: ;
1440:
1441: /* Changed For bug 6144734 */
1442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1443: MSC_CL_PULL.v_instance_id,
1444: MSC_CL_PULL.v_lrn,
1445: MSC_CL_PULL.v_lrn,
1446: MSC_CL_PULL.v_lrn,
1447: MSC_CL_PULL.v_lrn,

Line 1444: MSC_CL_PULL.v_lrn,

1440:
1441: /* Changed For bug 6144734 */
1442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1443: MSC_CL_PULL.v_instance_id,
1444: MSC_CL_PULL.v_lrn,
1445: MSC_CL_PULL.v_lrn,
1446: MSC_CL_PULL.v_lrn,
1447: MSC_CL_PULL.v_lrn,
1448: MSC_CL_PULL.v_lrn,

Line 1445: MSC_CL_PULL.v_lrn,

1441: /* Changed For bug 6144734 */
1442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1443: MSC_CL_PULL.v_instance_id,
1444: MSC_CL_PULL.v_lrn,
1445: MSC_CL_PULL.v_lrn,
1446: MSC_CL_PULL.v_lrn,
1447: MSC_CL_PULL.v_lrn,
1448: MSC_CL_PULL.v_lrn,
1449: MSC_CL_PULL.v_lrn,

Line 1446: MSC_CL_PULL.v_lrn,

1442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1443: MSC_CL_PULL.v_instance_id,
1444: MSC_CL_PULL.v_lrn,
1445: MSC_CL_PULL.v_lrn,
1446: MSC_CL_PULL.v_lrn,
1447: MSC_CL_PULL.v_lrn,
1448: MSC_CL_PULL.v_lrn,
1449: MSC_CL_PULL.v_lrn,
1450: MSC_CL_PULL.v_lrn;

Line 1447: MSC_CL_PULL.v_lrn,

1443: MSC_CL_PULL.v_instance_id,
1444: MSC_CL_PULL.v_lrn,
1445: MSC_CL_PULL.v_lrn,
1446: MSC_CL_PULL.v_lrn,
1447: MSC_CL_PULL.v_lrn,
1448: MSC_CL_PULL.v_lrn,
1449: MSC_CL_PULL.v_lrn,
1450: MSC_CL_PULL.v_lrn;
1451:

Line 1448: MSC_CL_PULL.v_lrn,

1444: MSC_CL_PULL.v_lrn,
1445: MSC_CL_PULL.v_lrn,
1446: MSC_CL_PULL.v_lrn,
1447: MSC_CL_PULL.v_lrn,
1448: MSC_CL_PULL.v_lrn,
1449: MSC_CL_PULL.v_lrn,
1450: MSC_CL_PULL.v_lrn;
1451:
1452: commit;

Line 1449: MSC_CL_PULL.v_lrn,

1445: MSC_CL_PULL.v_lrn,
1446: MSC_CL_PULL.v_lrn,
1447: MSC_CL_PULL.v_lrn,
1448: MSC_CL_PULL.v_lrn,
1449: MSC_CL_PULL.v_lrn,
1450: MSC_CL_PULL.v_lrn;
1451:
1452: commit;
1453:

Line 1450: MSC_CL_PULL.v_lrn;

1446: MSC_CL_PULL.v_lrn,
1447: MSC_CL_PULL.v_lrn,
1448: MSC_CL_PULL.v_lrn,
1449: MSC_CL_PULL.v_lrn,
1450: MSC_CL_PULL.v_lrn;
1451:
1452: commit;
1453:
1454: END IF; -- SRP Changes For Bug 5988024

Line 1464: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND

1460:
1461: PROCEDURE LOAD_USER_DEMAND IS
1462: BEGIN
1463:
1464: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1465: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1466:
1467: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1468:

Line 1465: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN

1461: PROCEDURE LOAD_USER_DEMAND IS
1462: BEGIN
1463:
1464: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1465: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1466:
1467: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1468:
1469: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

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

1463:
1464: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1465: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1466:
1467: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1468:
1469: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
1470: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_DEMANDS_V';
1471:

Line 1469: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

1465: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1466:
1467: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1468:
1469: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
1470: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_DEMANDS_V';
1471:
1472: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1473: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1470: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_DEMANDS_V';

1466:
1467: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1468:
1469: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
1470: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_DEMANDS_V';
1471:
1472: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1473: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1474: ELSE

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

1468:
1469: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
1470: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_DEMANDS_V';
1471:
1472: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1473: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1474: ELSE
1475: v_temp_sql := NULL;
1476: END IF;

Line 1493: ||' FROM MRP_AD_USER_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

1489: ||' 1,'
1490: ||' x.ORGANIZATION_ID,'
1491: ||' :v_refresh_id,'
1492: ||' :v_instance_id'
1493: ||' FROM MRP_AD_USER_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
1494: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1495: || v_temp_sql;
1496:
1497: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

1490: ||' x.ORGANIZATION_ID,'
1491: ||' :v_refresh_id,'
1492: ||' :v_instance_id'
1493: ||' FROM MRP_AD_USER_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
1494: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1495: || v_temp_sql;
1496:
1497: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1498:

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

1493: ||' FROM MRP_AD_USER_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
1494: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1495: || v_temp_sql;
1496:
1497: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1498:
1499: COMMIT;
1500:
1501: END IF;

Line 1503: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

1499: COMMIT;
1500:
1501: END IF;
1502:
1503: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
1504: MSC_CL_PULL.v_view_name := 'MRP_AP_USER_DEMANDS_V';
1505:
1506: v_sql_stmt:=
1507: ' INSERT INTO MSC_ST_DEMANDS'

Line 1504: MSC_CL_PULL.v_view_name := 'MRP_AP_USER_DEMANDS_V';

1500:
1501: END IF;
1502:
1503: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
1504: MSC_CL_PULL.v_view_name := 'MRP_AP_USER_DEMANDS_V';
1505:
1506: v_sql_stmt:=
1507: ' INSERT INTO MSC_ST_DEMANDS'
1508: ||'( DISPOSITION_ID,'

Line 1536: ||' FROM MRP_AP_USER_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

1532: ||' x.DEMAND_CLASS,'
1533: ||' 2,'
1534: ||' :v_refresh_id,'
1535: ||' :v_instance_id'
1536: ||' FROM MRP_AP_USER_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
1537: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1538: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1539: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1540:

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

1534: ||' :v_refresh_id,'
1535: ||' :v_instance_id'
1536: ||' FROM MRP_AP_USER_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
1537: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1538: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1539: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1540:
1541: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1542: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 1539: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';

1535: ||' :v_instance_id'
1536: ||' FROM MRP_AP_USER_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
1537: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1538: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1539: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1540:
1541: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1542: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1543:

Line 1541: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

1537: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1538: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1539: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1540:
1541: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1542: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1543:
1544: COMMIT;
1545:

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

1538: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1539: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
1540:
1541: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1542: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1543:
1544: COMMIT;
1545:
1546: END IF;

Line 1563: -- MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';

1559:
1560:
1561:
1562: -- Not needed, Clean it up once it is coded
1563: -- MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
1564:
1565: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1566: MSC_CL_PULL.v_view_name := 'MRP_AN_AHL_MTL_REQS_V';
1567: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn OR x.RN3> :v_lrn )';

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

1561:
1562: -- Not needed, Clean it up once it is coded
1563: -- MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
1564:
1565: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1566: MSC_CL_PULL.v_view_name := 'MRP_AN_AHL_MTL_REQS_V';
1567: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn OR x.RN3> :v_lrn )';
1568:
1569: ELSE

Line 1566: MSC_CL_PULL.v_view_name := 'MRP_AN_AHL_MTL_REQS_V';

1562: -- Not needed, Clean it up once it is coded
1563: -- MSC_CL_PULL.v_table_name:= 'MSC_ST_SALES_ORDERS';
1564:
1565: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1566: MSC_CL_PULL.v_view_name := 'MRP_AN_AHL_MTL_REQS_V';
1567: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn OR x.RN3> :v_lrn )';
1568:
1569: ELSE
1570: MSC_CL_PULL.v_view_name := 'MRP_AP_AHL_MTL_REQS_V';

Line 1570: MSC_CL_PULL.v_view_name := 'MRP_AP_AHL_MTL_REQS_V';

1566: MSC_CL_PULL.v_view_name := 'MRP_AN_AHL_MTL_REQS_V';
1567: v_temp_sql3 := ' AND (x.RN1 > :v_lrn OR x.RN2> :v_lrn OR x.RN3> :v_lrn )';
1568:
1569: ELSE
1570: MSC_CL_PULL.v_view_name := 'MRP_AP_AHL_MTL_REQS_V';
1571: v_temp_sql3 := ' ';
1572:
1573: END IF;
1574:

Line 1697: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'

1693: -- ||' x.LATEST_ACCEPTABLE_DATE,'
1694: -- ||' x.SHIPPING_METHOD_CODE,'
1695: -- ||' x.ATO_LINE_ID,'
1696: -- ||' x.ORDER_DATE_TYPE_CODE '
1697: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
1698: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1699: ||' AND x.ORIGINAL_ORDERED_QUANTITY > x.ORIGINAL_COMPLETED_QUANTITY '
1700: || v_temp_sql3 ;
1701:

Line 1703: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections

1699: ||' AND x.ORIGINAL_ORDERED_QUANTITY > x.ORIGINAL_COMPLETED_QUANTITY '
1700: || v_temp_sql3 ;
1701:
1702:
1703: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
1704:
1705: EXECUTE IMMEDIATE v_sql_stmt
1706: USING MSC_CL_PULL.v_refresh_id,
1707: MSC_CL_PULL.v_instance_id,

Line 1706: USING MSC_CL_PULL.v_refresh_id,

1702:
1703: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
1704:
1705: EXECUTE IMMEDIATE v_sql_stmt
1706: USING MSC_CL_PULL.v_refresh_id,
1707: MSC_CL_PULL.v_instance_id,
1708: MSC_CL_PULL.v_lrn,
1709: MSC_CL_PULL.v_lrn,
1710: MSC_CL_PULL.v_lrn;

Line 1707: MSC_CL_PULL.v_instance_id,

1703: IF (MSC_CL_PULL.v_lrnn <> -1) THEN -- incremental collections
1704:
1705: EXECUTE IMMEDIATE v_sql_stmt
1706: USING MSC_CL_PULL.v_refresh_id,
1707: MSC_CL_PULL.v_instance_id,
1708: MSC_CL_PULL.v_lrn,
1709: MSC_CL_PULL.v_lrn,
1710: MSC_CL_PULL.v_lrn;
1711:

Line 1708: MSC_CL_PULL.v_lrn,

1704:
1705: EXECUTE IMMEDIATE v_sql_stmt
1706: USING MSC_CL_PULL.v_refresh_id,
1707: MSC_CL_PULL.v_instance_id,
1708: MSC_CL_PULL.v_lrn,
1709: MSC_CL_PULL.v_lrn,
1710: MSC_CL_PULL.v_lrn;
1711:
1712: ELSE --- complete/targeted collections

Line 1709: MSC_CL_PULL.v_lrn,

1705: EXECUTE IMMEDIATE v_sql_stmt
1706: USING MSC_CL_PULL.v_refresh_id,
1707: MSC_CL_PULL.v_instance_id,
1708: MSC_CL_PULL.v_lrn,
1709: MSC_CL_PULL.v_lrn,
1710: MSC_CL_PULL.v_lrn;
1711:
1712: ELSE --- complete/targeted collections
1713: EXECUTE IMMEDIATE v_sql_stmt

Line 1710: MSC_CL_PULL.v_lrn;

1706: USING MSC_CL_PULL.v_refresh_id,
1707: MSC_CL_PULL.v_instance_id,
1708: MSC_CL_PULL.v_lrn,
1709: MSC_CL_PULL.v_lrn,
1710: MSC_CL_PULL.v_lrn;
1711:
1712: ELSE --- complete/targeted collections
1713: EXECUTE IMMEDIATE v_sql_stmt
1714: USING MSC_CL_PULL.v_refresh_id,

Line 1714: USING MSC_CL_PULL.v_refresh_id,

1710: MSC_CL_PULL.v_lrn;
1711:
1712: ELSE --- complete/targeted collections
1713: EXECUTE IMMEDIATE v_sql_stmt
1714: USING MSC_CL_PULL.v_refresh_id,
1715: MSC_CL_PULL.v_instance_id;
1716: END IF;
1717:
1718:

Line 1715: MSC_CL_PULL.v_instance_id;

1711:
1712: ELSE --- complete/targeted collections
1713: EXECUTE IMMEDIATE v_sql_stmt
1714: USING MSC_CL_PULL.v_refresh_id,
1715: MSC_CL_PULL.v_instance_id;
1716: END IF;
1717:
1718:
1719: COMMIT;

Line 1725: IF MSC_CL_PULL.v_lrn = -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

1721:
1722: PROCEDURE LOAD_OPEN_PAYBACKS IS
1723: BEGIN
1724:
1725: IF MSC_CL_PULL.v_lrn = -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1726:
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'PROCEDURE LOAD_OPEN_PAYBACKS');
1728: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPEN_PAYBACKS';
1729: MSC_CL_PULL.v_view_name := 'MRP_AP_OPEN_PAYBACK_QTY_V';

Line 1728: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPEN_PAYBACKS';

1724:
1725: IF MSC_CL_PULL.v_lrn = -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1726:
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'PROCEDURE LOAD_OPEN_PAYBACKS');
1728: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPEN_PAYBACKS';
1729: MSC_CL_PULL.v_view_name := 'MRP_AP_OPEN_PAYBACK_QTY_V';
1730:
1731: v_sql_stmt:=
1732: ' INSERT INTO MSC_ST_OPEN_PAYBACKS(

Line 1729: MSC_CL_PULL.v_view_name := 'MRP_AP_OPEN_PAYBACK_QTY_V';

1725: IF MSC_CL_PULL.v_lrn = -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1726:
1727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'PROCEDURE LOAD_OPEN_PAYBACKS');
1728: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPEN_PAYBACKS';
1729: MSC_CL_PULL.v_view_name := 'MRP_AP_OPEN_PAYBACK_QTY_V';
1730:
1731: v_sql_stmt:=
1732: ' INSERT INTO MSC_ST_OPEN_PAYBACKS(
1733: SR_INSTANCE_ID,

Line 1758: FROM MRP_AP_OPEN_PAYBACK_QTY_V'||MSC_CL_PULL.v_dblink||

1754: BORROW_TASK_ID,
1755: PLANNING_GROUP,
1756: LENDING_PROJ_PLANNING_GROUP,
1757: END_ITEM_UNIT_NUMBER
1758: FROM MRP_AP_OPEN_PAYBACK_QTY_V'||MSC_CL_PULL.v_dblink||
1759: ' WHERE ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str;
1760:
1761: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id;
1762: COMMIT;

Line 1761: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id;

1757: END_ITEM_UNIT_NUMBER
1758: FROM MRP_AP_OPEN_PAYBACK_QTY_V'||MSC_CL_PULL.v_dblink||
1759: ' WHERE ORGANIZATION_ID '|| MSC_UTIL.v_in_org_str;
1760:
1761: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id;
1762: COMMIT;
1763:
1764: END IF;
1765: