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_RPO_PULL dependencies on MSC_CL_PULL

Line 26: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

22:
23: PROCEDURE LOAD_IRO IS
24: BEGIN
25:
26: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
27: MSC_CL_PULL.v_view_name := 'MRP_AP_REPAIR_ORDERS_V';
28:
29: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh for bug 6126698
30: v_temp_sql1 := ' AND ((x.LAST_UPDATE_DATE > :g_last_succ_rio_time) OR (x.item_rn > '||MSC_CL_PULL.v_lrnn ||'))';

Line 27: MSC_CL_PULL.v_view_name := 'MRP_AP_REPAIR_ORDERS_V';

23: PROCEDURE LOAD_IRO IS
24: BEGIN
25:
26: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
27: MSC_CL_PULL.v_view_name := 'MRP_AP_REPAIR_ORDERS_V';
28:
29: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh for bug 6126698
30: v_temp_sql1 := ' AND ((x.LAST_UPDATE_DATE > :g_last_succ_rio_time) OR (x.item_rn > '||MSC_CL_PULL.v_lrnn ||'))';
31:

Line 29: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh for bug 6126698

25:
26: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
27: MSC_CL_PULL.v_view_name := 'MRP_AP_REPAIR_ORDERS_V';
28:
29: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh for bug 6126698
30: v_temp_sql1 := ' AND ((x.LAST_UPDATE_DATE > :g_last_succ_rio_time) OR (x.item_rn > '||MSC_CL_PULL.v_lrnn ||'))';
31:
32: ELSE
33: v_temp_sql1 := ' AND x.RO_STATUS_CODE <> '||'''C''';

Line 30: v_temp_sql1 := ' AND ((x.LAST_UPDATE_DATE > :g_last_succ_rio_time) OR (x.item_rn > '||MSC_CL_PULL.v_lrnn ||'))';

26: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
27: MSC_CL_PULL.v_view_name := 'MRP_AP_REPAIR_ORDERS_V';
28:
29: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh for bug 6126698
30: v_temp_sql1 := ' AND ((x.LAST_UPDATE_DATE > :g_last_succ_rio_time) OR (x.item_rn > '||MSC_CL_PULL.v_lrnn ||'))';
31:
32: ELSE
33: v_temp_sql1 := ' AND x.RO_STATUS_CODE <> '||'''C''';
34:

Line 36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' MSC_CL_PULL.g_last_succ_iro_ref_time:'||to_char(MSC_CL_PULL.g_last_succ_iro_ref_time,'DD-MON-YYYY hh:mi:ss'));

32: ELSE
33: v_temp_sql1 := ' AND x.RO_STATUS_CODE <> '||'''C''';
34:
35: END IF;
36: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' MSC_CL_PULL.g_last_succ_iro_ref_time:'||to_char(MSC_CL_PULL.g_last_succ_iro_ref_time,'DD-MON-YYYY hh:mi:ss'));
37: v_sql_stmt := ' INSERT INTO MSC_ST_SUPPLIES '
38: ||' ( DISPOSITION_ID, '
39: ||' ORDER_TYPE, '
40: ||' ORDER_NUMBER, '

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

87: ||' :v_item_type_id ,'
88: ||' :v_item_type_good ,'
89: ||' :v_refresh_id ,'
90: ||' :v_instance_id'
91: ||' from MRP_AP_REPAIR_ORDERS_V'||MSC_CL_PULL.v_dblink ||' x'
92: ||' where x.organization_id '||MSC_UTIL.v_depot_org_str
93: || v_temp_sql1
94: ;
95:

Line 98: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

94: ;
95:
96:
97:
98: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
99:
100:
101: IF MSC_CL_PULL.v_lrnn<> -1 THEN
102: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ,MSC_CL_PULL.g_last_succ_iro_ref_time;

Line 101: IF MSC_CL_PULL.v_lrnn<> -1 THEN

97:
98: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
99:
100:
101: IF MSC_CL_PULL.v_lrnn<> -1 THEN
102: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ,MSC_CL_PULL.g_last_succ_iro_ref_time;
103: ELSE
104: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;
105: END IF;

Line 102: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ,MSC_CL_PULL.g_last_succ_iro_ref_time;

98: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
99:
100:
101: IF MSC_CL_PULL.v_lrnn<> -1 THEN
102: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ,MSC_CL_PULL.g_last_succ_iro_ref_time;
103: ELSE
104: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;
105: END IF;
106:

Line 104: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;

100:
101: IF MSC_CL_PULL.v_lrnn<> -1 THEN
102: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ,MSC_CL_PULL.g_last_succ_iro_ref_time;
103: ELSE
104: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;
105: END IF;
106:
107:
108: END IF;

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

112:
113: PROCEDURE LOAD_IRO_DEMAND IS
114: BEGIN
115:
116: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
117: MSC_CL_PULL.v_view_name := 'MRP_AP_REPAIR_DEMAND_V';
118:
119:
120: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698

Line 117: MSC_CL_PULL.v_view_name := 'MRP_AP_REPAIR_DEMAND_V';

113: PROCEDURE LOAD_IRO_DEMAND IS
114: BEGIN
115:
116: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
117: MSC_CL_PULL.v_view_name := 'MRP_AP_REPAIR_DEMAND_V';
118:
119:
120: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698
121:

Line 120: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698

116: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
117: MSC_CL_PULL.v_view_name := 'MRP_AP_REPAIR_DEMAND_V';
118:
119:
120: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698
121:
122: v_temp_sql1:= ' AND ((x.date1>:g_last_succ_iro_ref_time) OR (x.date2> :g_last_succ_iro_ref_time) OR (x.RN1>'
123: || MSC_CL_PULL.v_lrnn ||
124: ') OR (x.RN2>' || MSC_CL_PULL.v_lrnn ||

Line 123: || MSC_CL_PULL.v_lrnn ||

119:
120: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698
121:
122: v_temp_sql1:= ' AND ((x.date1>:g_last_succ_iro_ref_time) OR (x.date2> :g_last_succ_iro_ref_time) OR (x.RN1>'
123: || MSC_CL_PULL.v_lrnn ||
124: ') OR (x.RN2>' || MSC_CL_PULL.v_lrnn ||
125: ') OR (x.RN3>' || MSC_CL_PULL.v_lrnn ||
126: ')) ' ;
127:

Line 124: ') OR (x.RN2>' || MSC_CL_PULL.v_lrnn ||

120: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698
121:
122: v_temp_sql1:= ' AND ((x.date1>:g_last_succ_iro_ref_time) OR (x.date2> :g_last_succ_iro_ref_time) OR (x.RN1>'
123: || MSC_CL_PULL.v_lrnn ||
124: ') OR (x.RN2>' || MSC_CL_PULL.v_lrnn ||
125: ') OR (x.RN3>' || MSC_CL_PULL.v_lrnn ||
126: ')) ' ;
127:
128: ELSE

Line 125: ') OR (x.RN3>' || MSC_CL_PULL.v_lrnn ||

121:
122: v_temp_sql1:= ' AND ((x.date1>:g_last_succ_iro_ref_time) OR (x.date2> :g_last_succ_iro_ref_time) OR (x.RN1>'
123: || MSC_CL_PULL.v_lrnn ||
124: ') OR (x.RN2>' || MSC_CL_PULL.v_lrnn ||
125: ') OR (x.RN3>' || MSC_CL_PULL.v_lrnn ||
126: ')) ' ;
127:
128: ELSE
129: v_temp_sql1 := ' AND x.RO_STATUS_CODE <> '||'''C''';

Line 181: || ' from MRP_AP_REPAIR_DEMAND_V'|| MSC_CL_PULL.v_dblink ||' x'

177: ||' :v_item_type_id, '
178: ||' :v_item_type_good,'
179: ||' :v_refresh_id ,'
180: ||' :v_instance_id'
181: || ' from MRP_AP_REPAIR_DEMAND_V'|| MSC_CL_PULL.v_dblink ||' x'
182: || ' where x.organization_id '||MSC_UTIL.v_depot_org_str
183: || v_temp_sql1
184: ;
185:

Line 186: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

182: || ' where x.organization_id '||MSC_UTIL.v_depot_org_str
183: || v_temp_sql1
184: ;
185:
186: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
187:
188:
189: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
190: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id,

Line 189: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN

185:
186: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
187:
188:
189: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
190: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id,
191: MSC_CL_PULL.v_instance_id,MSC_CL_PULL.g_last_succ_iro_ref_time,MSC_CL_PULL.g_last_succ_iro_ref_time ;
192: ELSE
193: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;

Line 190: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id,

186: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
187:
188:
189: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
190: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id,
191: MSC_CL_PULL.v_instance_id,MSC_CL_PULL.g_last_succ_iro_ref_time,MSC_CL_PULL.g_last_succ_iro_ref_time ;
192: ELSE
193: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;
194: END IF;

Line 191: MSC_CL_PULL.v_instance_id,MSC_CL_PULL.g_last_succ_iro_ref_time,MSC_CL_PULL.g_last_succ_iro_ref_time ;

187:
188:
189: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
190: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id,
191: MSC_CL_PULL.v_instance_id,MSC_CL_PULL.g_last_succ_iro_ref_time,MSC_CL_PULL.g_last_succ_iro_ref_time ;
192: ELSE
193: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;
194: END IF;
195:

Line 193: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;

189: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
190: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id,
191: MSC_CL_PULL.v_instance_id,MSC_CL_PULL.g_last_succ_iro_ref_time,MSC_CL_PULL.g_last_succ_iro_ref_time ;
192: ELSE
193: Execute Immediate v_sql_stmt using v_item_type_id,v_item_type_good,MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id ;
194: END IF;
195:
196:
197: END IF;

Line 201: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698

197: END IF;
198:
199: COMMIT;
200:
201: IF ((MSC_CL_PULL.v_lrnn<> -1) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN -- incremental refresh for bug 6126698
202: BEGIN
203: v_temp_sql:=
204: 'insert into MSC_ST_DEMANDS'
205: ||' ( REPAIR_LINE_ID,'

Line 222: ||' from MRP_AD_RO_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

218: ||' 1,'
219: ||' 77,'
220: ||' :v_refresh_id,'
221: ||' :v_instance_id'
222: ||' from MRP_AD_RO_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
223: ||' Where x. date1 > :g_last_succ_iro_ref_time or x.date2 > :g_last_succ_iro_ref_time
224: or x.RN1 > ' ||MSC_CL_PULL.v_lrnn ;
225:
226:

Line 224: or x.RN1 > ' ||MSC_CL_PULL.v_lrnn ;

220: ||' :v_refresh_id,'
221: ||' :v_instance_id'
222: ||' from MRP_AD_RO_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
223: ||' Where x. date1 > :g_last_succ_iro_ref_time or x.date2 > :g_last_succ_iro_ref_time
224: or x.RN1 > ' ||MSC_CL_PULL.v_lrnn ;
225:
226:
227: Execute Immediate v_temp_sql using
228: MSC_CL_PULL.v_refresh_id,

Line 228: MSC_CL_PULL.v_refresh_id,

224: or x.RN1 > ' ||MSC_CL_PULL.v_lrnn ;
225:
226:
227: Execute Immediate v_temp_sql using
228: MSC_CL_PULL.v_refresh_id,
229: MSC_CL_PULL.v_instance_id,
230: MSC_CL_PULL.g_last_succ_iro_ref_time,
231: MSC_CL_PULL.g_last_succ_iro_ref_time ;
232:

Line 229: MSC_CL_PULL.v_instance_id,

225:
226:
227: Execute Immediate v_temp_sql using
228: MSC_CL_PULL.v_refresh_id,
229: MSC_CL_PULL.v_instance_id,
230: MSC_CL_PULL.g_last_succ_iro_ref_time,
231: MSC_CL_PULL.g_last_succ_iro_ref_time ;
232:
233: EXCEPTION

Line 230: MSC_CL_PULL.g_last_succ_iro_ref_time,

226:
227: Execute Immediate v_temp_sql using
228: MSC_CL_PULL.v_refresh_id,
229: MSC_CL_PULL.v_instance_id,
230: MSC_CL_PULL.g_last_succ_iro_ref_time,
231: MSC_CL_PULL.g_last_succ_iro_ref_time ;
232:
233: EXCEPTION
234: WHEN OTHERS THEN

Line 231: MSC_CL_PULL.g_last_succ_iro_ref_time ;

227: Execute Immediate v_temp_sql using
228: MSC_CL_PULL.v_refresh_id,
229: MSC_CL_PULL.v_instance_id,
230: MSC_CL_PULL.g_last_succ_iro_ref_time,
231: MSC_CL_PULL.g_last_succ_iro_ref_time ;
232:
233: EXCEPTION
234: WHEN OTHERS THEN
235: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, ' LOAD_IRO_DEMAND ');

Line 250: If MSC_CL_PULL.v_lrnn<> -1 THEN /incremental refresh /

246: PROCEDURE LOAD_ERO IS
247: lv_lbj_details NUMBER:=0;
248: BEGIN
249:
250: If MSC_CL_PULL.v_lrnn<> -1 THEN /*incremental refresh */
251: v_sql_stmt:=
252: 'insert into MSC_ST_SUPPLIES'
253: ||' ( DISPOSITION_ID,'
254: ||' ORDER_TYPE,'

Line 266: ||' from MRP_AD_ERO_WIP_JOB_SUPP_V'||MSC_CL_PULL.v_dblink||' x'

262: ||' x.organization_id,'
263: ||' 1,'
264: ||' :v_refresh_id,'
265: ||' :v_instance_id'
266: ||' from MRP_AD_ERO_WIP_JOB_SUPP_V'||MSC_CL_PULL.v_dblink||' x'
267: ||' where x.RN> :v_lrn '
268: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;
269:
270:

Line 272: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

268: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;
269:
270:
271:
272: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
273:
274: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, v_sql_stmt);
275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_instance_id);
276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);

Line 275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_instance_id);

271:
272: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
273:
274: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, v_sql_stmt);
275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_instance_id);
276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);
277:
278:
279: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);

272: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
273:
274: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, v_sql_stmt);
275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_instance_id);
276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);
277:
278:
279: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
280: MSC_CL_PULL.v_lrnn;

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

275: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_instance_id);
276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);
277:
278:
279: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
280: MSC_CL_PULL.v_lrnn;
281:
282: END IF;
283:

Line 280: MSC_CL_PULL.v_lrnn;

276: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, MSC_CL_PULL.v_lrnn);
277:
278:
279: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
280: MSC_CL_PULL.v_lrnn;
281:
282: END IF;
283:
284: END IF ; -- net change

Line 287: where instance_id = MSC_CL_PULL.v_instance_id ;

283:
284: END IF ; -- net change
285:
286: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
287: where instance_id = MSC_CL_PULL.v_instance_id ;
288:
289:
290: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
291: MSC_CL_PULL.v_view_name := 'MRP_AP_ERO_WIP_JOB_SUPPLY_V';

Line 290: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

286: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
287: where instance_id = MSC_CL_PULL.v_instance_id ;
288:
289:
290: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
291: MSC_CL_PULL.v_view_name := 'MRP_AP_ERO_WIP_JOB_SUPPLY_V';
292:
293: v_sql_stmt:=
294: 'insert into MSC_ST_SUPPLIES'

Line 291: MSC_CL_PULL.v_view_name := 'MRP_AP_ERO_WIP_JOB_SUPPLY_V';

287: where instance_id = MSC_CL_PULL.v_instance_id ;
288:
289:
290: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
291: MSC_CL_PULL.v_view_name := 'MRP_AP_ERO_WIP_JOB_SUPPLY_V';
292:
293: v_sql_stmt:=
294: 'insert into MSC_ST_SUPPLIES'
295: ||' ( INVENTORY_ITEM_ID,'

Line 383: ||' from MRP_AP_ERO_WIP_JOB_SUPPLY_V'||MSC_CL_PULL.v_dblink ||' x'

379: ||' :v_item_type_id,'
380: ||' :v_item_type_good,'
381: ||' :v_refresh_id,'
382: ||' :v_instance_id'
383: ||' from MRP_AP_ERO_WIP_JOB_SUPPLY_V'||MSC_CL_PULL.v_dblink ||' x'
384: ||' where x.organization_id '||MSC_UTIL.v_non_depot_org_str
385: || ' AND (x.RN1 > :v_lrn or x.RN2 > :v_lrn or x.RN3 >:v_lrn)'
386: ;
387:

Line 391: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

387:
388:
389:
390:
391: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
392: Execute Immediate v_sql_stmt
393: using
394: MSC_CL_PULL.v_mps_consume_profile_value,
395: MSC_CL_PULL.v_dgmt,

Line 394: MSC_CL_PULL.v_mps_consume_profile_value,

390:
391: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
392: Execute Immediate v_sql_stmt
393: using
394: MSC_CL_PULL.v_mps_consume_profile_value,
395: MSC_CL_PULL.v_dgmt,
396: MSC_CL_PULL.v_mps_consume_profile_value,
397: MSC_CL_PULL.v_dgmt,
398: v_item_type_id,

Line 395: MSC_CL_PULL.v_dgmt,

391: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
392: Execute Immediate v_sql_stmt
393: using
394: MSC_CL_PULL.v_mps_consume_profile_value,
395: MSC_CL_PULL.v_dgmt,
396: MSC_CL_PULL.v_mps_consume_profile_value,
397: MSC_CL_PULL.v_dgmt,
398: v_item_type_id,
399: v_item_type_good,

Line 396: MSC_CL_PULL.v_mps_consume_profile_value,

392: Execute Immediate v_sql_stmt
393: using
394: MSC_CL_PULL.v_mps_consume_profile_value,
395: MSC_CL_PULL.v_dgmt,
396: MSC_CL_PULL.v_mps_consume_profile_value,
397: MSC_CL_PULL.v_dgmt,
398: v_item_type_id,
399: v_item_type_good,
400: MSC_CL_PULL.v_refresh_id,

Line 397: MSC_CL_PULL.v_dgmt,

393: using
394: MSC_CL_PULL.v_mps_consume_profile_value,
395: MSC_CL_PULL.v_dgmt,
396: MSC_CL_PULL.v_mps_consume_profile_value,
397: MSC_CL_PULL.v_dgmt,
398: v_item_type_id,
399: v_item_type_good,
400: MSC_CL_PULL.v_refresh_id,
401: MSC_CL_PULL.v_instance_id ,

Line 400: MSC_CL_PULL.v_refresh_id,

396: MSC_CL_PULL.v_mps_consume_profile_value,
397: MSC_CL_PULL.v_dgmt,
398: v_item_type_id,
399: v_item_type_good,
400: MSC_CL_PULL.v_refresh_id,
401: MSC_CL_PULL.v_instance_id ,
402: MSC_CL_PULL.v_lrnn,
403: MSC_CL_PULL.v_lrnn,
404: MSC_CL_PULL.v_lrnn;

Line 401: MSC_CL_PULL.v_instance_id ,

397: MSC_CL_PULL.v_dgmt,
398: v_item_type_id,
399: v_item_type_good,
400: MSC_CL_PULL.v_refresh_id,
401: MSC_CL_PULL.v_instance_id ,
402: MSC_CL_PULL.v_lrnn,
403: MSC_CL_PULL.v_lrnn,
404: MSC_CL_PULL.v_lrnn;
405:

Line 402: MSC_CL_PULL.v_lrnn,

398: v_item_type_id,
399: v_item_type_good,
400: MSC_CL_PULL.v_refresh_id,
401: MSC_CL_PULL.v_instance_id ,
402: MSC_CL_PULL.v_lrnn,
403: MSC_CL_PULL.v_lrnn,
404: MSC_CL_PULL.v_lrnn;
405:
406: END IF;

Line 403: MSC_CL_PULL.v_lrnn,

399: v_item_type_good,
400: MSC_CL_PULL.v_refresh_id,
401: MSC_CL_PULL.v_instance_id ,
402: MSC_CL_PULL.v_lrnn,
403: MSC_CL_PULL.v_lrnn,
404: MSC_CL_PULL.v_lrnn;
405:
406: END IF;
407:

Line 404: MSC_CL_PULL.v_lrnn;

400: MSC_CL_PULL.v_refresh_id,
401: MSC_CL_PULL.v_instance_id ,
402: MSC_CL_PULL.v_lrnn,
403: MSC_CL_PULL.v_lrnn,
404: MSC_CL_PULL.v_lrnn;
405:
406: END IF;
407:
408:

Line 416: If MSC_CL_PULL.v_lrnn<> -1 then /incremental refresh /

412:
413: PROCEDURE LOAD_ERO_DEMAND IS
414: BEGIN
415:
416: If MSC_CL_PULL.v_lrnn<> -1 then /*incremental refresh */
417: v_sql_stmt:=
418: 'insert into MSC_ST_DEMANDS'
419: ||' ( WIP_ENTITY_ID,'
420: ||' OPERATION_SEQ_NUM,'

Line 436: ||' from MRP_AD_ERO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'

432: ||' x.ORIGINATION_TYPE,'
433: ||' 1,'
434: ||' :v_refresh_id,'
435: ||' :v_instance_id'
436: ||' from MRP_AD_ERO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'
437: ||' where x.RN> :v_lrn '
438: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;
439:
440: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

Line 440: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

436: ||' from MRP_AD_ERO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'
437: ||' where x.RN> :v_lrn '
438: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;
439:
440: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
441:
442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
443: MSC_CL_PULL.v_lrnn;
444: END IF;

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

438: ||' AND organization_id '||MSC_UTIL.v_non_depot_org_str;
439:
440: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
441:
442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
443: MSC_CL_PULL.v_lrnn;
444: END IF;
445:
446: END IF; -- Netchange

Line 443: MSC_CL_PULL.v_lrnn;

439:
440: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
441:
442: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
443: MSC_CL_PULL.v_lrnn;
444: END IF;
445:
446: END IF; -- Netchange
447:

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

444: END IF;
445:
446: END IF; -- Netchange
447:
448: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
449: MSC_CL_PULL.v_view_name := 'MRP_AP_ERO_WIP_DEMAND_V';
450:
451: v_sql_stmt:=
452: 'insert into MSC_ST_DEMANDS'

Line 449: MSC_CL_PULL.v_view_name := 'MRP_AP_ERO_WIP_DEMAND_V';

445:
446: END IF; -- Netchange
447:
448: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
449: MSC_CL_PULL.v_view_name := 'MRP_AP_ERO_WIP_DEMAND_V';
450:
451: v_sql_stmt:=
452: 'insert into MSC_ST_DEMANDS'
453: ||' ( INVENTORY_ITEM_ID,'

Line 512: || ' from MRP_AP_ERO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink ||' x'

508: ||' :v_item_type_id,'
509: ||' :v_item_type_good,'
510: ||' :v_refresh_id,'
511: ||' :v_instance_id'
512: || ' from MRP_AP_ERO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink ||' x'
513: || ' where x.organization_id '||MSC_UTIL.v_non_depot_org_str
514: || ' AND (x.RN1 > :v_lrn or x.RN2 > :v_lrn or x.RN3 >:v_lrn)'
515: ;
516:

Line 518: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN

514: || ' AND (x.RN1 > :v_lrn or x.RN2 > :v_lrn or x.RN3 >:v_lrn)'
515: ;
516:
517:
518: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
519: Execute Immediate v_sql_stmt using
520: MSC_CL_PULL.v_dgmt,
521: MSC_CL_PULL.v_dgmt,
522: v_item_type_id,

Line 520: MSC_CL_PULL.v_dgmt,

516:
517:
518: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
519: Execute Immediate v_sql_stmt using
520: MSC_CL_PULL.v_dgmt,
521: MSC_CL_PULL.v_dgmt,
522: v_item_type_id,
523: v_item_type_good,
524: MSC_CL_PULL.v_refresh_id,

Line 521: MSC_CL_PULL.v_dgmt,

517:
518: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
519: Execute Immediate v_sql_stmt using
520: MSC_CL_PULL.v_dgmt,
521: MSC_CL_PULL.v_dgmt,
522: v_item_type_id,
523: v_item_type_good,
524: MSC_CL_PULL.v_refresh_id,
525: MSC_CL_PULL.v_instance_id,

Line 524: MSC_CL_PULL.v_refresh_id,

520: MSC_CL_PULL.v_dgmt,
521: MSC_CL_PULL.v_dgmt,
522: v_item_type_id,
523: v_item_type_good,
524: MSC_CL_PULL.v_refresh_id,
525: MSC_CL_PULL.v_instance_id,
526: MSC_CL_PULL.v_lrnn,
527: MSC_CL_PULL.v_lrnn,
528: MSC_CL_PULL.v_lrnn;

Line 525: MSC_CL_PULL.v_instance_id,

521: MSC_CL_PULL.v_dgmt,
522: v_item_type_id,
523: v_item_type_good,
524: MSC_CL_PULL.v_refresh_id,
525: MSC_CL_PULL.v_instance_id,
526: MSC_CL_PULL.v_lrnn,
527: MSC_CL_PULL.v_lrnn,
528: MSC_CL_PULL.v_lrnn;
529:

Line 526: MSC_CL_PULL.v_lrnn,

522: v_item_type_id,
523: v_item_type_good,
524: MSC_CL_PULL.v_refresh_id,
525: MSC_CL_PULL.v_instance_id,
526: MSC_CL_PULL.v_lrnn,
527: MSC_CL_PULL.v_lrnn,
528: MSC_CL_PULL.v_lrnn;
529:
530: END IF;

Line 527: MSC_CL_PULL.v_lrnn,

523: v_item_type_good,
524: MSC_CL_PULL.v_refresh_id,
525: MSC_CL_PULL.v_instance_id,
526: MSC_CL_PULL.v_lrnn,
527: MSC_CL_PULL.v_lrnn,
528: MSC_CL_PULL.v_lrnn;
529:
530: END IF;
531:

Line 528: MSC_CL_PULL.v_lrnn;

524: MSC_CL_PULL.v_refresh_id,
525: MSC_CL_PULL.v_instance_id,
526: MSC_CL_PULL.v_lrnn,
527: MSC_CL_PULL.v_lrnn,
528: MSC_CL_PULL.v_lrnn;
529:
530: END IF;
531:
532: