APPS.MSC_CL_WIP_PULL dependencies on MSC_CL_PULL

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

24: PROCEDURE LOAD_OPER_NETWORKS IS
25: v_get_apps_ver number;
26: BEGIN
27:
28: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
29:
30: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
31:
32:

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

26: BEGIN
27:
28: IF MSC_CL_PULL.BOM_ENABLED= MSC_UTIL.SYS_YES THEN
29:
30: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
31:
32:
33: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPER_NETWORKS';
34: MSC_CL_PULL.v_view_name := 'MRP_AD_OPER_NETWORKS_V';

Line 33: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPER_NETWORKS';

29:
30: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
31:
32:
33: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPER_NETWORKS';
34: MSC_CL_PULL.v_view_name := 'MRP_AD_OPER_NETWORKS_V';
35:
36: if v_once_per_org <> 'DONE'
37: then

Line 34: MSC_CL_PULL.v_view_name := 'MRP_AD_OPER_NETWORKS_V';

30: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
31:
32:
33: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPER_NETWORKS';
34: MSC_CL_PULL.v_view_name := 'MRP_AD_OPER_NETWORKS_V';
35:
36: if v_once_per_org <> 'DONE'
37: then
38:

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

36: if v_once_per_org <> 'DONE'
37: then
38:
39:
40: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
41:
42: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
43: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
44: ELSE

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

38:
39:
40: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
41:
42: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
43: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
44: ELSE
45: v_temp_sql := NULL;
46: END IF;

Line 61: ||' FROM MRP_AD_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'

57: ||' x.TO_OP_SEQ_ID, '
58: ||' 1,'
59: ||' :v_refresh_id,'
60: ||' :v_instance_id'
61: ||' FROM MRP_AD_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
62: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
63: || v_temp_sql;
64:
65: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

58: ||' 1,'
59: ||' :v_refresh_id,'
60: ||' :v_instance_id'
61: ||' FROM MRP_AD_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
62: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
63: || v_temp_sql;
64:
65: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
66:

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

61: ||' FROM MRP_AD_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
62: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
63: || v_temp_sql;
64:
65: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
66:
67: COMMIT;
68:
69: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */

Line 69: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */

65: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
66:
67: COMMIT;
68:
69: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */
70:
71: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_NETWORKS';
72: MSC_CL_PULL.v_view_name := 'MRP_AP_OPER_NETWORKS_V';
73:

Line 71: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_NETWORKS';

67: COMMIT;
68:
69: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */
70:
71: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_NETWORKS';
72: MSC_CL_PULL.v_view_name := 'MRP_AP_OPER_NETWORKS_V';
73:
74: v_sql_stmt:= ' insert into MSC_ST_OPERATION_NETWORKS'
75: ||'( FROM_OP_SEQ_ID, '

Line 72: MSC_CL_PULL.v_view_name := 'MRP_AP_OPER_NETWORKS_V';

68:
69: END IF; /* MSC_CL_PULL.v_lrnn<> -1 */
70:
71: MSC_CL_PULL.v_table_name:= 'MSC_ST_OPERATION_NETWORKS';
72: MSC_CL_PULL.v_view_name := 'MRP_AP_OPER_NETWORKS_V';
73:
74: v_sql_stmt:= ' insert into MSC_ST_OPERATION_NETWORKS'
75: ||'( FROM_OP_SEQ_ID, '
76: ||'TO_OP_SEQ_ID, '

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

146: ||' x.FROM_SEQ_NUM,'
147: ||' x.TO_SEQ_NUM, '
148: ||' :v_refresh_id,'
149: ||' :v_instance_id '
150: ||' from MRP_AP_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
151: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
152: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn

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

148: ||' :v_refresh_id,'
149: ||' :v_instance_id '
150: ||' from MRP_AP_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
151: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
152: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
155: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
156: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn

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

149: ||' :v_instance_id '
150: ||' from MRP_AP_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
151: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
152: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
155: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
156: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
157: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')' ;

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

150: ||' from MRP_AP_OPER_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
151: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
152: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
155: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
156: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
157: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')' ;
158:

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

151: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
152: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
155: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
156: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
157: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')' ;
158:
159: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

152: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
155: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
156: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
157: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')' ;
158:
159: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
160:

Line 157: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')' ;

153: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn
155: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
156: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
157: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')' ;
158:
159: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
160:
161: v_once_per_org := 'DONE';

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

155: ||' OR x.RN4>'||MSC_CL_PULL.v_lrn
156: ||' OR x.RN5>'||MSC_CL_PULL.v_lrn
157: ||' OR x.RN6>'||MSC_CL_PULL.v_lrn||')' ;
158:
159: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
160:
161: v_once_per_org := 'DONE';
162: -- opm populates operation network in call to
163: -- extract_effectivities

Line 168: END IF; -- MSC_CL_PULL.BOM_ENABLED

164:
165: End if; /* v_once_per_org */
166:
167: End if; /* MSC_UTIL.G_APPS115 */
168: END IF; -- MSC_CL_PULL.BOM_ENABLED
169:
170: END LOAD_OPER_NETWORKS;
171:
172:

Line 186: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN

182: v_temp_sql_stmt2 varchar2(32767) := null;
183: v_temp_sql2 varchar2(32767) := null;
184: BEGIN
185:
186: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
187:
188: --=================== Net Change Mode: Delete ==================
189:
190: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';

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

187:
188: --=================== Net Change Mode: Delete ==================
189:
190: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
191: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
192:
193:
194: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
195: where instance_id = MSC_CL_PULL.v_instance_id ;

Line 195: where instance_id = MSC_CL_PULL.v_instance_id ;

191: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
192:
193:
194: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
195: where instance_id = MSC_CL_PULL.v_instance_id ;
196:
197: if lv_lbj_details = 1 Then
198: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';
199: else

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

202:
203: END IF;
204:
205:
206: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
207:
208: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
209:
210: -- For Demands from non depo orgs

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

204:
205:
206: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
207:
208: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
209:
210: -- For Demands from non depo orgs
211:
212: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';

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

208: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
209:
210: -- For Demands from non depo orgs
211:
212: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
213: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_ERO_WIP_COMP_DEM_V';
214:
215: v_sql_stmt:=
216: 'insert into MSC_ST_DEMANDS'

Line 213: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_ERO_WIP_COMP_DEM_V';

209:
210: -- For Demands from non depo orgs
211:
212: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
213: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_ERO_WIP_COMP_DEM_V';
214:
215: v_sql_stmt:=
216: 'insert into MSC_ST_DEMANDS'
217: ||' ( WIP_ENTITY_ID,'

Line 234: ||' from MRP_AD_NON_ERO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'

230: ||' x.ORIGINATION_TYPE,'
231: ||' 1,'
232: ||' :v_refresh_id,'
233: ||' :v_instance_id'
234: ||' from MRP_AD_NON_ERO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'
235: ||' where ( DECODE( :v_mps_consume_profile_value,'
236: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
237: ||' x.WJS_NET_QTY_FLAG)=1'
238: ||' OR x.MRP_NET_FLAG= 1'

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

243: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str ;
244:
245: -- For Demands from depot repair orgs
246:
247: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
248: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_RO_WIP_COMP_DEM_V';
249:
250: v_temp_sql:=
251: 'insert into MSC_ST_DEMANDS'

Line 248: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_RO_WIP_COMP_DEM_V';

244:
245: -- For Demands from depot repair orgs
246:
247: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
248: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_RO_WIP_COMP_DEM_V';
249:
250: v_temp_sql:=
251: 'insert into MSC_ST_DEMANDS'
252: ||' ( WIP_ENTITY_ID,'

Line 269: ||' from MRP_AD_NON_RO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'

265: ||' x.ORIGINATION_TYPE,'
266: ||' 1,'
267: ||' :v_refresh_id,'
268: ||' :v_instance_id'
269: ||' from MRP_AD_NON_RO_WIP_COMP_DEM_V'||MSC_CL_PULL.v_dblink||' x'
270: ||' where ( DECODE( :v_mps_consume_profile_value,'
271: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
272: ||' x.WJS_NET_QTY_FLAG)=1'
273: ||' OR x.MRP_NET_FLAG= 1'

Line 280: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

276: ||' x.NMPS_FLAG)= 1 )'
277: ||' AND x.RN> :v_lrn '
278: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str ;
279:
280: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
281: MSC_CL_PULL.v_instance_id,
282: MSC_CL_PULL.v_mps_consume_profile_value,
283: MSC_CL_PULL.v_mps_consume_profile_value,
284: MSC_CL_PULL.v_lrn;

Line 281: MSC_CL_PULL.v_instance_id,

277: ||' AND x.RN> :v_lrn '
278: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str ;
279:
280: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
281: MSC_CL_PULL.v_instance_id,
282: MSC_CL_PULL.v_mps_consume_profile_value,
283: MSC_CL_PULL.v_mps_consume_profile_value,
284: MSC_CL_PULL.v_lrn;
285:

Line 282: MSC_CL_PULL.v_mps_consume_profile_value,

278: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str ;
279:
280: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
281: MSC_CL_PULL.v_instance_id,
282: MSC_CL_PULL.v_mps_consume_profile_value,
283: MSC_CL_PULL.v_mps_consume_profile_value,
284: MSC_CL_PULL.v_lrn;
285:
286: EXECUTE IMMEDIATE v_temp_sql USING MSC_CL_PULL.v_refresh_id,

Line 283: MSC_CL_PULL.v_mps_consume_profile_value,

279:
280: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
281: MSC_CL_PULL.v_instance_id,
282: MSC_CL_PULL.v_mps_consume_profile_value,
283: MSC_CL_PULL.v_mps_consume_profile_value,
284: MSC_CL_PULL.v_lrn;
285:
286: EXECUTE IMMEDIATE v_temp_sql USING MSC_CL_PULL.v_refresh_id,
287: MSC_CL_PULL.v_instance_id,

Line 284: MSC_CL_PULL.v_lrn;

280: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
281: MSC_CL_PULL.v_instance_id,
282: MSC_CL_PULL.v_mps_consume_profile_value,
283: MSC_CL_PULL.v_mps_consume_profile_value,
284: MSC_CL_PULL.v_lrn;
285:
286: EXECUTE IMMEDIATE v_temp_sql USING MSC_CL_PULL.v_refresh_id,
287: MSC_CL_PULL.v_instance_id,
288: MSC_CL_PULL.v_mps_consume_profile_value,

Line 286: EXECUTE IMMEDIATE v_temp_sql USING MSC_CL_PULL.v_refresh_id,

282: MSC_CL_PULL.v_mps_consume_profile_value,
283: MSC_CL_PULL.v_mps_consume_profile_value,
284: MSC_CL_PULL.v_lrn;
285:
286: EXECUTE IMMEDIATE v_temp_sql USING MSC_CL_PULL.v_refresh_id,
287: MSC_CL_PULL.v_instance_id,
288: MSC_CL_PULL.v_mps_consume_profile_value,
289: MSC_CL_PULL.v_mps_consume_profile_value,
290: MSC_CL_PULL.v_lrn;

Line 287: MSC_CL_PULL.v_instance_id,

283: MSC_CL_PULL.v_mps_consume_profile_value,
284: MSC_CL_PULL.v_lrn;
285:
286: EXECUTE IMMEDIATE v_temp_sql USING MSC_CL_PULL.v_refresh_id,
287: MSC_CL_PULL.v_instance_id,
288: MSC_CL_PULL.v_mps_consume_profile_value,
289: MSC_CL_PULL.v_mps_consume_profile_value,
290: MSC_CL_PULL.v_lrn;
291:

Line 288: MSC_CL_PULL.v_mps_consume_profile_value,

284: MSC_CL_PULL.v_lrn;
285:
286: EXECUTE IMMEDIATE v_temp_sql USING MSC_CL_PULL.v_refresh_id,
287: MSC_CL_PULL.v_instance_id,
288: MSC_CL_PULL.v_mps_consume_profile_value,
289: MSC_CL_PULL.v_mps_consume_profile_value,
290: MSC_CL_PULL.v_lrn;
291:
292: COMMIT;

Line 289: MSC_CL_PULL.v_mps_consume_profile_value,

285:
286: EXECUTE IMMEDIATE v_temp_sql USING MSC_CL_PULL.v_refresh_id,
287: MSC_CL_PULL.v_instance_id,
288: MSC_CL_PULL.v_mps_consume_profile_value,
289: MSC_CL_PULL.v_mps_consume_profile_value,
290: MSC_CL_PULL.v_lrn;
291:
292: COMMIT;
293:

Line 290: MSC_CL_PULL.v_lrn;

286: EXECUTE IMMEDIATE v_temp_sql USING MSC_CL_PULL.v_refresh_id,
287: MSC_CL_PULL.v_instance_id,
288: MSC_CL_PULL.v_mps_consume_profile_value,
289: MSC_CL_PULL.v_mps_consume_profile_value,
290: MSC_CL_PULL.v_lrn;
291:
292: COMMIT;
293:
294: ELSE -- If srp profile is No

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

292: COMMIT;
293:
294: ELSE -- If srp profile is No
295:
296: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
297: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_DEMANDS_V';
298:
299: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
300: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 297: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_DEMANDS_V';

293:
294: ELSE -- If srp profile is No
295:
296: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
297: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_DEMANDS_V';
298:
299: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
300: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
301: ELSE

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

295:
296: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
297: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_DEMANDS_V';
298:
299: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
300: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
301: ELSE
302: v_temp_sql := NULL;
303: END IF;

Line 324: ||' from MRP_AD_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

320: ||' x.ORIGINATION_TYPE,'
321: ||' 1,'
322: ||' :v_refresh_id,'
323: ||' :v_instance_id'
324: ||' from MRP_AD_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
325: ||' where ( DECODE( :v_mps_consume_profile_value,'
326: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
327: ||' x.WJS_NET_QTY_FLAG)=1'
328: ||' OR x.MRP_NET_FLAG= 1'

Line 335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

331: ||' x.NMPS_FLAG)= 1 )'
332: ||' AND x.RN> :v_lrn '
333: || v_temp_sql;
334:
335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_mps_consume_profile_value,
338: MSC_CL_PULL.v_mps_consume_profile_value,
339: MSC_CL_PULL.v_lrn;

Line 336: MSC_CL_PULL.v_instance_id,

332: ||' AND x.RN> :v_lrn '
333: || v_temp_sql;
334:
335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_mps_consume_profile_value,
338: MSC_CL_PULL.v_mps_consume_profile_value,
339: MSC_CL_PULL.v_lrn;
340:

Line 337: MSC_CL_PULL.v_mps_consume_profile_value,

333: || v_temp_sql;
334:
335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_mps_consume_profile_value,
338: MSC_CL_PULL.v_mps_consume_profile_value,
339: MSC_CL_PULL.v_lrn;
340:
341: COMMIT;

Line 338: MSC_CL_PULL.v_mps_consume_profile_value,

334:
335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_mps_consume_profile_value,
338: MSC_CL_PULL.v_mps_consume_profile_value,
339: MSC_CL_PULL.v_lrn;
340:
341: COMMIT;
342: END IF;

Line 339: MSC_CL_PULL.v_lrn;

335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
336: MSC_CL_PULL.v_instance_id,
337: MSC_CL_PULL.v_mps_consume_profile_value,
338: MSC_CL_PULL.v_mps_consume_profile_value,
339: MSC_CL_PULL.v_lrn;
340:
341: COMMIT;
342: END IF;
343: END IF;

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

342: END IF;
343: END IF;
344:
345:
346: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
347:
348: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
349: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_FLOW_DEMANDS_V';
350:

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

344:
345:
346: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
347:
348: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
349: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_FLOW_DEMANDS_V';
350:
351: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
352: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 349: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_FLOW_DEMANDS_V';

345:
346: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
347:
348: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
349: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_FLOW_DEMANDS_V';
350:
351: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
352: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
353: ELSE

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

347:
348: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
349: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_FLOW_DEMANDS_V';
350:
351: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
352: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
353: ELSE
354: v_temp_sql := NULL;
355: END IF;

Line 372: ||' from MRP_AD_WIP_FLOW_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

368: ||' x.ORGANIZATION_ID,'
369: ||' 1,'
370: ||' :v_refresh_id,'
371: ||' :v_instance_id'
372: ||' from MRP_AD_WIP_FLOW_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
373: ||' where x.RN> :v_lrn '
374: || v_temp_sql;
375:
376: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 376: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

372: ||' from MRP_AD_WIP_FLOW_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
373: ||' where x.RN> :v_lrn '
374: || v_temp_sql;
375:
376: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
377: MSC_CL_PULL.v_instance_id,
378: MSC_CL_PULL.v_lrn;
379:
380: COMMIT;

Line 377: MSC_CL_PULL.v_instance_id,

373: ||' where x.RN> :v_lrn '
374: || v_temp_sql;
375:
376: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
377: MSC_CL_PULL.v_instance_id,
378: MSC_CL_PULL.v_lrn;
379:
380: COMMIT;
381:

Line 378: MSC_CL_PULL.v_lrn;

374: || v_temp_sql;
375:
376: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
377: MSC_CL_PULL.v_instance_id,
378: MSC_CL_PULL.v_lrn;
379:
380: COMMIT;
381:
382: END IF;

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

380: COMMIT;
381:
382: END IF;
383:
384: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
385: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
386:
387: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
388: v_temp_sql := 'x.quantity_per_assembly,x.asset_item_id,x.asset_serial_number,x.basis_type,x.component_yield_factor, '; /* ds change */

Line 385: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';

381:
382: END IF;
383:
384: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
385: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
386:
387: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
388: v_temp_sql := 'x.quantity_per_assembly,x.asset_item_id,x.asset_serial_number,x.basis_type,x.component_yield_factor, '; /* ds change */
389:

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

383:
384: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
385: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
386:
387: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
388: v_temp_sql := 'x.quantity_per_assembly,x.asset_item_id,x.asset_serial_number,x.basis_type,x.component_yield_factor, '; /* ds change */
389:
390: ELSE
391:

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

391:
392: v_temp_sql := ' NULL, NULL, NULL, NULL, NULL, '; /* ds change */
393: END IF;
394:
395: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
396:
397: -- BUG 3036681
398: -- No need to check on RN3 (on wip_discrete_jobs) as the
399: -- materialized view on wip_requirement_operations now has

Line 431: ||' from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

427: ||' x.MPS_DATE_REQUIRED- :v_dgmt,'
428: ||' 2,'
429: ||' :v_refresh_id,'
430: ||' :v_instance_id'
431: ||' from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
432: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
433: ||' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'
434: */
435: ||' UNION '

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

429: ||' :v_refresh_id,'
430: ||' :v_instance_id'
431: ||' from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
432: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
433: ||' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')'
434: */
435: ||' UNION '
436: ||' select'
437: ||' x.INVENTORY_ITEM_ID,'

Line 463: ||' from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

459: ||' 2,'
460: || v_temp_sql
461: ||' :v_refresh_id,'
462: ||' :v_instance_id'
463: ||' from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
464: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
465: ||' AND x.NEW_REQUIRED_QUANTITY > 0'
466: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
467: --||' 2 ,x.coll_completed_qty_ind,'

Line 501: ||' from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

497: ||' 2,'
498: || v_temp_sql
499: ||' :v_refresh_id,'
500: ||' :v_instance_id'
501: ||' from MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
502: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
503: ||' AND x.NEW_REQUIRED_QUANTITY > 0'
504: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'
505: --||' 2 ,x.coll_completed_qty_ind,'

Line 588: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */

584: ||' AND x.NEW_REQUIRED_QUANTITY > 0'
585: || v_union_sql ;
586:
587:
588: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */
589:
590: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
591: lv_new_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
592: lv_new_org_string := MSC_UTIL.v_in_org_str;

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

586:
587:
588: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */
589:
590: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
591: lv_new_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
592: lv_new_org_string := MSC_UTIL.v_in_org_str;
593:
594: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

Line 594: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

590: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
591: lv_new_view_name := 'MRP_AP_WIP_COMP_DEMANDS_V';
592: lv_new_org_string := MSC_UTIL.v_in_org_str;
593:
594: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_COMP_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
595: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
596: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'
597:
598:

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

595: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
596: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'
597:
598:
599: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
600: lv_new_view_name := 'MRP_AP_NON_ERO_WIP_DEMAND_V';
601: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;
602:
603: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_ERO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'

Line 603: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_ERO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'

599: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
600: lv_new_view_name := 'MRP_AP_NON_ERO_WIP_DEMAND_V';
601: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;
602:
603: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_ERO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
604: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
605: ---- Code for SRP when Repair Orders Entity is/not selected . Building v_sql_stmt
606: end if;
607: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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

603: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_ERO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
604: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
605: ---- Code for SRP when Repair Orders Entity is/not selected . Building v_sql_stmt
606: end if;
607: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
608:
609:
610: EXECUTE IMMEDIATE v_temp_sql_stmt
611: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,

Line 611: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,

607: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
608:
609:
610: EXECUTE IMMEDIATE v_temp_sql_stmt
611: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
612: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
613: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn;
614:
615: /* NCP:

Line 612: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,

608:
609:
610: EXECUTE IMMEDIATE v_temp_sql_stmt
611: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
612: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
613: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn;
614:
615: /* NCP:
616: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 613: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn;

609:
610: EXECUTE IMMEDIATE v_temp_sql_stmt
611: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
612: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
613: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn;
614:
615: /* NCP:
616: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
617: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

612: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
613: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn;
614:
615: /* NCP:
616: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
617: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
618: */
619:
620: ELSE

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

613: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn;
614:
615: /* NCP:
616: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
617: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
618: */
619:
620: ELSE
621:

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

618: */
619:
620: ELSE
621:
622: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then
623: Begin
624:
625: EXECUTE IMMEDIATE v_temp_sql_stmt
626: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;

Line 626: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;

622: if (MSC_UTIL.G_COLLECT_SRP_DATA='Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) Then
623: Begin
624:
625: EXECUTE IMMEDIATE v_temp_sql_stmt
626: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
627:
628:
629: v_temp_sql_stmt := NULL;
630: MSC_CL_PULL.v_table_name := 'MSC_ST_DEMANDS';

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

626: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
627:
628:
629: v_temp_sql_stmt := NULL;
630: MSC_CL_PULL.v_table_name := 'MSC_ST_DEMANDS';
631: lv_new_view_name := 'MRP_AP_NON_RO_WIP_DEMAND_V';
632: lv_new_org_string := MSC_UTIL.v_depot_org_str;
633:
634: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_RO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'

Line 634: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_RO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'

630: MSC_CL_PULL.v_table_name := 'MSC_ST_DEMANDS';
631: lv_new_view_name := 'MRP_AP_NON_RO_WIP_DEMAND_V';
632: lv_new_org_string := MSC_UTIL.v_depot_org_str;
633:
634: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_RO_WIP_DEMAND_V'||MSC_CL_PULL.v_dblink||' x'
635: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
636:
637:
638: EXECUTE IMMEDIATE v_temp_sql_stmt

Line 639: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;

635: ||' WHERE x.ORGANIZATION_ID '||lv_new_org_string||v_temp_sql;
636:
637:
638: EXECUTE IMMEDIATE v_temp_sql_stmt
639: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
640:
641:
642: end; /* Code for SRP To get the work orders not attached to repair orders: bug 5909379 */
643: ELSE

Line 645: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;

641:
642: end; /* Code for SRP To get the work orders not attached to repair orders: bug 5909379 */
643: ELSE
644: EXECUTE IMMEDIATE v_temp_sql_stmt
645: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
646:
647: end if; -- For SRP and MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120
648: END IF;
649:

Line 647: end if; -- For SRP and MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120

643: ELSE
644: EXECUTE IMMEDIATE v_temp_sql_stmt
645: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
646:
647: end if; -- For SRP and MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120
648: END IF;
649:
650: COMMIT;
651:

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

652:
653: --=================== REPT ITEM DEMAND ==================
654: --=================== Net Change Mode: Delete ==================
655:
656: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
657:
658: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
659: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_DEMANDS_V';
660:

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

654: --=================== Net Change Mode: Delete ==================
655:
656: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
657:
658: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
659: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_DEMANDS_V';
660:
661: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
662: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

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

655:
656: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
657:
658: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
659: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_DEMANDS_V';
660:
661: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
662: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
663: ELSE

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

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

Line 688: ||' from MRP_AD_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

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

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

688: ||' from MRP_AD_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
689: ||' WHERE x.RN> :v_lrn '
690: || v_temp_sql;
691:
692: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
693:
694: COMMIT;
695:
696: END IF;

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

695:
696: END IF;
697:
698:
699: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
700: MSC_CL_PULL.v_view_name := 'MRP_AP_REPT_ITEM_DEMANDS_V';
701:
702: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
703:

Line 700: MSC_CL_PULL.v_view_name := 'MRP_AP_REPT_ITEM_DEMANDS_V';

696: END IF;
697:
698:
699: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
700: MSC_CL_PULL.v_view_name := 'MRP_AP_REPT_ITEM_DEMANDS_V';
701:
702: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
703:
704: v_union_sql :=

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

698:
699: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
700: MSC_CL_PULL.v_view_name := 'MRP_AP_REPT_ITEM_DEMANDS_V';
701:
702: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
703:
704: v_union_sql :=
705: ' AND ( x.RN1 > :v_lrn )'
706: ||' UNION '

Line 726: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

722: ||' x.WIP_SUPPLY_TYPE,'
723: ||' 2,'
724: ||' :v_refresh_id,'
725: ||' :v_instance_id'
726: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
727: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
728: ||' AND ( x.RN2 > :v_lrn )'
729: ||' UNION '
730: ||' select'

Line 749: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

745: ||' x.WIP_SUPPLY_TYPE,'
746: ||' 2,'
747: ||' :v_refresh_id,'
748: ||' :v_instance_id'
749: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
750: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
751: ||' AND ( x.RN3 > :v_lrn )'
752: ||' UNION '
753: ||' select'

Line 772: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

768: ||' x.WIP_SUPPLY_TYPE,'
769: ||' 2,'
770: ||' :v_refresh_id,'
771: ||' :v_instance_id'
772: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
773: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
774: ||' AND ( x.RN4 > :v_lrn )'
775: ||' UNION '
776: ||' select'

Line 795: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

791: ||' x.WIP_SUPPLY_TYPE,'
792: ||' 2,'
793: ||' :v_refresh_id,'
794: ||' :v_instance_id'
795: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
796: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
797: ||' AND ( x.RN5 > :v_lrn )';
798:
799: ELSE

Line 846: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'

842: ||' x.WIP_SUPPLY_TYPE,'
843: ||' 2,'
844: ||' :v_refresh_id,'
845: ||' :v_instance_id'
846: ||' from MRP_AP_REPT_ITEM_DEMANDS_V'||MSC_CL_PULL.v_dblink||' x'
847: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
848: || v_union_sql;
849:
850:

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

848: || v_union_sql;
849:
850:
851:
852: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
853:
854: EXECUTE IMMEDIATE v_sql_stmt
855: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
856: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

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

851:
852: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
853:
854: EXECUTE IMMEDIATE v_sql_stmt
855: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
856: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
857: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
858: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
859: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

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

852: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
853:
854: EXECUTE IMMEDIATE v_sql_stmt
855: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
856: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
857: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
858: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
859: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
860:

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

853:
854: EXECUTE IMMEDIATE v_sql_stmt
855: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
856: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
857: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
858: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
859: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
860:
861: ELSE

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

854: EXECUTE IMMEDIATE v_sql_stmt
855: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
856: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
857: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
858: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
859: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
860:
861: ELSE
862: EXECUTE IMMEDIATE v_sql_stmt

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

855: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
856: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
857: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
858: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
859: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
860:
861: ELSE
862: EXECUTE IMMEDIATE v_sql_stmt
863: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

Line 863: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

859: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
860:
861: ELSE
862: EXECUTE IMMEDIATE v_sql_stmt
863: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
864: END IF;
865:
866: COMMIT;
867:

Line 870: MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121) OR

866: COMMIT;
867:
868: --=================== CMRO Work Order DEMAND ==================
869: IF ((MSC_UTIL.g_collect_cmro_data = 'Y' and
870: MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121) OR
871: (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
872: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' )) THEN
873:
874:

Line 871: (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER

867:
868: --=================== CMRO Work Order DEMAND ==================
869: IF ((MSC_UTIL.g_collect_cmro_data = 'Y' and
870: MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121) OR
871: (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
872: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' )) THEN
873:
874:
875: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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

871: (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER
872: AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' )) THEN
873:
874:
875: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
876:
877: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
878: MSC_CL_PULL.v_view_name := 'MRP_AD_CMRO_WIP_COMP_DMD_V';
879:

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

873:
874:
875: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
876:
877: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
878: MSC_CL_PULL.v_view_name := 'MRP_AD_CMRO_WIP_COMP_DMD_V';
879:
880: -- Code AD View here -- PENDING --
881:

Line 878: MSC_CL_PULL.v_view_name := 'MRP_AD_CMRO_WIP_COMP_DMD_V';

874:
875: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
876:
877: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
878: MSC_CL_PULL.v_view_name := 'MRP_AD_CMRO_WIP_COMP_DMD_V';
879:
880: -- Code AD View here -- PENDING --
881:
882: END IF;

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

882: END IF;
883:
884:
885:
886: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
887: MSC_CL_PULL.v_view_name := 'MRP_AP_CMRO_WIP_COMP_DMD_V';
888:
889: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
890:

Line 887: MSC_CL_PULL.v_view_name := 'MRP_AP_CMRO_WIP_COMP_DMD_V';

883:
884:
885:
886: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
887: MSC_CL_PULL.v_view_name := 'MRP_AP_CMRO_WIP_COMP_DMD_V';
888:
889: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
890:
891: v_union_sql :=

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

885:
886: MSC_CL_PULL.v_table_name:= 'MSC_ST_DEMANDS';
887: MSC_CL_PULL.v_view_name := 'MRP_AP_CMRO_WIP_COMP_DMD_V';
888:
889: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
890:
891: v_union_sql :=
892: ' AND ( x.RN1> :v_lrn)'
893: ||' UNION '

Line 924: ||' from MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||' X'

920: ||' X.BASIS_TYPE,'
921: ||' X.COMPONENT_YIELD_FACTOR,'
922: ||' :v_refresh_id,'
923: ||' :v_instance_id'
924: ||' from MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||' X'
925: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
926: ||' AND DECODE(:v_collect_completed_jobs,'
927: ||' 2,x.status_code,'
928: ||' 1) <>4'

Line 962: ||' from MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||' X'

958: ||' X.BASIS_TYPE,'
959: ||' X.COMPONENT_YIELD_FACTOR,'
960: ||' :v_refresh_id,'
961: ||' :v_instance_id'
962: ||' from MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||' X'
963: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
964: ||' AND DECODE(:v_collect_completed_jobs,'
965: ||' 2,x.status_code,'
966: ||' 1) <>4'

Line 1034: ||' from MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||' X'

1030: ||' X.BASIS_TYPE,'
1031: ||' X.COMPONENT_YIELD_FACTOR,'
1032: ||' :v_refresh_id,'
1033: ||' :v_instance_id'
1034: ||' from MRP_AP_CMRO_WIP_COMP_DMD_V'||MSC_CL_PULL.v_dblink||' X'
1035: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1036: ;
1037:
1038:

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

1041: ||' 1) <>4'
1042: ||' AND x.NEW_REQUIRED_QUANTITY > 0';
1043:
1044:
1045: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1046:
1047:
1048: v_temp_sql_stmt := v_sql_stmt || v_temp_sql || v_union_sql;
1049:

Line 1051: USING MSC_CL_PULL.v_dgmt,

1047:
1048: v_temp_sql_stmt := v_sql_stmt || v_temp_sql || v_union_sql;
1049:
1050: EXECUTE IMMEDIATE v_temp_sql_stmt
1051: USING MSC_CL_PULL.v_dgmt,
1052: MSC_CL_PULL.v_dgmt,
1053: MSC_CL_PULL.v_refresh_id,
1054: MSC_CL_PULL.v_instance_id,
1055: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,

Line 1052: MSC_CL_PULL.v_dgmt,

1048: v_temp_sql_stmt := v_sql_stmt || v_temp_sql || v_union_sql;
1049:
1050: EXECUTE IMMEDIATE v_temp_sql_stmt
1051: USING MSC_CL_PULL.v_dgmt,
1052: MSC_CL_PULL.v_dgmt,
1053: MSC_CL_PULL.v_refresh_id,
1054: MSC_CL_PULL.v_instance_id,
1055: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1056: MSC_CL_PULL.v_lrn,

Line 1053: MSC_CL_PULL.v_refresh_id,

1049:
1050: EXECUTE IMMEDIATE v_temp_sql_stmt
1051: USING MSC_CL_PULL.v_dgmt,
1052: MSC_CL_PULL.v_dgmt,
1053: MSC_CL_PULL.v_refresh_id,
1054: MSC_CL_PULL.v_instance_id,
1055: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1056: MSC_CL_PULL.v_lrn,
1057: MSC_CL_PULL.v_dgmt,

Line 1054: MSC_CL_PULL.v_instance_id,

1050: EXECUTE IMMEDIATE v_temp_sql_stmt
1051: USING MSC_CL_PULL.v_dgmt,
1052: MSC_CL_PULL.v_dgmt,
1053: MSC_CL_PULL.v_refresh_id,
1054: MSC_CL_PULL.v_instance_id,
1055: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1056: MSC_CL_PULL.v_lrn,
1057: MSC_CL_PULL.v_dgmt,
1058: MSC_CL_PULL.v_dgmt,

Line 1055: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,

1051: USING MSC_CL_PULL.v_dgmt,
1052: MSC_CL_PULL.v_dgmt,
1053: MSC_CL_PULL.v_refresh_id,
1054: MSC_CL_PULL.v_instance_id,
1055: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1056: MSC_CL_PULL.v_lrn,
1057: MSC_CL_PULL.v_dgmt,
1058: MSC_CL_PULL.v_dgmt,
1059: MSC_CL_PULL.v_refresh_id,

Line 1056: MSC_CL_PULL.v_lrn,

1052: MSC_CL_PULL.v_dgmt,
1053: MSC_CL_PULL.v_refresh_id,
1054: MSC_CL_PULL.v_instance_id,
1055: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1056: MSC_CL_PULL.v_lrn,
1057: MSC_CL_PULL.v_dgmt,
1058: MSC_CL_PULL.v_dgmt,
1059: MSC_CL_PULL.v_refresh_id,
1060: MSC_CL_PULL.v_instance_id,

Line 1057: MSC_CL_PULL.v_dgmt,

1053: MSC_CL_PULL.v_refresh_id,
1054: MSC_CL_PULL.v_instance_id,
1055: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1056: MSC_CL_PULL.v_lrn,
1057: MSC_CL_PULL.v_dgmt,
1058: MSC_CL_PULL.v_dgmt,
1059: MSC_CL_PULL.v_refresh_id,
1060: MSC_CL_PULL.v_instance_id,
1061: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,

Line 1058: MSC_CL_PULL.v_dgmt,

1054: MSC_CL_PULL.v_instance_id,
1055: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1056: MSC_CL_PULL.v_lrn,
1057: MSC_CL_PULL.v_dgmt,
1058: MSC_CL_PULL.v_dgmt,
1059: MSC_CL_PULL.v_refresh_id,
1060: MSC_CL_PULL.v_instance_id,
1061: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1062: MSC_CL_PULL.v_lrn,

Line 1059: MSC_CL_PULL.v_refresh_id,

1055: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1056: MSC_CL_PULL.v_lrn,
1057: MSC_CL_PULL.v_dgmt,
1058: MSC_CL_PULL.v_dgmt,
1059: MSC_CL_PULL.v_refresh_id,
1060: MSC_CL_PULL.v_instance_id,
1061: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1062: MSC_CL_PULL.v_lrn,
1063: MSC_CL_PULL.v_dgmt,

Line 1060: MSC_CL_PULL.v_instance_id,

1056: MSC_CL_PULL.v_lrn,
1057: MSC_CL_PULL.v_dgmt,
1058: MSC_CL_PULL.v_dgmt,
1059: MSC_CL_PULL.v_refresh_id,
1060: MSC_CL_PULL.v_instance_id,
1061: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1062: MSC_CL_PULL.v_lrn,
1063: MSC_CL_PULL.v_dgmt,
1064: MSC_CL_PULL.v_dgmt,

Line 1061: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,

1057: MSC_CL_PULL.v_dgmt,
1058: MSC_CL_PULL.v_dgmt,
1059: MSC_CL_PULL.v_refresh_id,
1060: MSC_CL_PULL.v_instance_id,
1061: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1062: MSC_CL_PULL.v_lrn,
1063: MSC_CL_PULL.v_dgmt,
1064: MSC_CL_PULL.v_dgmt,
1065: MSC_CL_PULL.v_refresh_id,

Line 1062: MSC_CL_PULL.v_lrn,

1058: MSC_CL_PULL.v_dgmt,
1059: MSC_CL_PULL.v_refresh_id,
1060: MSC_CL_PULL.v_instance_id,
1061: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1062: MSC_CL_PULL.v_lrn,
1063: MSC_CL_PULL.v_dgmt,
1064: MSC_CL_PULL.v_dgmt,
1065: MSC_CL_PULL.v_refresh_id,
1066: MSC_CL_PULL.v_instance_id,

Line 1063: MSC_CL_PULL.v_dgmt,

1059: MSC_CL_PULL.v_refresh_id,
1060: MSC_CL_PULL.v_instance_id,
1061: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1062: MSC_CL_PULL.v_lrn,
1063: MSC_CL_PULL.v_dgmt,
1064: MSC_CL_PULL.v_dgmt,
1065: MSC_CL_PULL.v_refresh_id,
1066: MSC_CL_PULL.v_instance_id,
1067: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,

Line 1064: MSC_CL_PULL.v_dgmt,

1060: MSC_CL_PULL.v_instance_id,
1061: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1062: MSC_CL_PULL.v_lrn,
1063: MSC_CL_PULL.v_dgmt,
1064: MSC_CL_PULL.v_dgmt,
1065: MSC_CL_PULL.v_refresh_id,
1066: MSC_CL_PULL.v_instance_id,
1067: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1068: MSC_CL_PULL.v_lrn;

Line 1065: MSC_CL_PULL.v_refresh_id,

1061: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1062: MSC_CL_PULL.v_lrn,
1063: MSC_CL_PULL.v_dgmt,
1064: MSC_CL_PULL.v_dgmt,
1065: MSC_CL_PULL.v_refresh_id,
1066: MSC_CL_PULL.v_instance_id,
1067: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1068: MSC_CL_PULL.v_lrn;
1069:

Line 1066: MSC_CL_PULL.v_instance_id,

1062: MSC_CL_PULL.v_lrn,
1063: MSC_CL_PULL.v_dgmt,
1064: MSC_CL_PULL.v_dgmt,
1065: MSC_CL_PULL.v_refresh_id,
1066: MSC_CL_PULL.v_instance_id,
1067: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1068: MSC_CL_PULL.v_lrn;
1069:
1070:

Line 1067: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,

1063: MSC_CL_PULL.v_dgmt,
1064: MSC_CL_PULL.v_dgmt,
1065: MSC_CL_PULL.v_refresh_id,
1066: MSC_CL_PULL.v_instance_id,
1067: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1068: MSC_CL_PULL.v_lrn;
1069:
1070:
1071: ELSE

Line 1068: MSC_CL_PULL.v_lrn;

1064: MSC_CL_PULL.v_dgmt,
1065: MSC_CL_PULL.v_refresh_id,
1066: MSC_CL_PULL.v_instance_id,
1067: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS,
1068: MSC_CL_PULL.v_lrn;
1069:
1070:
1071: ELSE
1072:

Line 1076: USING MSC_CL_PULL.v_dgmt,

1072:
1073: v_temp_sql_stmt := v_sql_stmt || v_temp_sql;
1074:
1075: EXECUTE IMMEDIATE v_temp_sql_stmt
1076: USING MSC_CL_PULL.v_dgmt,
1077: MSC_CL_PULL.v_dgmt,
1078: MSC_CL_PULL.v_refresh_id,
1079: MSC_CL_PULL.v_instance_id,
1080: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;

Line 1077: MSC_CL_PULL.v_dgmt,

1073: v_temp_sql_stmt := v_sql_stmt || v_temp_sql;
1074:
1075: EXECUTE IMMEDIATE v_temp_sql_stmt
1076: USING MSC_CL_PULL.v_dgmt,
1077: MSC_CL_PULL.v_dgmt,
1078: MSC_CL_PULL.v_refresh_id,
1079: MSC_CL_PULL.v_instance_id,
1080: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
1081:

Line 1078: MSC_CL_PULL.v_refresh_id,

1074:
1075: EXECUTE IMMEDIATE v_temp_sql_stmt
1076: USING MSC_CL_PULL.v_dgmt,
1077: MSC_CL_PULL.v_dgmt,
1078: MSC_CL_PULL.v_refresh_id,
1079: MSC_CL_PULL.v_instance_id,
1080: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
1081:
1082:

Line 1079: MSC_CL_PULL.v_instance_id,

1075: EXECUTE IMMEDIATE v_temp_sql_stmt
1076: USING MSC_CL_PULL.v_dgmt,
1077: MSC_CL_PULL.v_dgmt,
1078: MSC_CL_PULL.v_refresh_id,
1079: MSC_CL_PULL.v_instance_id,
1080: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
1081:
1082:
1083: END IF;

Line 1080: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;

1076: USING MSC_CL_PULL.v_dgmt,
1077: MSC_CL_PULL.v_dgmt,
1078: MSC_CL_PULL.v_refresh_id,
1079: MSC_CL_PULL.v_instance_id,
1080: MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
1081:
1082:
1083: END IF;
1084:

Line 1090: END IF; -- MSC_CL_PULL.WIP_ENABLED

1086:
1087:
1088: END IF; -- CMRO Work Order Demand
1089:
1090: END IF; -- MSC_CL_PULL.WIP_ENABLED
1091:
1092: END LOAD_WIP_DEMAND;
1093:
1094:

Line 1111: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN

1107: v_temp_sql_stmt2 VARCHAR2(32767) :=null;
1108:
1109: BEGIN
1110:
1111: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
1112:
1113: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1114:
1115: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances

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

1109: BEGIN
1110:
1111: IF MSC_CL_PULL.WIP_ENABLED= MSC_UTIL.SYS_YES THEN
1112:
1113: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1114:
1115: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
1116: where instance_id = MSC_CL_PULL.v_instance_id ;
1117: END IF;

Line 1116: where instance_id = MSC_CL_PULL.v_instance_id ;

1112:
1113: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1114:
1115: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
1116: where instance_id = MSC_CL_PULL.v_instance_id ;
1117: END IF;
1118:
1119: IF MSC_CL_PULL.v_lrnn<> -1 THEN
1120: lv_qty_sql_temp := NULL;

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

1115: select LBJ_DETAILS into lv_lbj_details from msc_apps_instances
1116: where instance_id = MSC_CL_PULL.v_instance_id ;
1117: END IF;
1118:
1119: IF MSC_CL_PULL.v_lrnn<> -1 THEN
1120: lv_qty_sql_temp := NULL;
1121: ELSIF MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS = 1 THEN
1122: lv_qty_sql_temp := ' AND DECODE( x.wip_job_type, '
1123: ||' 1, DECODE( :v_mps_consume_profile_value, '

Line 1121: ELSIF MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS = 1 THEN

1117: END IF;
1118:
1119: IF MSC_CL_PULL.v_lrnn<> -1 THEN
1120: lv_qty_sql_temp := NULL;
1121: ELSIF MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS = 1 THEN
1122: lv_qty_sql_temp := ' AND DECODE( x.wip_job_type, '
1123: ||' 1, DECODE( :v_mps_consume_profile_value, '
1124: ||' 1, x.mps_net_quantity,'
1125: ||' x.net_quantity), '

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

1134: END IF;
1135:
1136: --=================== Net Change Mode: Delete ==================
1137:
1138: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1139:
1140: -- =================== JOB/FLOW SCHEDULE =====================
1141: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
1142: -- Changed for Bug 6081537

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

1137:
1138: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1139:
1140: -- =================== JOB/FLOW SCHEDULE =====================
1141: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
1142: -- Changed for Bug 6081537
1143: -- Supplies from Non Depot orgs
1144:
1145: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

1141: IF ((MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) AND (MSC_UTIL.G_COLLECT_SRP_DATA='Y')) THEN
1142: -- Changed for Bug 6081537
1143: -- Supplies from Non Depot orgs
1144:
1145: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1146: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_ERO_WIP_JOB_SUP_V';
1147:
1148: v_sql_stmt:=
1149: 'insert into MSC_ST_SUPPLIES'

Line 1146: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_ERO_WIP_JOB_SUP_V';

1142: -- Changed for Bug 6081537
1143: -- Supplies from Non Depot orgs
1144:
1145: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1146: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_ERO_WIP_JOB_SUP_V';
1147:
1148: v_sql_stmt:=
1149: 'insert into MSC_ST_SUPPLIES'
1150: ||' ( DISPOSITION_ID,'

Line 1161: ||' from MRP_AD_NON_ERO_WIP_JOB_SUP_V'||MSC_CL_PULL.v_dblink||' x'

1157: ||' x.ORDER_TYPE,'
1158: ||' 1,'
1159: ||' :v_refresh_id,'
1160: ||' :v_instance_id'
1161: ||' from MRP_AD_NON_ERO_WIP_JOB_SUP_V'||MSC_CL_PULL.v_dblink||' x'
1162: ||' where DECODE( x.wip_job_type,'
1163: ||' 1, DECODE( :v_mps_consume_profile_value,'
1164: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
1165: ||' x.WJS_NET_QTY_FLAG),'

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

1167: ||' AND x.RN> :v_lrn '
1168: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str;
1169:
1170: -- Supplies from Depot repair orgs
1171: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1172: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_RO_WIP_JOB_SUPP_V';
1173:
1174: v_temp_sql2:=
1175: 'insert into MSC_ST_SUPPLIES'

Line 1172: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_RO_WIP_JOB_SUPP_V';

1168: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_non_depot_org_str;
1169:
1170: -- Supplies from Depot repair orgs
1171: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1172: MSC_CL_PULL.v_view_name := 'MRP_AD_NON_RO_WIP_JOB_SUPP_V';
1173:
1174: v_temp_sql2:=
1175: 'insert into MSC_ST_SUPPLIES'
1176: ||' ( DISPOSITION_ID,'

Line 1187: ||' from MRP_AD_NON_ERO_WIP_JOB_SUP_V'||MSC_CL_PULL.v_dblink||' x'

1183: ||' x.ORDER_TYPE,'
1184: ||' 1,'
1185: ||' :v_refresh_id,'
1186: ||' :v_instance_id'
1187: ||' from MRP_AD_NON_ERO_WIP_JOB_SUP_V'||MSC_CL_PULL.v_dblink||' x'
1188: ||' where DECODE( x.wip_job_type,'
1189: ||' 1, DECODE( :v_mps_consume_profile_value,'
1190: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
1191: ||' x.WJS_NET_QTY_FLAG),'

Line 1197: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1193: ||' AND x.RN> :v_lrn '
1194: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str;
1195:
1196:
1197: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1198: MSC_CL_PULL.v_instance_id,
1199: MSC_CL_PULL.v_mps_consume_profile_value,
1200: MSC_CL_PULL.v_lrn;
1201:

Line 1198: MSC_CL_PULL.v_instance_id,

1194: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_depot_org_str;
1195:
1196:
1197: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1198: MSC_CL_PULL.v_instance_id,
1199: MSC_CL_PULL.v_mps_consume_profile_value,
1200: MSC_CL_PULL.v_lrn;
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);

Line 1199: MSC_CL_PULL.v_mps_consume_profile_value,

1195:
1196:
1197: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1198: MSC_CL_PULL.v_instance_id,
1199: MSC_CL_PULL.v_mps_consume_profile_value,
1200: MSC_CL_PULL.v_lrn;
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);
1203: COMMIT;

Line 1200: MSC_CL_PULL.v_lrn;

1196:
1197: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1198: MSC_CL_PULL.v_instance_id,
1199: MSC_CL_PULL.v_mps_consume_profile_value,
1200: MSC_CL_PULL.v_lrn;
1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);
1203: COMMIT;
1204:

Line 1205: EXECUTE IMMEDIATE v_temp_sql2 USING MSC_CL_PULL.v_refresh_id,

1201:
1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);
1203: COMMIT;
1204:
1205: EXECUTE IMMEDIATE v_temp_sql2 USING MSC_CL_PULL.v_refresh_id,
1206: MSC_CL_PULL.v_instance_id,
1207: MSC_CL_PULL.v_mps_consume_profile_value,
1208: MSC_CL_PULL.v_lrn;
1209:

Line 1206: MSC_CL_PULL.v_instance_id,

1202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);
1203: COMMIT;
1204:
1205: EXECUTE IMMEDIATE v_temp_sql2 USING MSC_CL_PULL.v_refresh_id,
1206: MSC_CL_PULL.v_instance_id,
1207: MSC_CL_PULL.v_mps_consume_profile_value,
1208: MSC_CL_PULL.v_lrn;
1209:
1210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);

Line 1207: MSC_CL_PULL.v_mps_consume_profile_value,

1203: COMMIT;
1204:
1205: EXECUTE IMMEDIATE v_temp_sql2 USING MSC_CL_PULL.v_refresh_id,
1206: MSC_CL_PULL.v_instance_id,
1207: MSC_CL_PULL.v_mps_consume_profile_value,
1208: MSC_CL_PULL.v_lrn;
1209:
1210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);
1211: COMMIT;

Line 1208: MSC_CL_PULL.v_lrn;

1204:
1205: EXECUTE IMMEDIATE v_temp_sql2 USING MSC_CL_PULL.v_refresh_id,
1206: MSC_CL_PULL.v_instance_id,
1207: MSC_CL_PULL.v_mps_consume_profile_value,
1208: MSC_CL_PULL.v_lrn;
1209:
1210: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_NON_ERO_WIP_JOB_SUP_V = '|| SQL%ROWCOUNT);
1211: COMMIT;
1212:

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

1211: COMMIT;
1212:
1213: ELSE -- (SRP Profile is No)
1214:
1215: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1216: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_JOB_SUPPLIES_V';
1217:
1218: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1219: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1216: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_JOB_SUPPLIES_V';

1212:
1213: ELSE -- (SRP Profile is No)
1214:
1215: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1216: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_JOB_SUPPLIES_V';
1217:
1218: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1219: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1220: ELSE

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

1214:
1215: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1216: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_JOB_SUPPLIES_V';
1217:
1218: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1219: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1220: ELSE
1221: v_temp_sql := NULL;
1222: END IF;

Line 1237: ||' from MRP_AD_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

1233: ||' x.ORDER_TYPE,'
1234: ||' 1,'
1235: ||' :v_refresh_id,'
1236: ||' :v_instance_id'
1237: ||' from MRP_AD_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1238: ||' where DECODE( x.wip_job_type,'
1239: ||' 1, DECODE( :v_mps_consume_profile_value,'
1240: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
1241: ||' x.WJS_NET_QTY_FLAG),'

Line 1246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1242: ||' x.WJS_NET_QTY_FLAG)=1'
1243: ||' AND x.RN> :v_lrn '
1244: || v_temp_sql;
1245:
1246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1247: MSC_CL_PULL.v_instance_id,
1248: MSC_CL_PULL.v_mps_consume_profile_value,
1249: MSC_CL_PULL.v_lrn;
1250:

Line 1247: MSC_CL_PULL.v_instance_id,

1243: ||' AND x.RN> :v_lrn '
1244: || v_temp_sql;
1245:
1246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1247: MSC_CL_PULL.v_instance_id,
1248: MSC_CL_PULL.v_mps_consume_profile_value,
1249: MSC_CL_PULL.v_lrn;
1250:
1251: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);

Line 1248: MSC_CL_PULL.v_mps_consume_profile_value,

1244: || v_temp_sql;
1245:
1246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1247: MSC_CL_PULL.v_instance_id,
1248: MSC_CL_PULL.v_mps_consume_profile_value,
1249: MSC_CL_PULL.v_lrn;
1250:
1251: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);
1252: COMMIT;

Line 1249: MSC_CL_PULL.v_lrn;

1245:
1246: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1247: MSC_CL_PULL.v_instance_id,
1248: MSC_CL_PULL.v_mps_consume_profile_value,
1249: MSC_CL_PULL.v_lrn;
1250:
1251: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of deleted rows for MRP_AD_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);
1252: COMMIT;
1253: END IF;

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

1252: COMMIT;
1253: END IF;
1254: -- =================== JOB COMPONENTS =====================
1255:
1256: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1257: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_SUPPLIES_V';
1258:
1259: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1260:

Line 1257: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_SUPPLIES_V';

1253: END IF;
1254: -- =================== JOB COMPONENTS =====================
1255:
1256: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1257: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_SUPPLIES_V';
1258:
1259: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1260:
1261: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

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

1257: MSC_CL_PULL.v_view_name := 'MRP_AD_WIP_COMP_SUPPLIES_V';
1258:
1259: lv_op_seq_num := 'x.OPERATION_SEQ_NUM, ';
1260:
1261: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1262: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1263:
1264: if lv_lbj_details = 1 Then
1265: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';

Line 1289: ||' from MRP_AD_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

1285: ||' x.ORDER_TYPE,'
1286: ||' 1,'
1287: ||' :v_refresh_id,'
1288: ||' :v_instance_id'
1289: ||' from MRP_AD_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1290: ||' where ( DECODE( :v_mps_consume_profile_value,'
1291: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
1292: ||' x.WJS_NET_QTY_FLAG)=1'
1293: ||' OR x.MRP_NET_FLAG= 1'

Line 1300: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1296: ||' x.NMPS_FLAG)= 1 )'
1297: ||' AND x.RN> :v_lrn '
1298: || v_temp_sql;
1299:
1300: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1301: MSC_CL_PULL.v_instance_id,
1302: MSC_CL_PULL.v_mps_consume_profile_value,
1303: MSC_CL_PULL.v_mps_consume_profile_value,
1304: MSC_CL_PULL.v_lrn;

Line 1301: MSC_CL_PULL.v_instance_id,

1297: ||' AND x.RN> :v_lrn '
1298: || v_temp_sql;
1299:
1300: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1301: MSC_CL_PULL.v_instance_id,
1302: MSC_CL_PULL.v_mps_consume_profile_value,
1303: MSC_CL_PULL.v_mps_consume_profile_value,
1304: MSC_CL_PULL.v_lrn;
1305:

Line 1302: MSC_CL_PULL.v_mps_consume_profile_value,

1298: || v_temp_sql;
1299:
1300: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1301: MSC_CL_PULL.v_instance_id,
1302: MSC_CL_PULL.v_mps_consume_profile_value,
1303: MSC_CL_PULL.v_mps_consume_profile_value,
1304: MSC_CL_PULL.v_lrn;
1305:
1306: COMMIT;

Line 1303: MSC_CL_PULL.v_mps_consume_profile_value,

1299:
1300: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1301: MSC_CL_PULL.v_instance_id,
1302: MSC_CL_PULL.v_mps_consume_profile_value,
1303: MSC_CL_PULL.v_mps_consume_profile_value,
1304: MSC_CL_PULL.v_lrn;
1305:
1306: COMMIT;
1307:

Line 1304: MSC_CL_PULL.v_lrn;

1300: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1301: MSC_CL_PULL.v_instance_id,
1302: MSC_CL_PULL.v_mps_consume_profile_value,
1303: MSC_CL_PULL.v_mps_consume_profile_value,
1304: MSC_CL_PULL.v_lrn;
1305:
1306: COMMIT;
1307:
1308: -- =================== REPT ITEM =====================

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

1306: COMMIT;
1307:
1308: -- =================== REPT ITEM =====================
1309:
1310: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1311: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_SUPPLIES_V';
1312:
1313: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1314: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 1311: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_SUPPLIES_V';

1307:
1308: -- =================== REPT ITEM =====================
1309:
1310: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1311: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_SUPPLIES_V';
1312:
1313: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1314: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1315: ELSE

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

1309:
1310: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1311: MSC_CL_PULL.v_view_name := 'MRP_AD_REPT_ITEM_SUPPLIES_V';
1312:
1313: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1314: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1315: ELSE
1316: v_temp_sql := NULL;
1317: END IF;

Line 1334: ||' from MRP_AD_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

1330: ||' x.ORGANIZATION_ID,'
1331: ||' 1,'
1332: ||' :v_refresh_id,'
1333: ||' :v_instance_id'
1334: ||' from MRP_AD_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1335: ||' WHERE x.RN> :v_lrn '
1336: || v_temp_sql;
1337:
1338: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

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

1334: ||' from MRP_AD_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1335: ||' WHERE x.RN> :v_lrn '
1336: || v_temp_sql;
1337:
1338: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1339:
1340: COMMIT;
1341:
1342: END IF;

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

1340: COMMIT;
1341:
1342: END IF;
1343:
1344: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1345: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1346:
1347:
1348: Begin

Line 1345: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';

1341:
1342: END IF;
1343:
1344: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1345: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1346:
1347:
1348: Begin
1349: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then

Line 1349: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then

1345: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1346:
1347:
1348: Begin
1349: if MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 Then
1350: if lv_lbj_details = 1 Then
1351: v_temp_sql := ' x.routing_reference_id,x.bom_reference_id,x.coproducts_supply,x.jd_operation_seq_num,'||
1352: 'x.JUMP_OP_SEQ_NUM,x.JOB_OP_SEQ_NUM, '||
1353: 'x.requested_start_date,x.requested_completion_date,x.schedule_priority,x.asset_item_id,x.asset_serial_number,' ||/* ds change */

Line 1362: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN

1358: 'x.ACTUAL_START_DATE,x.cfm_routing_flag, '; /* Discrete Mfg Enahancements Bug 4479276 */
1359: end if;
1360: else
1361: v_temp_sql := ' NULL, NULL, NULL, NULL, NULL, NULL, '||'NULL, NULL, NULL, ';
1362: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN
1363: v_temp_sql := v_temp_sql ||'x.asset_item_id,';
1364: ELSE
1365: v_temp_sql := v_temp_sql ||'NULL,';
1366: END IF;

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

1370:
1371: Begin
1372:
1373: --Bug#3419189
1374: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1375:
1376: v_temp_sql1 := ' x.wip_start_quantity,';
1377:
1378: ELSE

Line 1382: IF MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS121

1378: ELSE
1379: v_temp_sql1 := ' NULL,';
1380: END IF;
1381:
1382: IF MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS121
1383: THEN
1384: v_temp_sql5 := 'x.maintenance_object_source,x.description,x.asset_number,'||
1385: 'x.maintenance_object_id,x.maintenance_object_type,';
1386: ELSE

Line 1391: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN

1387: v_temp_sql5 := 'NULL,NULL,NULL,NULL,NULL,';
1388: END IF;
1389:
1390: /*USAF -- eam */
1391: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN
1392: v_temp_sql6 := 'NULL,x.CLASS_CODE,x.SHUTDOWN_TYPE,x.ACTIVITY_TYPE,'
1393: ||' decode(x.ORDER_TYPE,70, x.INVENTORY_ITEM_ID,NULL) ACTIVITY_ITEM_ID,';
1394: v_temp_sql7 := ' decode(x.ORDER_TYPE,70, x.asset_item_id, x.INVENTORY_ITEM_ID) INVENTORY_ITEM_ID, ';
1395: ELSE

Line 1400: /*Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS115,

1396: v_temp_sql6 := 'NULL,NULL,NULL,NULL,NULL,';
1397: v_temp_sql7 := ' x.INVENTORY_ITEM_ID,';
1398: END IF;
1399:
1400: /*Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS115,
1401: ' DECODE( x.wip_job_type, 1,
1402: DECODE( :v_mps_consume_profile_value,
1403: 1, x.mps_wip_start_quantity,
1404: x.wip_start_quantity),

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

1408: from dual;*/
1409: End;
1410:
1411:
1412: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1413:
1414: v_union_sql :=
1415: ' AND ( x.RN1 > :v_lrn )'
1416: ||' UNION '

Line 1462: ||' from MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

1458: || v_temp_sql5
1459: || v_temp_sql6
1460: ||' :v_refresh_id,'
1461: ||' :v_instance_id'
1462: ||' from MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1463: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1464: /*Bug#4704457 ||' AND DECODE( x.wip_job_type,'
1465: ||' 1, DECODE( :v_mps_consume_profile_value,'
1466: ||' 1, x.mps_net_quantity,'

Line 1474: ||' FROM MRP_SN_WOPRS'||MSC_CL_PULL.v_dblink||' y '

1470: ||' AND (( x.RN2 > :v_lrn ) OR '
1471: ||' (x.ENTITY_TYPE = 5 '
1472: ||' AND EXISTS '
1473: ||' (SELECT NULL '
1474: ||' FROM MRP_SN_WOPRS'||MSC_CL_PULL.v_dblink||' y '
1475: ||' WHERE '
1476: ||' x.WIP_ENTITY_ID = y.WIP_ENTITY_ID*2 '
1477: ||' AND x.ORGANIZATION_ID = y.ORGANIZATION_ID '
1478: ||' AND y.RN > :v_lrn )))';

Line 1591: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */

1587:
1588: v_temp_sql2:= v_sql_stmt; -- Added For Bug 5935273
1589: v_temp_sql := lv_qty_sql_temp|| v_union_sql;
1590:
1591: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */
1592:
1593: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1594: lv_new_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1595: lv_new_org_string := MSC_UTIL.v_in_org_str;

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

1589: v_temp_sql := lv_qty_sql_temp|| v_union_sql;
1590:
1591: if (MSC_UTIL.G_COLLECT_SRP_DATA='N' or MSC_CL_PULL.v_lrnn<> -1 or MSC_CL_PULL.v_apps_ver < MSC_UTIL.G_APPS120) Then /* Build v_sql_stmt based on the MSC_SRP_ENABLED profile Bug 5909379 */
1592:
1593: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1594: lv_new_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1595: lv_new_org_string := MSC_UTIL.v_in_org_str;
1596:
1597: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'||

Line 1597: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'||

1593: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1594: lv_new_view_name := 'MRP_AP_WIP_JOB_SUPPLIES_V';
1595: lv_new_org_string := MSC_UTIL.v_in_org_str;
1596:
1597: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_WIP_JOB_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'||
1598: ' where x.ORGANIZATION_ID '||lv_new_org_string||' '||v_temp_sql ;
1599: /* Changes For Bug 5909379 SRP Enhancements */
1600:
1601: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'

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

1600:
1601: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'
1602: -- Repair Order Entities are No
1603:
1604: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1605: MSC_CL_PULL.v_view_name:= 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';
1606:
1607: lv_new_view_name := 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';
1608: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;

Line 1605: MSC_CL_PULL.v_view_name:= 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';

1601: else -- Profile MSC_UTIL.G_COLLECT_SRP_DATA = 'Y'
1602: -- Repair Order Entities are No
1603:
1604: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1605: MSC_CL_PULL.v_view_name:= 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';
1606:
1607: lv_new_view_name := 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';
1608: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;
1609:

Line 1610: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_ERO_WIP_JOB_SUPP_V'||MSC_CL_PULL.v_dblink||' x'||

1606:
1607: lv_new_view_name := 'MRP_AP_NON_ERO_WIP_JOB_SUPP_V';
1608: lv_new_org_string := MSC_UTIL.v_non_depot_org_str;
1609:
1610: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_ERO_WIP_JOB_SUPP_V'||MSC_CL_PULL.v_dblink||' x'||
1611: ' where x.ORGANIZATION_ID '||lv_new_org_string||' '||v_temp_sql ;
1612: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);
1613:
1614: ---- Code for SRP when Repair Orders Entity is/not selected . Building v_sql_stmt

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

1616:
1617: end if; /* End Profile MSC_UTIL.G_COLLECT_SRP_DATA 5909379 */
1618:
1619:
1620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1621: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1622: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1623: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1624: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1622: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,

1618:
1619:
1620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1621: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1622: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1623: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1624: MSC_CL_PULL.v_mps_consume_profile_value,
1625: MSC_CL_PULL.v_dgmt,
1626: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 1623: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

1619:
1620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1621: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1622: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1623: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1624: MSC_CL_PULL.v_mps_consume_profile_value,
1625: MSC_CL_PULL.v_dgmt,
1626: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1627: --MSC_CL_PULL.v_mps_consume_profile_value,

Line 1624: MSC_CL_PULL.v_mps_consume_profile_value,

1620: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1621: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1622: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1623: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1624: MSC_CL_PULL.v_mps_consume_profile_value,
1625: MSC_CL_PULL.v_dgmt,
1626: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1627: --MSC_CL_PULL.v_mps_consume_profile_value,
1628: MSC_CL_PULL.v_lrn,

Line 1625: MSC_CL_PULL.v_dgmt,

1621: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply incr = '||v_sql_stmt);
1622: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1623: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1624: MSC_CL_PULL.v_mps_consume_profile_value,
1625: MSC_CL_PULL.v_dgmt,
1626: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1627: --MSC_CL_PULL.v_mps_consume_profile_value,
1628: MSC_CL_PULL.v_lrn,
1629: MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,

Line 1626: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

1622: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1623: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1624: MSC_CL_PULL.v_mps_consume_profile_value,
1625: MSC_CL_PULL.v_dgmt,
1626: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1627: --MSC_CL_PULL.v_mps_consume_profile_value,
1628: MSC_CL_PULL.v_lrn,
1629: MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1630: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

Line 1627: --MSC_CL_PULL.v_mps_consume_profile_value,

1623: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1624: MSC_CL_PULL.v_mps_consume_profile_value,
1625: MSC_CL_PULL.v_dgmt,
1626: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1627: --MSC_CL_PULL.v_mps_consume_profile_value,
1628: MSC_CL_PULL.v_lrn,
1629: MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1630: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1631: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1628: MSC_CL_PULL.v_lrn,

1624: MSC_CL_PULL.v_mps_consume_profile_value,
1625: MSC_CL_PULL.v_dgmt,
1626: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1627: --MSC_CL_PULL.v_mps_consume_profile_value,
1628: MSC_CL_PULL.v_lrn,
1629: MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1630: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1631: MSC_CL_PULL.v_mps_consume_profile_value,
1632: MSC_CL_PULL.v_dgmt,

Line 1629: MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,

1625: MSC_CL_PULL.v_dgmt,
1626: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1627: --MSC_CL_PULL.v_mps_consume_profile_value,
1628: MSC_CL_PULL.v_lrn,
1629: MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1630: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1631: MSC_CL_PULL.v_mps_consume_profile_value,
1632: MSC_CL_PULL.v_dgmt,
1633: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 1630: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

1626: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1627: --MSC_CL_PULL.v_mps_consume_profile_value,
1628: MSC_CL_PULL.v_lrn,
1629: MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1630: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1631: MSC_CL_PULL.v_mps_consume_profile_value,
1632: MSC_CL_PULL.v_dgmt,
1633: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1634: --MSC_CL_PULL.v_mps_consume_profile_value,

Line 1631: MSC_CL_PULL.v_mps_consume_profile_value,

1627: --MSC_CL_PULL.v_mps_consume_profile_value,
1628: MSC_CL_PULL.v_lrn,
1629: MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1630: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1631: MSC_CL_PULL.v_mps_consume_profile_value,
1632: MSC_CL_PULL.v_dgmt,
1633: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1634: --MSC_CL_PULL.v_mps_consume_profile_value,
1635: MSC_CL_PULL.v_lrn,

Line 1632: MSC_CL_PULL.v_dgmt,

1628: MSC_CL_PULL.v_lrn,
1629: MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1630: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1631: MSC_CL_PULL.v_mps_consume_profile_value,
1632: MSC_CL_PULL.v_dgmt,
1633: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1634: --MSC_CL_PULL.v_mps_consume_profile_value,
1635: MSC_CL_PULL.v_lrn,
1636: MSC_CL_PULL.v_lrn;

Line 1633: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

1629: MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1630: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1631: MSC_CL_PULL.v_mps_consume_profile_value,
1632: MSC_CL_PULL.v_dgmt,
1633: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1634: --MSC_CL_PULL.v_mps_consume_profile_value,
1635: MSC_CL_PULL.v_lrn,
1636: MSC_CL_PULL.v_lrn;
1637:

Line 1634: --MSC_CL_PULL.v_mps_consume_profile_value,

1630: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1631: MSC_CL_PULL.v_mps_consume_profile_value,
1632: MSC_CL_PULL.v_dgmt,
1633: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1634: --MSC_CL_PULL.v_mps_consume_profile_value,
1635: MSC_CL_PULL.v_lrn,
1636: MSC_CL_PULL.v_lrn;
1637:
1638: ELSE -- For COmplete Refresh

Line 1635: MSC_CL_PULL.v_lrn,

1631: MSC_CL_PULL.v_mps_consume_profile_value,
1632: MSC_CL_PULL.v_dgmt,
1633: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1634: --MSC_CL_PULL.v_mps_consume_profile_value,
1635: MSC_CL_PULL.v_lrn,
1636: MSC_CL_PULL.v_lrn;
1637:
1638: ELSE -- For COmplete Refresh
1639:

Line 1636: MSC_CL_PULL.v_lrn;

1632: MSC_CL_PULL.v_dgmt,
1633: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1634: --MSC_CL_PULL.v_mps_consume_profile_value,
1635: MSC_CL_PULL.v_lrn,
1636: MSC_CL_PULL.v_lrn;
1637:
1638: ELSE -- For COmplete Refresh
1639:
1640: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply complete = '||v_sql_stmt);

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

1639:
1640: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: wip supply complete = '||v_sql_stmt);
1641:
1642:
1643: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
1644:
1645:
1646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);
1647:

Line 1648: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,

1644:
1645:
1646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);
1647:
1648: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1649: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1650: MSC_CL_PULL.v_mps_consume_profile_value,
1651: MSC_CL_PULL.v_dgmt,
1652: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 1649: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

1645:
1646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);
1647:
1648: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1649: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1650: MSC_CL_PULL.v_mps_consume_profile_value,
1651: MSC_CL_PULL.v_dgmt,
1652: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1653: MSC_CL_PULL.v_mps_consume_profile_value;

Line 1650: MSC_CL_PULL.v_mps_consume_profile_value,

1646: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql-- '|| v_temp_sql_stmt);
1647:
1648: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1649: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1650: MSC_CL_PULL.v_mps_consume_profile_value,
1651: MSC_CL_PULL.v_dgmt,
1652: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1653: MSC_CL_PULL.v_mps_consume_profile_value;
1654:

Line 1651: MSC_CL_PULL.v_dgmt,

1647:
1648: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1649: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1650: MSC_CL_PULL.v_mps_consume_profile_value,
1651: MSC_CL_PULL.v_dgmt,
1652: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1653: MSC_CL_PULL.v_mps_consume_profile_value;
1654:
1655: v_temp_sql_stmt := NULL;

Line 1652: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

1648: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1649: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1650: MSC_CL_PULL.v_mps_consume_profile_value,
1651: MSC_CL_PULL.v_dgmt,
1652: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1653: MSC_CL_PULL.v_mps_consume_profile_value;
1654:
1655: v_temp_sql_stmt := NULL;
1656:

Line 1653: MSC_CL_PULL.v_mps_consume_profile_value;

1649: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1650: MSC_CL_PULL.v_mps_consume_profile_value,
1651: MSC_CL_PULL.v_dgmt,
1652: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1653: MSC_CL_PULL.v_mps_consume_profile_value;
1654:
1655: v_temp_sql_stmt := NULL;
1656:
1657: begin

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

1654:
1655: v_temp_sql_stmt := NULL;
1656:
1657: begin
1658: MSC_CL_PULL.v_table_name := 'MSC_ST_SUPPLIES';
1659: lv_new_view_name := 'MRP_AP_NON_RO_WIP_JOB_SUPPLY_V';
1660: lv_new_org_string := MSC_UTIL.v_depot_org_str;
1661:
1662: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_RO_WIP_JOB_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'||

Line 1662: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_RO_WIP_JOB_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'||

1658: MSC_CL_PULL.v_table_name := 'MSC_ST_SUPPLIES';
1659: lv_new_view_name := 'MRP_AP_NON_RO_WIP_JOB_SUPPLY_V';
1660: lv_new_org_string := MSC_UTIL.v_depot_org_str;
1661:
1662: v_temp_sql_stmt := v_sql_stmt||' MRP_AP_NON_RO_WIP_JOB_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'||
1663: ' where x.ORGANIZATION_ID '||lv_new_org_string ||' '||v_temp_sql;
1664:
1665:
1666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql2-- '|| v_temp_sql_stmt);

Line 1667: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,

1663: ' where x.ORGANIZATION_ID '||lv_new_org_string ||' '||v_temp_sql;
1664:
1665:
1666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql2-- '|| v_temp_sql_stmt);
1667: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1668: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1669: MSC_CL_PULL.v_mps_consume_profile_value,
1670: MSC_CL_PULL.v_dgmt,
1671: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 1668: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

1664:
1665:
1666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql2-- '|| v_temp_sql_stmt);
1667: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1668: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1669: MSC_CL_PULL.v_mps_consume_profile_value,
1670: MSC_CL_PULL.v_dgmt,
1671: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1672: MSC_CL_PULL.v_mps_consume_profile_value;

Line 1669: MSC_CL_PULL.v_mps_consume_profile_value,

1665:
1666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql2-- '|| v_temp_sql_stmt);
1667: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1668: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1669: MSC_CL_PULL.v_mps_consume_profile_value,
1670: MSC_CL_PULL.v_dgmt,
1671: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1672: MSC_CL_PULL.v_mps_consume_profile_value;
1673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_NON_RO_WIP_JOB_SUPPLY_V = '|| SQL%ROWCOUNT);

Line 1670: MSC_CL_PULL.v_dgmt,

1666: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'sql2-- '|| v_temp_sql_stmt);
1667: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1668: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1669: MSC_CL_PULL.v_mps_consume_profile_value,
1670: MSC_CL_PULL.v_dgmt,
1671: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1672: MSC_CL_PULL.v_mps_consume_profile_value;
1673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_NON_RO_WIP_JOB_SUPPLY_V = '|| SQL%ROWCOUNT);
1674:

Line 1671: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

1667: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1668: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1669: MSC_CL_PULL.v_mps_consume_profile_value,
1670: MSC_CL_PULL.v_dgmt,
1671: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1672: MSC_CL_PULL.v_mps_consume_profile_value;
1673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_NON_RO_WIP_JOB_SUPPLY_V = '|| SQL%ROWCOUNT);
1674:
1675:

Line 1672: MSC_CL_PULL.v_mps_consume_profile_value;

1668: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1669: MSC_CL_PULL.v_mps_consume_profile_value,
1670: MSC_CL_PULL.v_dgmt,
1671: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1672: MSC_CL_PULL.v_mps_consume_profile_value;
1673: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_NON_RO_WIP_JOB_SUPPLY_V = '|| SQL%ROWCOUNT);
1674:
1675:
1676: end ; ---- Code for SRP To get the work orders not attached to repair orders:

Line 1685: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,

1681:
1682: ELSE -- Instance is < 12i or MSC_SRP_ENABLED Profile is 'No'
1683:
1684:
1685: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1686: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1687: MSC_CL_PULL.v_mps_consume_profile_value,
1688: MSC_CL_PULL.v_dgmt,
1689: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 1686: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

1682: ELSE -- Instance is < 12i or MSC_SRP_ENABLED Profile is 'No'
1683:
1684:
1685: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1686: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1687: MSC_CL_PULL.v_mps_consume_profile_value,
1688: MSC_CL_PULL.v_dgmt,
1689: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1690: MSC_CL_PULL.v_mps_consume_profile_value;

Line 1687: MSC_CL_PULL.v_mps_consume_profile_value,

1683:
1684:
1685: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1686: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1687: MSC_CL_PULL.v_mps_consume_profile_value,
1688: MSC_CL_PULL.v_dgmt,
1689: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1690: MSC_CL_PULL.v_mps_consume_profile_value;
1691: END IF;

Line 1688: MSC_CL_PULL.v_dgmt,

1684:
1685: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1686: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1687: MSC_CL_PULL.v_mps_consume_profile_value,
1688: MSC_CL_PULL.v_dgmt,
1689: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1690: MSC_CL_PULL.v_mps_consume_profile_value;
1691: END IF;
1692: END IF;

Line 1689: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

1685: EXECUTE IMMEDIATE v_temp_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, lv_lbj_details, lv_lbj_details, lv_lbj_details,
1686: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1687: MSC_CL_PULL.v_mps_consume_profile_value,
1688: MSC_CL_PULL.v_dgmt,
1689: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1690: MSC_CL_PULL.v_mps_consume_profile_value;
1691: END IF;
1692: END IF;
1693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);

Line 1690: MSC_CL_PULL.v_mps_consume_profile_value;

1686: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1687: MSC_CL_PULL.v_mps_consume_profile_value,
1688: MSC_CL_PULL.v_dgmt,
1689: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1690: MSC_CL_PULL.v_mps_consume_profile_value;
1691: END IF;
1692: END IF;
1693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);
1694: COMMIT;

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

1692: END IF;
1693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);
1694: COMMIT;
1695:
1696: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1697: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_SUPPLIES_V';
1698:
1699: lv_op_seq_num := ' x.OPERATION_SEQ_NUM, ';
1700:

Line 1697: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_SUPPLIES_V';

1693: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_WIP_JOB_SUPPLIES_V = '|| SQL%ROWCOUNT);
1694: COMMIT;
1695:
1696: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1697: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_SUPPLIES_V';
1698:
1699: lv_op_seq_num := ' x.OPERATION_SEQ_NUM, ';
1700:
1701: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN

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

1697: MSC_CL_PULL.v_view_name := 'MRP_AP_WIP_COMP_SUPPLIES_V';
1698:
1699: lv_op_seq_num := ' x.OPERATION_SEQ_NUM, ';
1700:
1701: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1702: v_temp_sql := ' x.quantity_per_assembly,x.quantity_issued, x.ACTUAL_START_DATE, ';
1703:
1704: if lv_lbj_details = 1 Then
1705: lv_op_seq_num := ' x.COPY_OP_SEQ_NUM, ';

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

1711: v_temp_sql := ' NULL, NULL, NULL, ';
1712: END IF;
1713:
1714:
1715: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1716:
1717: v_union_sql :=
1718: ' AND ( x.RN1 > :v_lrn )'
1719: ||' UNION '

Line 1746: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

1742: || v_temp_sql
1743: ||' 2,'
1744: ||' :v_refresh_id,'
1745: ||' :v_instance_id'
1746: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1747: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1748: ||' AND x.BY_PROD_QUANTITY <> 0'
1749: || lv_cond_sql
1750: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'

Line 1784: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

1780: || v_temp_sql
1781: ||' 2,'
1782: ||' :v_refresh_id,'
1783: ||' :v_instance_id'
1784: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1785: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1786: ||' AND x.BY_PROD_QUANTITY <> 0'
1787: || lv_cond_sql
1788: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'

Line 1856: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

1852: || v_temp_sql
1853: ||' 2,'
1854: ||' :v_refresh_id,'
1855: ||' :v_instance_id'
1856: ||' from MRP_AP_WIP_COMP_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
1857: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1858: ||' AND x.BY_PROD_QUANTITY <> 0'
1859: || lv_cond_sql
1860: --||' AND DECODE(:V_COLLECT_COMPLETED_JOBS,'

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

1864: ||' 2,x.status_code,'
1865: ||' 1) <>4' -- 5730031
1866: || v_union_sql;
1867:
1868: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1869:
1870: EXECUTE IMMEDIATE v_sql_stmt
1871: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
1872: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,

Line 1871: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,

1867:
1868: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1869:
1870: EXECUTE IMMEDIATE v_sql_stmt
1871: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
1872: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
1873: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn;
1874:
1875: ELSE

Line 1872: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,

1868: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
1869:
1870: EXECUTE IMMEDIATE v_sql_stmt
1871: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
1872: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
1873: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn;
1874:
1875: ELSE
1876:

Line 1873: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn;

1869:
1870: EXECUTE IMMEDIATE v_sql_stmt
1871: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
1872: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn,
1873: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS, MSC_CL_PULL.v_lrn;
1874:
1875: ELSE
1876:
1877: EXECUTE IMMEDIATE v_sql_stmt

Line 1878: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;

1874:
1875: ELSE
1876:
1877: EXECUTE IMMEDIATE v_sql_stmt
1878: USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.V_COLLECT_COMPLETED_JOBS;
1879:
1880: END IF;
1881:
1882:

Line 1892: IF MSC_CL_PULL.v_lrn <> -1 then /*incremental refresh*/

1888: BEGIN
1889:
1890: --If lv_lbj_details = 1 Then
1891:
1892: IF MSC_CL_PULL.v_lrn <> -1 then /*incremental refresh*/
1893:
1894: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1895: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1896: ELSE

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

1890: --If lv_lbj_details = 1 Then
1891:
1892: IF MSC_CL_PULL.v_lrn <> -1 then /*incremental refresh*/
1893:
1894: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1895: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1896: ELSE
1897: v_temp_sql := NULL;
1898: END IF;

Line 1900: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';

1896: ELSE
1897: v_temp_sql := NULL;
1898: END IF;
1899:
1900: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1901: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OP_NETWORKS_V';
1902:
1903: v_sql_stmt:=
1904: 'insert into MSC_ST_JOB_OPERATION_NETWORKS'

Line 1901: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OP_NETWORKS_V';

1897: v_temp_sql := NULL;
1898: END IF;
1899:
1900: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1901: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OP_NETWORKS_V';
1902:
1903: v_sql_stmt:=
1904: 'insert into MSC_ST_JOB_OPERATION_NETWORKS'
1905: ||' ( WIP_ENTITY_ID,'

Line 1918: ||' from MRP_AD_JOB_OP_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'

1914: ||' x.TO_OP_SEQ_NUM,'
1915: ||' 1,'
1916: ||' :v_refresh_id,'
1917: ||' :v_instance_id'
1918: ||' from MRP_AD_JOB_OP_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
1919: ||' where x.RN> '||MSC_CL_PULL.v_lrn
1920: ||' AND DECODE( x.from_op_seq_num,'
1921: ||' NULL, DECODE( :v_mps_consume_profile_value,'
1922: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'

Line 1919: ||' where x.RN> '||MSC_CL_PULL.v_lrn

1915: ||' 1,'
1916: ||' :v_refresh_id,'
1917: ||' :v_instance_id'
1918: ||' from MRP_AD_JOB_OP_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
1919: ||' where x.RN> '||MSC_CL_PULL.v_lrn
1920: ||' AND DECODE( x.from_op_seq_num,'
1921: ||' NULL, DECODE( :v_mps_consume_profile_value,'
1922: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
1923: ||' x.WJS_NET_QTY_FLAG), '

Line 1927: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1923: ||' x.WJS_NET_QTY_FLAG), '
1924: ||' 1)= 1'
1925: || v_temp_sql;
1926:
1927: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1928: MSC_CL_PULL.v_instance_id,
1929: MSC_CL_PULL.v_mps_consume_profile_value;
1930:
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);

Line 1928: MSC_CL_PULL.v_instance_id,

1924: ||' 1)= 1'
1925: || v_temp_sql;
1926:
1927: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1928: MSC_CL_PULL.v_instance_id,
1929: MSC_CL_PULL.v_mps_consume_profile_value;
1930:
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
1932: COMMIT;

Line 1929: MSC_CL_PULL.v_mps_consume_profile_value;

1925: || v_temp_sql;
1926:
1927: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1928: MSC_CL_PULL.v_instance_id,
1929: MSC_CL_PULL.v_mps_consume_profile_value;
1930:
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
1932: COMMIT;
1933:

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

1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
1932: COMMIT;
1933:
1934:
1935: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)
1936: /* ds change start */
1937: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1938: MSC_CL_PULL.v_view_name := 'MRP_AD_WOPR_NETWORKS_V';
1939:

Line 1937: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';

1933:
1934:
1935: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)
1936: /* ds change start */
1937: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1938: MSC_CL_PULL.v_view_name := 'MRP_AD_WOPR_NETWORKS_V';
1939:
1940: v_sql_stmt:=
1941: 'insert into MSC_ST_JOB_OPERATION_NETWORKS'

Line 1938: MSC_CL_PULL.v_view_name := 'MRP_AD_WOPR_NETWORKS_V';

1934:
1935: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN --bug#5684183 (bcaru)
1936: /* ds change start */
1937: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1938: MSC_CL_PULL.v_view_name := 'MRP_AD_WOPR_NETWORKS_V';
1939:
1940: v_sql_stmt:=
1941: 'insert into MSC_ST_JOB_OPERATION_NETWORKS'
1942: ||' ( WIP_ENTITY_ID,'

Line 1955: ||' from MRP_AD_WOPR_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'

1951: ||' x.TO_OP_SEQ_NUM,'
1952: ||' 1,'
1953: ||' :v_refresh_id,'
1954: ||' :v_instance_id'
1955: ||' from MRP_AD_WOPR_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
1956: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1957:
1958: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1959: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 1956: ||' where x.RN> '||MSC_CL_PULL.v_lrn;

1952: ||' 1,'
1953: ||' :v_refresh_id,'
1954: ||' :v_instance_id'
1955: ||' from MRP_AD_WOPR_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
1956: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1957:
1958: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1959: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1960: MSC_CL_PULL.v_instance_id;

Line 1959: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1955: ||' from MRP_AD_WOPR_NETWORKS_V'||MSC_CL_PULL.v_dblink||' x'
1956: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1957:
1958: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1959: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1960: MSC_CL_PULL.v_instance_id;
1961:
1962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_WOPR_NETWORKS = '|| SQL%ROWCOUNT);
1963: COMMIT;

Line 1960: MSC_CL_PULL.v_instance_id;

1956: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1957:
1958: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1959: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1960: MSC_CL_PULL.v_instance_id;
1961:
1962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_WOPR_NETWORKS = '|| SQL%ROWCOUNT);
1963: COMMIT;
1964:

Line 1965: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';

1961:
1962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_WOPR_NETWORKS = '|| SQL%ROWCOUNT);
1963: COMMIT;
1964:
1965: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1966: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_WO_RELSHIPS_V';
1967:
1968: v_sql_stmt:=
1969: 'insert into MSC_ST_JOB_OPERATION_NETWORKS'

Line 1966: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_WO_RELSHIPS_V';

1962: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_WOPR_NETWORKS = '|| SQL%ROWCOUNT);
1963: COMMIT;
1964:
1965: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATION_NETWORKS';
1966: MSC_CL_PULL.v_view_name := 'MRP_AD_EAM_WO_RELSHIPS_V';
1967:
1968: v_sql_stmt:=
1969: 'insert into MSC_ST_JOB_OPERATION_NETWORKS'
1970: ||' ( WIP_ENTITY_ID,'

Line 1983: ||' from MRP_AD_EAM_WO_RELSHIPS_V'||MSC_CL_PULL.v_dblink||' x'

1979: --||' x.RELATIONSHIP_TYPE,'
1980: ||' 1,'
1981: ||' :v_refresh_id,'
1982: ||' :v_instance_id'
1983: ||' from MRP_AD_EAM_WO_RELSHIPS_V'||MSC_CL_PULL.v_dblink||' x'
1984: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1985:
1986: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1987: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

Line 1984: ||' where x.RN> '||MSC_CL_PULL.v_lrn;

1980: ||' 1,'
1981: ||' :v_refresh_id,'
1982: ||' :v_instance_id'
1983: ||' from MRP_AD_EAM_WO_RELSHIPS_V'||MSC_CL_PULL.v_dblink||' x'
1984: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1985:
1986: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1987: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1988: MSC_CL_PULL.v_instance_id;

Line 1987: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

1983: ||' from MRP_AD_EAM_WO_RELSHIPS_V'||MSC_CL_PULL.v_dblink||' x'
1984: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1985:
1986: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1987: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1988: MSC_CL_PULL.v_instance_id;
1989:
1990: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_EAM_WO_RELSHIPS_V = '|| SQL%ROWCOUNT);
1991: -- opm populate job operation network in call

Line 1988: MSC_CL_PULL.v_instance_id;

1984: ||' where x.RN> '||MSC_CL_PULL.v_lrn;
1985:
1986: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ad job network = '||v_sql_stmt);
1987: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
1988: MSC_CL_PULL.v_instance_id;
1989:
1990: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_EAM_WO_RELSHIPS_V = '|| SQL%ROWCOUNT);
1991: -- opm populate job operation network in call
1992: -- to

Line 1999: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATIONS';

1995: /* ds change end */
1996: END IF; --v_apps_ver >= MSC_UTIL.G_APPS120
1997:
1998:
1999: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATIONS';
2000: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OPERATIONS_V';
2001:
2002: v_sql_stmt:=
2003: 'insert into MSC_ST_JOB_OPERATIONS'

Line 2000: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OPERATIONS_V';

1996: END IF; --v_apps_ver >= MSC_UTIL.G_APPS120
1997:
1998:
1999: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OPERATIONS';
2000: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OPERATIONS_V';
2001:
2002: v_sql_stmt:=
2003: 'insert into MSC_ST_JOB_OPERATIONS'
2004: ||' ( WIP_ENTITY_ID,'

Line 2015: ||' from MRP_AD_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'

2011: ||' x.OPERATION_SEQ_NUM,'
2012: ||' 1,'
2013: ||' :v_refresh_id,'
2014: ||' :v_instance_id'
2015: ||' from MRP_AD_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
2016: ||' where x.RN> '||MSC_CL_PULL.v_lrn
2017: ||' AND DECODE( x.operation_seq_num,'
2018: ||' NULL, DECODE( :v_mps_consume_profile_value,'
2019: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'

Line 2016: ||' where x.RN> '||MSC_CL_PULL.v_lrn

2012: ||' 1,'
2013: ||' :v_refresh_id,'
2014: ||' :v_instance_id'
2015: ||' from MRP_AD_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
2016: ||' where x.RN> '||MSC_CL_PULL.v_lrn
2017: ||' AND DECODE( x.operation_seq_num,'
2018: ||' NULL, DECODE( :v_mps_consume_profile_value,'
2019: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
2020: ||' x.WJS_NET_QTY_FLAG), '

Line 2024: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

2020: ||' x.WJS_NET_QTY_FLAG), '
2021: ||' 1)= 1'
2022: || v_temp_sql;
2023:
2024: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2025: MSC_CL_PULL.v_instance_id,
2026: MSC_CL_PULL.v_mps_consume_profile_value;
2027:
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);

Line 2025: MSC_CL_PULL.v_instance_id,

2021: ||' 1)= 1'
2022: || v_temp_sql;
2023:
2024: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2025: MSC_CL_PULL.v_instance_id,
2026: MSC_CL_PULL.v_mps_consume_profile_value;
2027:
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);
2029: COMMIT;

Line 2026: MSC_CL_PULL.v_mps_consume_profile_value;

2022: || v_temp_sql;
2023:
2024: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2025: MSC_CL_PULL.v_instance_id,
2026: MSC_CL_PULL.v_mps_consume_profile_value;
2027:
2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);
2029: COMMIT;
2030:

Line 2032: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_REQUIREMENT_OPS';

2028: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);
2029: COMMIT;
2030:
2031:
2032: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_REQUIREMENT_OPS';
2033: MSC_CL_PULL.v_view_name := 'MRP_AD_REQUIREMENT_OPS_V';
2034:
2035: v_sql_stmt:=
2036: 'insert into MSC_ST_JOB_REQUIREMENT_OPS'

Line 2033: MSC_CL_PULL.v_view_name := 'MRP_AD_REQUIREMENT_OPS_V';

2029: COMMIT;
2030:
2031:
2032: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_REQUIREMENT_OPS';
2033: MSC_CL_PULL.v_view_name := 'MRP_AD_REQUIREMENT_OPS_V';
2034:
2035: v_sql_stmt:=
2036: 'insert into MSC_ST_JOB_REQUIREMENT_OPS'
2037: ||' ( WIP_ENTITY_ID,'

Line 2054: ||' from MRP_AD_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'

2050: ||' x.SOURCE_PHANTOM_ID,'
2051: ||' 1,'
2052: ||' :v_refresh_id,'
2053: ||' :v_instance_id'
2054: ||' from MRP_AD_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'
2055: ||' where x.RN> '||MSC_CL_PULL.v_lrn
2056: ||' AND DECODE( x.operation_seq_num,'
2057: ||' NULL, DECODE( :v_mps_consume_profile_value,'
2058: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'

Line 2055: ||' where x.RN> '||MSC_CL_PULL.v_lrn

2051: ||' 1,'
2052: ||' :v_refresh_id,'
2053: ||' :v_instance_id'
2054: ||' from MRP_AD_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'
2055: ||' where x.RN> '||MSC_CL_PULL.v_lrn
2056: ||' AND DECODE( x.operation_seq_num,'
2057: ||' NULL, DECODE( :v_mps_consume_profile_value,'
2058: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
2059: ||' x.WJS_NET_QTY_FLAG), '

Line 2063: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

2059: ||' x.WJS_NET_QTY_FLAG), '
2060: ||' 1)= 1'
2061: || v_temp_sql;
2062:
2063: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2064: MSC_CL_PULL.v_instance_id,
2065: MSC_CL_PULL.v_mps_consume_profile_value;
2066:
2067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);

Line 2064: MSC_CL_PULL.v_instance_id,

2060: ||' 1)= 1'
2061: || v_temp_sql;
2062:
2063: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2064: MSC_CL_PULL.v_instance_id,
2065: MSC_CL_PULL.v_mps_consume_profile_value;
2066:
2067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);
2068: COMMIT;

Line 2065: MSC_CL_PULL.v_mps_consume_profile_value;

2061: || v_temp_sql;
2062:
2063: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2064: MSC_CL_PULL.v_instance_id,
2065: MSC_CL_PULL.v_mps_consume_profile_value;
2066:
2067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);
2068: COMMIT;
2069:

Line 2070: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';

2066:
2067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);
2068: COMMIT;
2069:
2070: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';
2071: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OP_RESOURCES_V';
2072:
2073: v_sql_stmt:=
2074: 'insert into MSC_ST_JOB_OP_RESOURCES'

Line 2071: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OP_RESOURCES_V';

2067: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);
2068: COMMIT;
2069:
2070: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';
2071: MSC_CL_PULL.v_view_name := 'MRP_AD_JOB_OP_RESOURCES_V';
2072:
2073: v_sql_stmt:=
2074: 'insert into MSC_ST_JOB_OP_RESOURCES'
2075: ||' ( WIP_ENTITY_ID,'

Line 2088: ||' from MRP_AD_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

2084: ||' x.RESOURCE_SEQ_NUM,'
2085: ||' 1,'
2086: ||' :v_refresh_id,'
2087: ||' :v_instance_id'
2088: ||' from MRP_AD_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2089: ||' where x.RN> '||MSC_CL_PULL.v_lrn
2090: ||' AND DECODE( x.operation_seq_num,'
2091: ||' NULL, DECODE( :v_mps_consume_profile_value,'
2092: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'

Line 2089: ||' where x.RN> '||MSC_CL_PULL.v_lrn

2085: ||' 1,'
2086: ||' :v_refresh_id,'
2087: ||' :v_instance_id'
2088: ||' from MRP_AD_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2089: ||' where x.RN> '||MSC_CL_PULL.v_lrn
2090: ||' AND DECODE( x.operation_seq_num,'
2091: ||' NULL, DECODE( :v_mps_consume_profile_value,'
2092: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
2093: ||' x.WJS_NET_QTY_FLAG), '

Line 2097: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

2093: ||' x.WJS_NET_QTY_FLAG), '
2094: ||' 1)= 1'
2095: || v_temp_sql;
2096:
2097: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2098: MSC_CL_PULL.v_instance_id,
2099: MSC_CL_PULL.v_mps_consume_profile_value;
2100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2101: COMMIT;

Line 2098: MSC_CL_PULL.v_instance_id,

2094: ||' 1)= 1'
2095: || v_temp_sql;
2096:
2097: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2098: MSC_CL_PULL.v_instance_id,
2099: MSC_CL_PULL.v_mps_consume_profile_value;
2100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2101: COMMIT;
2102:

Line 2099: MSC_CL_PULL.v_mps_consume_profile_value;

2095: || v_temp_sql;
2096:
2097: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2098: MSC_CL_PULL.v_instance_id,
2099: MSC_CL_PULL.v_mps_consume_profile_value;
2100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2101: COMMIT;
2102:
2103: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';

Line 2103: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';

2099: MSC_CL_PULL.v_mps_consume_profile_value;
2100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2101: COMMIT;
2102:
2103: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';
2104: MSC_CL_PULL.v_view_name := 'MRP_AD_LJ_SUB_OP_RESOURCES_V';
2105:
2106: v_sql_stmt:=
2107: 'insert into MSC_ST_JOB_OP_RESOURCES'

Line 2104: MSC_CL_PULL.v_view_name := 'MRP_AD_LJ_SUB_OP_RESOURCES_V';

2100: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2101: COMMIT;
2102:
2103: MSC_CL_PULL.v_table_name:= 'MSC_ST_JOB_OP_RESOURCES';
2104: MSC_CL_PULL.v_view_name := 'MRP_AD_LJ_SUB_OP_RESOURCES_V';
2105:
2106: v_sql_stmt:=
2107: 'insert into MSC_ST_JOB_OP_RESOURCES'
2108: ||' ( WIP_ENTITY_ID,'

Line 2121: ||' from MRP_AD_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

2117: ||' x.RESOURCE_SEQ_NUM,'
2118: ||' 1,'
2119: ||' :v_refresh_id,'
2120: ||' :v_instance_id'
2121: ||' from MRP_AD_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2122: ||' where x.RN> '||MSC_CL_PULL.v_lrn
2123: ||' AND DECODE( x.operation_seq_num,'
2124: ||' NULL, DECODE( :v_mps_consume_profile_value,'
2125: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'

Line 2122: ||' where x.RN> '||MSC_CL_PULL.v_lrn

2118: ||' 1,'
2119: ||' :v_refresh_id,'
2120: ||' :v_instance_id'
2121: ||' from MRP_AD_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2122: ||' where x.RN> '||MSC_CL_PULL.v_lrn
2123: ||' AND DECODE( x.operation_seq_num,'
2124: ||' NULL, DECODE( :v_mps_consume_profile_value,'
2125: ||' 1, x.WJS_MPS_NET_QTY_FLAG,'
2126: ||' x.WJS_NET_QTY_FLAG), '

Line 2130: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,

2126: ||' x.WJS_NET_QTY_FLAG), '
2127: ||' 1)= 1'
2128: || v_temp_sql;
2129:
2130: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2131: MSC_CL_PULL.v_instance_id,
2132: MSC_CL_PULL.v_mps_consume_profile_value;
2133:
2134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

Line 2131: MSC_CL_PULL.v_instance_id,

2127: ||' 1)= 1'
2128: || v_temp_sql;
2129:
2130: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2131: MSC_CL_PULL.v_instance_id,
2132: MSC_CL_PULL.v_mps_consume_profile_value;
2133:
2134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2135: COMMIT;

Line 2132: MSC_CL_PULL.v_mps_consume_profile_value;

2128: || v_temp_sql;
2129:
2130: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id,
2131: MSC_CL_PULL.v_instance_id,
2132: MSC_CL_PULL.v_mps_consume_profile_value;
2133:
2134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows deleted MRP_AD_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2135: COMMIT;
2136:

Line 2139: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OPERATION_NETWORKS';

2135: COMMIT;
2136:
2137: END IF; /*incremental refresh */
2138:
2139: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OPERATION_NETWORKS';
2140: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_OP_NETWORKS_V';
2141:
2142: v_sql_stmt:=
2143: 'insert into MSC_ST_JOB_OPERATION_NETWORKS'

Line 2140: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_OP_NETWORKS_V';

2136:
2137: END IF; /*incremental refresh */
2138:
2139: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OPERATION_NETWORKS';
2140: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_OP_NETWORKS_V';
2141:
2142: v_sql_stmt:=
2143: 'insert into MSC_ST_JOB_OPERATION_NETWORKS'
2144: ||' (WIP_ENTITY_ID,'

Line 2177: ||' FROM MRP_AP_JOB_OP_NETWORKS_V '||MSC_CL_PULL.v_dblink||' x '

2173: ||' x.TO_WIP_ENTITY_ID,'
2174: ||' x.TOP_WIP_ENTITY_ID,' /*ds change end */
2175: ||' 2,'
2176: ||' :v_refresh_id'
2177: ||' FROM MRP_AP_JOB_OP_NETWORKS_V '||MSC_CL_PULL.v_dblink||' x '
2178: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2179: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2180: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2181: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';

Line 2179: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn

2175: ||' 2,'
2176: ||' :v_refresh_id'
2177: ||' FROM MRP_AP_JOB_OP_NETWORKS_V '||MSC_CL_PULL.v_dblink||' x '
2178: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2179: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2180: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2181: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2182:
2183: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ap job network = '||v_sql_stmt);

Line 2180: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn

2176: ||' :v_refresh_id'
2177: ||' FROM MRP_AP_JOB_OP_NETWORKS_V '||MSC_CL_PULL.v_dblink||' x '
2178: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2179: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2180: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2181: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2182:
2183: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ap job network = '||v_sql_stmt);
2184: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;

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

2177: ||' FROM MRP_AP_JOB_OP_NETWORKS_V '||MSC_CL_PULL.v_dblink||' x '
2178: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2179: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2180: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2181: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2182:
2183: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ap job network = '||v_sql_stmt);
2184: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);

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

2180: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2181: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2182:
2183: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: ap job network = '||v_sql_stmt);
2184: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
2186:
2187: COMMIT;
2188:

Line 2189: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OPERATIONS';

2185: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_NETWORKS_V = '|| SQL%ROWCOUNT);
2186:
2187: COMMIT;
2188:
2189: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OPERATIONS';
2190: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_OPERATIONS_V';
2191:
2192: v_sql_stmt:=
2193: 'insert into MSC_ST_JOB_OPERATIONS'

Line 2190: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_OPERATIONS_V';

2186:
2187: COMMIT;
2188:
2189: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OPERATIONS';
2190: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_OPERATIONS_V';
2191:
2192: v_sql_stmt:=
2193: 'insert into MSC_ST_JOB_OPERATIONS'
2194: ||' (WIP_ENTITY_ID,'

Line 2216: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN

2212: ||' REVERSE_CUMULATIVE_YIELD,'
2213: ||' NET_PLANNING_PERCENT,'
2214: ||' DELETED_FLAG,'
2215: ||' REFRESH_ID';
2216: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN
2217: v_sql_stmt:= v_sql_stmt
2218: ||', Operation_Code,'
2219: ||' actual_start_date,'
2220: ||' actual_end_date ,'

Line 2247: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN

2243: ||' x.REVERSE_CUMULATIVE_YIELD,'
2244: ||' x.NET_PLANNING_PERCENT,'
2245: ||' 2,'
2246: ||' :v_refresh_id';
2247: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_EAM_CMRO_SUP_VER AND MSC_UTIL.G_CMRO_EAM_INT_ENABLED = 'Y' THEN
2248: v_sql_stmt:= v_sql_stmt
2249: ||', x.Operation_Code,'
2250: ||' x.actual_start_date,'
2251: ||' x.actual_end_date,'

Line 2255: ||' FROM MRP_AP_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'

2251: ||' x.actual_end_date,'
2252: ||' x.Operation_desc';
2253: END IF;
2254: v_sql_stmt:= v_sql_stmt
2255: ||' FROM MRP_AP_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
2256: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2257: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2258: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2259: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';

Line 2257: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn

2253: END IF;
2254: v_sql_stmt:= v_sql_stmt
2255: ||' FROM MRP_AP_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
2256: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2257: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2258: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2259: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2260:
2261: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;

Line 2258: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn

2254: v_sql_stmt:= v_sql_stmt
2255: ||' FROM MRP_AP_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
2256: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2257: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2258: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2259: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2260:
2261: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2262: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);

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

2255: ||' FROM MRP_AP_JOB_OPERATIONS_V'||MSC_CL_PULL.v_dblink||' x'
2256: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2257: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2258: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2259: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2260:
2261: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2262: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);
2263:

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

2257: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2258: ||' OR x.RN1 >' ||MSC_CL_PULL.v_lrn
2259: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2260:
2261: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2262: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);
2263:
2264: COMMIT;
2265:

Line 2266: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_REQUIREMENT_OPS';

2262: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OPERATIONS_V = '|| SQL%ROWCOUNT);
2263:
2264: COMMIT;
2265:
2266: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_REQUIREMENT_OPS';
2267: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_REQUIREMENT_OPS_V';
2268:
2269: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
2270: v_temp_sql1 := ' x.BASIS_TYPE, ';

Line 2267: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_REQUIREMENT_OPS_V';

2263:
2264: COMMIT;
2265:
2266: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_REQUIREMENT_OPS';
2267: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_REQUIREMENT_OPS_V';
2268:
2269: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
2270: v_temp_sql1 := ' x.BASIS_TYPE, ';
2271: ELSE

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

2265:
2266: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_REQUIREMENT_OPS';
2267: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_REQUIREMENT_OPS_V';
2268:
2269: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
2270: v_temp_sql1 := ' x.BASIS_TYPE, ';
2271: ELSE
2272: v_temp_sql1 := ' NULL, ';
2273: END IF;

Line 2330: ||' FROM MRP_AP_JOB_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'

2326: ||' x.TO_END_ITEM_UNIT_NUMBER,'
2327: || v_temp_sql1
2328: ||' 2,'
2329: ||' :v_refresh_id'
2330: ||' FROM MRP_AP_JOB_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'
2331: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2332: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2333: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2334: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn || ' )';

Line 2332: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn

2328: ||' 2,'
2329: ||' :v_refresh_id'
2330: ||' FROM MRP_AP_JOB_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'
2331: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2332: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2333: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2334: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn || ' )';
2335:
2336: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;

Line 2333: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn

2329: ||' :v_refresh_id'
2330: ||' FROM MRP_AP_JOB_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'
2331: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2332: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2333: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2334: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn || ' )';
2335:
2336: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);

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

2330: ||' FROM MRP_AP_JOB_REQUIREMENT_OPS_V'||MSC_CL_PULL.v_dblink||' x'
2331: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2332: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2333: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2334: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn || ' )';
2335:
2336: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);
2338:

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

2332: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2333: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2334: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn || ' )';
2335:
2336: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_REQUIREMENT_OPS_V = '|| SQL%ROWCOUNT);
2338:
2339: COMMIT;
2340:

Line 2342: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RESOURCES';

2338:
2339: COMMIT;
2340:
2341:
2342: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RESOURCES';
2343: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_OP_RESOURCES_V';
2344:
2345: v_sql_stmt:=
2346: 'insert into MSC_ST_JOB_OP_RESOURCES'

Line 2343: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_OP_RESOURCES_V';

2339: COMMIT;
2340:
2341:
2342: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RESOURCES';
2343: MSC_CL_PULL.v_view_name := 'MRP_AP_JOB_OP_RESOURCES_V';
2344:
2345: v_sql_stmt:=
2346: 'insert into MSC_ST_JOB_OP_RESOURCES'
2347: ||' (WIP_ENTITY_ID,'

Line 2406: ||' FROM MRP_AP_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

2402: ||' x.PARENT_RESOURCE_SEQ,'
2403: ||' x.MAXIMUM_ASSIGNED_UNITS,'
2404: ||' 2,'
2405: ||' :v_refresh_id'
2406: ||' FROM MRP_AP_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2407: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2408: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2409: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2410: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';

Line 2408: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn

2404: ||' 2,'
2405: ||' :v_refresh_id'
2406: ||' FROM MRP_AP_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2407: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2408: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2409: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2410: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2411:
2412: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap job op resources = '||v_sql_stmt);

Line 2409: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn

2405: ||' :v_refresh_id'
2406: ||' FROM MRP_AP_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2407: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2408: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2409: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2410: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2411:
2412: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap job op resources = '||v_sql_stmt);
2413: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;

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

2406: ||' FROM MRP_AP_JOB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2407: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2408: ||' AND (x.RN >' ||MSC_CL_PULL.v_lrn
2409: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2410: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2411:
2412: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap job op resources = '||v_sql_stmt);
2413: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

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

2409: ||' OR x.RN1>' ||MSC_CL_PULL.v_lrn
2410: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn ||' )';
2411:
2412: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'to be removed: Ds debug: ap job op resources = '||v_sql_stmt);
2413: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id;
2414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2415:
2416: COMMIT;
2417:

Line 2418: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RESOURCES';

2414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_JOB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2415:
2416: COMMIT;
2417:
2418: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RESOURCES';
2419: MSC_CL_PULL.v_view_name := 'MRP_AP_LJ_SUB_OP_RESOURCES_V';
2420:
2421:
2422: v_sql_stmt:=

Line 2419: MSC_CL_PULL.v_view_name := 'MRP_AP_LJ_SUB_OP_RESOURCES_V';

2415:
2416: COMMIT;
2417:
2418: MSC_CL_PULL.v_table_name := 'MSC_ST_JOB_OP_RESOURCES';
2419: MSC_CL_PULL.v_view_name := 'MRP_AP_LJ_SUB_OP_RESOURCES_V';
2420:
2421:
2422: v_sql_stmt:=
2423: 'insert into MSC_ST_JOB_OP_RESOURCES'

Line 2471: ||' FROM MRP_AP_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'

2467: ||' x.SCHEDULE_FLAG,'
2468: ||' x.SETUP_ID,' /* ds change */
2469: ||' 2,'
2470: ||' :v_refresh_id'
2471: ||' FROM MRP_AP_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2472: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2473: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2474: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn
2475: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';

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

2469: ||' 2,'
2470: ||' :v_refresh_id'
2471: ||' FROM MRP_AP_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2472: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2473: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2474: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn
2475: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2476:
2477: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;

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

2470: ||' :v_refresh_id'
2471: ||' FROM MRP_AP_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2472: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2473: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2474: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn
2475: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2476:
2477: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);

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

2471: ||' FROM MRP_AP_LJ_SUB_OP_RESOURCES_V'||MSC_CL_PULL.v_dblink||' x'
2472: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2473: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2474: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn
2475: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2476:
2477: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2479:

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

2473: ||' AND (x.RN1>' || MSC_CL_PULL.v_lrn
2474: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn
2475: ||' OR x.RN3>' || MSC_CL_PULL.v_lrn || ' )';
2476:
2477: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id;
2478: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_LJ_SUB_OP_RESOURCES_V = '|| SQL%ROWCOUNT);
2479:
2480: COMMIT;
2481:

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

2485: END;
2486:
2487: -- ====================== 6: Repetitive Schedule ====================
2488:
2489: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
2490: MSC_CL_PULL.v_view_name := 'MRP_AP_REPT_ITEM_SUPPLIES_V';
2491:
2492: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2493:

Line 2490: MSC_CL_PULL.v_view_name := 'MRP_AP_REPT_ITEM_SUPPLIES_V';

2486:
2487: -- ====================== 6: Repetitive Schedule ====================
2488:
2489: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
2490: MSC_CL_PULL.v_view_name := 'MRP_AP_REPT_ITEM_SUPPLIES_V';
2491:
2492: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2493:
2494: v_union_sql :=

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

2488:
2489: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
2490: MSC_CL_PULL.v_view_name := 'MRP_AP_REPT_ITEM_SUPPLIES_V';
2491:
2492: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2493:
2494: v_union_sql :=
2495: ' AND ( x.RN1 > :v_lrn )'
2496: ||' UNION '

Line 2521: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

2517: ||' 30,'
2518: ||' 2,'
2519: ||' :v_refresh_id,'
2520: ||' :v_instance_id'
2521: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2522: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2523: ||' AND (x.RN2 > :v_lrn)'
2524: ||' UNION '
2525: ||' select'

Line 2549: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

2545: ||' 30,'
2546: ||' 2,'
2547: ||' :v_refresh_id,'
2548: ||' :v_instance_id'
2549: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2550: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2551: ||' AND (x.RN3 > :v_lrn)'
2552: ||' UNION '
2553: ||' select'

Line 2577: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

2573: ||' 30,'
2574: ||' 2,'
2575: ||' :v_refresh_id,'
2576: ||' :v_instance_id'
2577: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2578: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2579: ||' AND (x.RN4 > :v_lrn)';
2580:
2581: ELSE

Line 2636: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

2632: ||' 30,'
2633: ||' 2,'
2634: ||' :v_refresh_id,'
2635: ||' :v_instance_id'
2636: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2637: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2638: || v_union_sql;
2639:
2640: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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

2636: ||' from MRP_AP_REPT_ITEM_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
2637: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
2638: || v_union_sql;
2639:
2640: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2641:
2642: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2643: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2644: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

Line 2642: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

2638: || v_union_sql;
2639:
2640: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2641:
2642: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2643: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2644: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2645: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2646: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

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

2639:
2640: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2641:
2642: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2643: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2644: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2645: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2646: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2647: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,

Line 2644: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

2640: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
2641:
2642: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2643: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2644: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2645: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2646: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2647: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2648: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

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

2641:
2642: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2643: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2644: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2645: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2646: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2647: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2648: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2649: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;

Line 2646: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

2642: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2643: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2644: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2645: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2646: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2647: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2648: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2649: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
2650:

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

2643: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2644: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2645: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2646: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2647: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2648: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2649: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
2650:
2651: ELSE

Line 2648: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

2644: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2645: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2646: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2647: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2648: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2649: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
2650:
2651: ELSE
2652:

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

2645: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2646: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2647: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn,
2648: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2649: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
2650:
2651: ELSE
2652:
2653: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

Line 2653: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

2649: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
2650:
2651: ELSE
2652:
2653: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2654: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2655: END IF;
2656:
2657: COMMIT;

Line 2654: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

2650:
2651: ELSE
2652:
2653: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
2654: MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
2655: END IF;
2656:
2657: COMMIT;
2658:

Line 2659: END IF; -- MSC_CL_PULL.WIP_ENABLED;

2655: END IF;
2656:
2657: COMMIT;
2658:
2659: END IF; -- MSC_CL_PULL.WIP_ENABLED;
2660:
2661: END LOAD_WIP_SUPPLY;
2662:
2663: