eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_SUPPLY_PULL dependencies on MSC_CL_PULL

Line 32: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN

28: BEGIN
29:
30: lv_task_start_time := sysdate;
31:
32: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
33:
34: -- =================== DELETED DATA ======================
35:
36: --=================== Net Change Mode: Delete ==================

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

34: -- =================== DELETED DATA ======================
35:
36: --=================== Net Change Mode: Delete ==================
37:
38: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
39:
40: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
41: MSC_CL_PULL.v_view_name := 'MRP_AD_PO_SUPPLIES_V';
42:

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

36: --=================== Net Change Mode: Delete ==================
37:
38: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
39:
40: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
41: MSC_CL_PULL.v_view_name := 'MRP_AD_PO_SUPPLIES_V';
42:
43: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
44: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 41: MSC_CL_PULL.v_view_name := 'MRP_AD_PO_SUPPLIES_V';

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

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

39:
40: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
41: MSC_CL_PULL.v_view_name := 'MRP_AD_PO_SUPPLIES_V';
42:
43: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
44: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
45: ELSE
46: v_temp_sql := NULL;
47: END IF;

Line 62: ||' from MRP_AD_PO_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

58: ||' 1,' -- using 1, such that the MSCCLBAB.LOAD_SUPPLY
59: ||' 1,' -- can pick this PO record up for delete
60: ||' :v_refresh_id,'
61: ||' :v_instance_id'
62: ||' from MRP_AD_PO_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
63: ||' where x.RN>'||MSC_CL_PULL.v_lrn
64: || v_temp_sql;
65:
66: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

59: ||' 1,' -- can pick this PO record up for delete
60: ||' :v_refresh_id,'
61: ||' :v_instance_id'
62: ||' from MRP_AD_PO_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
63: ||' where x.RN>'||MSC_CL_PULL.v_lrn
64: || v_temp_sql;
65:
66: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
67:

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

62: ||' from MRP_AD_PO_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
63: ||' where x.RN>'||MSC_CL_PULL.v_lrn
64: || v_temp_sql;
65:
66: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
67:
68: COMMIT;
69:
70: END IF;

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

69:
70: END IF;
71:
72:
73: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
74: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_SHIP_SUPPLY_V';
75:
76:
77: /* Added this code for VMI changes */

Line 74: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_SHIP_SUPPLY_V';

70: END IF;
71:
72:
73: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
74: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_SHIP_SUPPLY_V';
75:
76:
77: /* Added this code for VMI changes */
78: Begin

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

76:
77: /* Added this code for VMI changes */
78: Begin
79:
80: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
81: v_temp_sql := 'x.VMI_FLAG,x.VENDOR_ID,x.VENDOR_SITE_ID,x.POSTPROCESSING_LEAD_TIME,';
82: ELSE
83: v_temp_sql := 'NULL,NULL,NULL,NULL,';
84: END IF;

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

84: END IF;
85:
86: End;
87:
88: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
89: v_temp_sql1 := 'ITEM_TYPE_VALUE,';
90: v_temp_sql2 := 'DECODE(nvl(x.CONDITION_TYPE,''G''),''G'',1,''B'',2),';
91: ELSE
92: v_temp_sql1 :=NULL;

Line 178: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'||'MRP_AP_PO_SHIP_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'

174: ||' x.INTRANSIT_OWNING_ORG_ID,'
175: ||' x.REQUISITION_LINE_ID,'
176: ||' :v_refresh_id,'
177: ||' :v_instance_id'
178: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'||'MRP_AP_PO_SHIP_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
179: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
180: ||' AND mpp.project_id (+)= x.project_id'
181: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
182: ||' 1, x.MRP_TO_Organization_ID,'

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

183: ||' x.Organization_ID)'
184: ||' and DECODE( :v_mps_consume_profile_value,'
185: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
186: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
187: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
188: ||' x.RN2>'||MSC_CL_PULL.v_lrn
189: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
190:
191: v_temp_sql1 :=NULL;

Line 188: ||' x.RN2>'||MSC_CL_PULL.v_lrn

184: ||' and DECODE( :v_mps_consume_profile_value,'
185: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
186: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
187: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
188: ||' x.RN2>'||MSC_CL_PULL.v_lrn
189: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
190:
191: v_temp_sql1 :=NULL;
192: v_temp_sql2 :=NULL;

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

185: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
186: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
187: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
188: ||' x.RN2>'||MSC_CL_PULL.v_lrn
189: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
190:
191: v_temp_sql1 :=NULL;
192: v_temp_sql2 :=NULL;
193: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

Line 193: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

189: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
190:
191: v_temp_sql1 :=NULL;
192: v_temp_sql2 :=NULL;
193: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
194: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
195: MSC_CL_PULL.v_mps_consume_profile_value,
196: MSC_CL_PULL.v_mps_consume_profile_value,
197: MSC_CL_PULL.v_mps_consume_profile_value,

Line 194: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

190:
191: v_temp_sql1 :=NULL;
192: v_temp_sql2 :=NULL;
193: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
194: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
195: MSC_CL_PULL.v_mps_consume_profile_value,
196: MSC_CL_PULL.v_mps_consume_profile_value,
197: MSC_CL_PULL.v_mps_consume_profile_value,
198: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 195: MSC_CL_PULL.v_mps_consume_profile_value,

191: v_temp_sql1 :=NULL;
192: v_temp_sql2 :=NULL;
193: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
194: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
195: MSC_CL_PULL.v_mps_consume_profile_value,
196: MSC_CL_PULL.v_mps_consume_profile_value,
197: MSC_CL_PULL.v_mps_consume_profile_value,
198: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
199: MSC_CL_PULL.v_mps_consume_profile_value,

Line 196: MSC_CL_PULL.v_mps_consume_profile_value,

192: v_temp_sql2 :=NULL;
193: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
194: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
195: MSC_CL_PULL.v_mps_consume_profile_value,
196: MSC_CL_PULL.v_mps_consume_profile_value,
197: MSC_CL_PULL.v_mps_consume_profile_value,
198: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
199: MSC_CL_PULL.v_mps_consume_profile_value,
200: MSC_CL_PULL.v_mps_consume_profile_value;

Line 197: MSC_CL_PULL.v_mps_consume_profile_value,

193: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
194: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
195: MSC_CL_PULL.v_mps_consume_profile_value,
196: MSC_CL_PULL.v_mps_consume_profile_value,
197: MSC_CL_PULL.v_mps_consume_profile_value,
198: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
199: MSC_CL_PULL.v_mps_consume_profile_value,
200: MSC_CL_PULL.v_mps_consume_profile_value;
201:

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

194: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
195: MSC_CL_PULL.v_mps_consume_profile_value,
196: MSC_CL_PULL.v_mps_consume_profile_value,
197: MSC_CL_PULL.v_mps_consume_profile_value,
198: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
199: MSC_CL_PULL.v_mps_consume_profile_value,
200: MSC_CL_PULL.v_mps_consume_profile_value;
201:
202: COMMIT;

Line 199: MSC_CL_PULL.v_mps_consume_profile_value,

195: MSC_CL_PULL.v_mps_consume_profile_value,
196: MSC_CL_PULL.v_mps_consume_profile_value,
197: MSC_CL_PULL.v_mps_consume_profile_value,
198: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
199: MSC_CL_PULL.v_mps_consume_profile_value,
200: MSC_CL_PULL.v_mps_consume_profile_value;
201:
202: COMMIT;
203:

Line 200: MSC_CL_PULL.v_mps_consume_profile_value;

196: MSC_CL_PULL.v_mps_consume_profile_value,
197: MSC_CL_PULL.v_mps_consume_profile_value,
198: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
199: MSC_CL_PULL.v_mps_consume_profile_value,
200: MSC_CL_PULL.v_mps_consume_profile_value;
201:
202: COMMIT;
203:
204:

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

202: COMMIT;
203:
204:
205:
206: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
207: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_SHIP_RCV_SUPPLY_V';
208:
209:
210: /* Added this code for VMI changes */

Line 207: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_SHIP_RCV_SUPPLY_V';

203:
204:
205:
206: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
207: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_SHIP_RCV_SUPPLY_V';
208:
209:
210: /* Added this code for VMI changes */
211: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

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

207: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_SHIP_RCV_SUPPLY_V';
208:
209:
210: /* Added this code for VMI changes */
211: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
212: v_temp_sql := 'x.VMI_FLAG,';
213: ELSE
214: v_temp_sql := ' NULL, ';
215: END IF;

Line 284: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'

280: || v_temp_sql
281: ||' 2,'
282: ||' :v_refresh_id,'
283: ||' :v_instance_id'
284: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
285: ||' MRP_AP_PO_SHIP_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
286: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
287: ||' AND mpp.project_id (+)= x.project_id'
288: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'

Line 285: ||' MRP_AP_PO_SHIP_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'

281: ||' 2,'
282: ||' :v_refresh_id,'
283: ||' :v_instance_id'
284: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
285: ||' MRP_AP_PO_SHIP_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
286: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
287: ||' AND mpp.project_id (+)= x.project_id'
288: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
289: ||' 1, x.MRP_TO_Organization_ID,'

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

290: ||' x.Organization_ID)'
291: ||' and DECODE( :v_mps_consume_profile_value,'
292: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
293: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
294: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
295: ||' x.RN2>'||MSC_CL_PULL.v_lrn
296: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
297:
298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

Line 295: ||' x.RN2>'||MSC_CL_PULL.v_lrn

291: ||' and DECODE( :v_mps_consume_profile_value,'
292: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
293: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
294: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
295: ||' x.RN2>'||MSC_CL_PULL.v_lrn
296: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
297:
298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
299: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

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

292: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
293: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
294: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
295: ||' x.RN2>'||MSC_CL_PULL.v_lrn
296: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
297:
298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
299: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
300: MSC_CL_PULL.v_mps_consume_profile_value,

Line 298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

294: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
295: ||' x.RN2>'||MSC_CL_PULL.v_lrn
296: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
297:
298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
299: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
300: MSC_CL_PULL.v_mps_consume_profile_value,
301: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
302: MSC_CL_PULL.v_mps_consume_profile_value,

Line 299: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

295: ||' x.RN2>'||MSC_CL_PULL.v_lrn
296: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
297:
298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
299: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
300: MSC_CL_PULL.v_mps_consume_profile_value,
301: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
302: MSC_CL_PULL.v_mps_consume_profile_value,
303: MSC_CL_PULL.v_mps_consume_profile_value;

Line 300: MSC_CL_PULL.v_mps_consume_profile_value,

296: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
297:
298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
299: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
300: MSC_CL_PULL.v_mps_consume_profile_value,
301: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
302: MSC_CL_PULL.v_mps_consume_profile_value,
303: MSC_CL_PULL.v_mps_consume_profile_value;
304:

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

297:
298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
299: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
300: MSC_CL_PULL.v_mps_consume_profile_value,
301: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
302: MSC_CL_PULL.v_mps_consume_profile_value,
303: MSC_CL_PULL.v_mps_consume_profile_value;
304:
305: COMMIT;

Line 302: MSC_CL_PULL.v_mps_consume_profile_value,

298: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
299: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
300: MSC_CL_PULL.v_mps_consume_profile_value,
301: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
302: MSC_CL_PULL.v_mps_consume_profile_value,
303: MSC_CL_PULL.v_mps_consume_profile_value;
304:
305: COMMIT;
306:

Line 303: MSC_CL_PULL.v_mps_consume_profile_value;

299: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
300: MSC_CL_PULL.v_mps_consume_profile_value,
301: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
302: MSC_CL_PULL.v_mps_consume_profile_value,
303: MSC_CL_PULL.v_mps_consume_profile_value;
304:
305: COMMIT;
306:
307: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

303: MSC_CL_PULL.v_mps_consume_profile_value;
304:
305: COMMIT;
306:
307: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
308: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_RCV_SUPPLY_V';
309:
310: /* Added this code for VMI changes */
311: -- bug#8426490 Add postprocessing LT for Supply-(PO in Receiving), Ord Type=8

Line 308: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_RCV_SUPPLY_V';

304:
305: COMMIT;
306:
307: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
308: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_RCV_SUPPLY_V';
309:
310: /* Added this code for VMI changes */
311: -- bug#8426490 Add postprocessing LT for Supply-(PO in Receiving), Ord Type=8
312: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

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

308: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_RCV_SUPPLY_V';
309:
310: /* Added this code for VMI changes */
311: -- bug#8426490 Add postprocessing LT for Supply-(PO in Receiving), Ord Type=8
312: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
313: v_temp_sql := 'x.VMI_FLAG,x.POSTPROCESSING_LEAD_TIME,';
314: ELSE
315: v_temp_sql := ' NULL,NULL, ';
316: END IF;

Line 388: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'

384: || v_temp_sql
385: ||' 2,'
386: ||' :v_refresh_id,'
387: ||' :v_instance_id'
388: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
389: ||' MRP_AP_PO_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
390: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
391: ||' AND mpp.project_id (+)= x.project_id'
392: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'

Line 389: ||' MRP_AP_PO_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'

385: ||' 2,'
386: ||' :v_refresh_id,'
387: ||' :v_instance_id'
388: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
389: ||' MRP_AP_PO_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
390: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
391: ||' AND mpp.project_id (+)= x.project_id'
392: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
393: ||' 1, x.MRP_TO_Organization_ID,'

Line 398: ||' AND (' /* x.RN1>'||MSC_CL_PULL.v_lrn */

394: ||' x.Organization_ID)'
395: ||' and DECODE( :v_mps_consume_profile_value,'
396: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
397: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
398: ||' AND (' /* x.RN1>'||MSC_CL_PULL.v_lrn */
399: ||' x.RN2>'||MSC_CL_PULL.v_lrn
400: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
401:
402: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

Line 399: ||' x.RN2>'||MSC_CL_PULL.v_lrn

395: ||' and DECODE( :v_mps_consume_profile_value,'
396: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
397: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
398: ||' AND (' /* x.RN1>'||MSC_CL_PULL.v_lrn */
399: ||' x.RN2>'||MSC_CL_PULL.v_lrn
400: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
401:
402: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
403: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

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

396: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
397: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
398: ||' AND (' /* x.RN1>'||MSC_CL_PULL.v_lrn */
399: ||' x.RN2>'||MSC_CL_PULL.v_lrn
400: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
401:
402: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
403: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
404: MSC_CL_PULL.v_mps_consume_profile_value,

Line 402: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

398: ||' AND (' /* x.RN1>'||MSC_CL_PULL.v_lrn */
399: ||' x.RN2>'||MSC_CL_PULL.v_lrn
400: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
401:
402: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
403: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
404: MSC_CL_PULL.v_mps_consume_profile_value,
405: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
406: MSC_CL_PULL.v_mps_consume_profile_value,

Line 403: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

399: ||' x.RN2>'||MSC_CL_PULL.v_lrn
400: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
401:
402: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
403: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
404: MSC_CL_PULL.v_mps_consume_profile_value,
405: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
406: MSC_CL_PULL.v_mps_consume_profile_value,
407: MSC_CL_PULL.v_mps_consume_profile_value;

Line 404: MSC_CL_PULL.v_mps_consume_profile_value,

400: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
401:
402: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
403: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
404: MSC_CL_PULL.v_mps_consume_profile_value,
405: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
406: MSC_CL_PULL.v_mps_consume_profile_value,
407: MSC_CL_PULL.v_mps_consume_profile_value;
408:

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

401:
402: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
403: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
404: MSC_CL_PULL.v_mps_consume_profile_value,
405: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
406: MSC_CL_PULL.v_mps_consume_profile_value,
407: MSC_CL_PULL.v_mps_consume_profile_value;
408:
409: COMMIT;

Line 406: MSC_CL_PULL.v_mps_consume_profile_value,

402: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
403: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
404: MSC_CL_PULL.v_mps_consume_profile_value,
405: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
406: MSC_CL_PULL.v_mps_consume_profile_value,
407: MSC_CL_PULL.v_mps_consume_profile_value;
408:
409: COMMIT;
410:

Line 407: MSC_CL_PULL.v_mps_consume_profile_value;

403: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
404: MSC_CL_PULL.v_mps_consume_profile_value,
405: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
406: MSC_CL_PULL.v_mps_consume_profile_value,
407: MSC_CL_PULL.v_mps_consume_profile_value;
408:
409: COMMIT;
410:
411: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

407: MSC_CL_PULL.v_mps_consume_profile_value;
408:
409: COMMIT;
410:
411: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
412: MSC_CL_PULL.v_view_name := 'MRP_AP_INTRANSIT_SUPPLIES_V';
413:
414: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
415: v_temp_sql := 'x.POSTPROCESSING_LEAD_TIME,';

Line 412: MSC_CL_PULL.v_view_name := 'MRP_AP_INTRANSIT_SUPPLIES_V';

408:
409: COMMIT;
410:
411: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
412: MSC_CL_PULL.v_view_name := 'MRP_AP_INTRANSIT_SUPPLIES_V';
413:
414: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
415: v_temp_sql := 'x.POSTPROCESSING_LEAD_TIME,';
416: ELSE

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

410:
411: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
412: MSC_CL_PULL.v_view_name := 'MRP_AP_INTRANSIT_SUPPLIES_V';
413:
414: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
415: v_temp_sql := 'x.POSTPROCESSING_LEAD_TIME,';
416: ELSE
417: v_temp_sql := 'NULL,';
418: END IF;

Line 455: ||' from MRP_AP_INTRANSIT_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

451: || v_temp_sql
452: ||' 2,'
453: ||' :v_refresh_id,'
454: ||' :v_instance_id'
455: ||' from MRP_AP_INTRANSIT_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
456: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
457: ||' AND (DECODE( :v_so_ship_arrive_value,'
458: ||' 1, NVL(x.arrived_flag, 2), 2)= 2)'
459: ||' AND (x.RN2>'||MSC_CL_PULL.v_lrn||')';

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

455: ||' from MRP_AP_INTRANSIT_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
456: ||' where x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
457: ||' AND (DECODE( :v_so_ship_arrive_value,'
458: ||' 1, NVL(x.arrived_flag, 2), 2)= 2)'
459: ||' AND (x.RN2>'||MSC_CL_PULL.v_lrn||')';
460:
461:
462: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
463: MSC_CL_PULL.v_so_ship_arrive_value;

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

458: ||' 1, NVL(x.arrived_flag, 2), 2)= 2)'
459: ||' AND (x.RN2>'||MSC_CL_PULL.v_lrn||')';
460:
461:
462: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
463: MSC_CL_PULL.v_so_ship_arrive_value;
464:
465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN
466: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),

Line 463: MSC_CL_PULL.v_so_ship_arrive_value;

459: ||' AND (x.RN2>'||MSC_CL_PULL.v_lrn||')';
460:
461:
462: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
463: MSC_CL_PULL.v_so_ship_arrive_value;
464:
465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN
466: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
467: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),

Line 465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN

461:
462: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
463: MSC_CL_PULL.v_so_ship_arrive_value;
464:
465: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN
466: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
467: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
468: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
469: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';

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

467: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
468: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
469: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';
470:
471: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
472: MSC_CL_PULL.v_view_name := 'MRP_AP_OH_PO_RCV_SUPPLY_V';
473:
474: v_sql_stmt:=
475: 'insert into MSC_ST_SUPPLIES'

Line 472: MSC_CL_PULL.v_view_name := 'MRP_AP_OH_PO_RCV_SUPPLY_V';

468: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
469: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';
470:
471: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
472: MSC_CL_PULL.v_view_name := 'MRP_AP_OH_PO_RCV_SUPPLY_V';
473:
474: v_sql_stmt:=
475: 'insert into MSC_ST_SUPPLIES'
476: ||' ( INVENTORY_ITEM_ID,'

Line 514: ||' from MRP_AP_OH_PO_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'

510: ||' x.HOLD_DATE,'
511: ||' 2,'
512: ||' :v_refresh_id,'
513: ||' :v_instance_id'
514: ||' from MRP_AP_OH_PO_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
515: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
516:
517: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
518:

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

513: ||' :v_instance_id'
514: ||' from MRP_AP_OH_PO_RCV_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
515: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
516:
517: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
518:
519: COMMIT;
520:
521: END IF; --MSC_CL_PULL.v_apps_ver >= G_APPS120

Line 521: END IF; --MSC_CL_PULL.v_apps_ver >= G_APPS120

517: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
518:
519: COMMIT;
520:
521: END IF; --MSC_CL_PULL.v_apps_ver >= G_APPS120
522: END IF; -- MSC_CL_PULL.PO_ENABLED
523:
524:
525: END LOAD_PO_SUPPLY;

Line 522: END IF; -- MSC_CL_PULL.PO_ENABLED

518:
519: COMMIT;
520:
521: END IF; --MSC_CL_PULL.v_apps_ver >= G_APPS120
522: END IF; -- MSC_CL_PULL.PO_ENABLED
523:
524:
525: END LOAD_PO_SUPPLY;
526:

Line 535: IF MSC_CL_PULL.OH_ENABLED= MSC_UTIL.SYS_YES THEN

531:
532:
533: -- ====================== 6: On Hand ====================
534:
535: IF MSC_CL_PULL.OH_ENABLED= MSC_UTIL.SYS_YES THEN
536:
537: --=================== Net Change Mode: Delete ==================
538:
539: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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

535: IF MSC_CL_PULL.OH_ENABLED= MSC_UTIL.SYS_YES THEN
536:
537: --=================== Net Change Mode: Delete ==================
538:
539: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
540:
541: -- delete
542: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
543: v_temp_sql := ' x.QUANTITY, x.PROJECT_ID,x.TASK_ID,x.END_ITEM_UNIT_NUMBER,

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

538:
539: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
540:
541: -- delete
542: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
543: v_temp_sql := ' x.QUANTITY, x.PROJECT_ID,x.TASK_ID,x.END_ITEM_UNIT_NUMBER,
544: decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
545: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
546: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),

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

553: NULL,
554: NULL, ';
555: END IF;
556:
557: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
558: MSC_CL_PULL.v_view_name := 'MRP_AD_ONHAND_SUPPLIES_V';
559:
560: v_sql_stmt:=
561: ' insert into MSC_ST_SUPPLIES'

Line 558: MSC_CL_PULL.v_view_name := 'MRP_AD_ONHAND_SUPPLIES_V';

554: NULL, ';
555: END IF;
556:
557: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
558: MSC_CL_PULL.v_view_name := 'MRP_AD_ONHAND_SUPPLIES_V';
559:
560: v_sql_stmt:=
561: ' insert into MSC_ST_SUPPLIES'
562: ||' ( INVENTORY_ITEM_ID,'

Line 588: ||' from MRP_AD_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

584: ||' 1,'
585: || v_temp_sql --for 11i sources
586: ||' :v_refresh_id,'
587: ||' :v_instance_id'
588: ||' from MRP_AD_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
589: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
590: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
591:
592: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

586: ||' :v_refresh_id,'
587: ||' :v_instance_id'
588: ||' from MRP_AD_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
589: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
590: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
591:
592: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
593:
594: COMMIT;

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

588: ||' from MRP_AD_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
589: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
590: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
591:
592: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
593:
594: COMMIT;
595:
596: -- insert/update

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

595:
596: -- insert/update
597:
598: /* Added this code for VMI changes */
599: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
600: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
601: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
602: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
603: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';

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

605: ELSE
606: v_temp_sql := ' NULL, NULL, NULL, NULL, ';
607: END IF;
608:
609: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
610:
611:
612: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
613: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580

Line 613: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580

609: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
610:
611:
612: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
613: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
614: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
615: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
616: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
617: END IF;

Line 614: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';

610:
611:
612: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
613: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
614: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
615: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
616: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
617: END IF;
618:

Line 615: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN

611:
612: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
613: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
614: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
615: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
616: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
617: END IF;
618:
619: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';

Line 616: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';

612: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
613: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
614: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
615: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
616: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
617: END IF;
618:
619: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
620: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;

Line 623: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';

619: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
620: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;
621:
622: ELSE
623: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
624: v_temp_sql := v_temp_sql || ' NULL, NULL, NULL,';
625: end if;
626:
627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew Onhand is- incr ' || MSC_CL_PULL.v_view_name);

Line 627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew Onhand is- incr ' || MSC_CL_PULL.v_view_name);

623: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
624: v_temp_sql := v_temp_sql || ' NULL, NULL, NULL,';
625: end if;
626:
627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew Onhand is- incr ' || MSC_CL_PULL.v_view_name);
628:
629:
630: v_sql_stmt:=
631: 'insert into MSC_ST_SUPPLIES'

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

669: ||' 2,'
670: || v_temp_sql
671: ||' :v_refresh_id,'
672: ||' :v_instance_id'
673: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x '
674: /*
675: ||' ( SELECT DISTINCT'
676: ||' inventory_item_id,'
677: ||' organization_id,'

Line 680: ||' FROM MRP_AN_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink

676: ||' inventory_item_id,'
677: ||' organization_id,'
678: ||' subinventory_code,'
679: ||' lot_number'
680: ||' FROM MRP_AN_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink
681: ||' WHERE ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
682: ||' AND rn>'||MSC_CL_PULL.v_lrn||') a'
683: ||' WHERE a.inventory_item_id= x.inventory_item_id'
684: ||' AND a.organization_id= x.organization_id'

Line 682: ||' AND rn>'||MSC_CL_PULL.v_lrn||') a'

678: ||' subinventory_code,'
679: ||' lot_number'
680: ||' FROM MRP_AN_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink
681: ||' WHERE ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
682: ||' AND rn>'||MSC_CL_PULL.v_lrn||') a'
683: ||' WHERE a.inventory_item_id= x.inventory_item_id'
684: ||' AND a.organization_id= x.organization_id'
685: ||' AND NVL(a.subinventory_code,'' '')= NVL( x.subinventory_code,'' '')'
686: ||' AND NVL(a.lot_number,'' '')= NVL( x.lot_number,'' '')';*/

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

684: ||' AND a.organization_id= x.organization_id'
685: ||' AND NVL(a.subinventory_code,'' '')= NVL( x.subinventory_code,'' '')'
686: ||' AND NVL(a.lot_number,'' '')= NVL( x.lot_number,'' '')';*/
687: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
688: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
689: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
690:
691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP SQL stmt Onhand is ' || v_sql_stmt);
692:

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

685: ||' AND NVL(a.subinventory_code,'' '')= NVL( x.subinventory_code,'' '')'
686: ||' AND NVL(a.lot_number,'' '')= NVL( x.lot_number,'' '')';*/
687: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
688: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
689: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
690:
691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP SQL stmt Onhand is ' || v_sql_stmt);
692:
693: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

689: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
690:
691: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP SQL stmt Onhand is ' || v_sql_stmt);
692:
693: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
694:
695: COMMIT;
696:
697: ELSE -- complete refresh

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

695: COMMIT;
696:
697: ELSE -- complete refresh
698:
699: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
700: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
701:
702: /* Added this code for VMI changes */
703: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

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

696:
697: ELSE -- complete refresh
698:
699: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
700: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
701:
702: /* Added this code for VMI changes */
703: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
704: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),

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

699: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
700: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
701:
702: /* Added this code for VMI changes */
703: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
704: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
705: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
706: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
707: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';

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

710: v_temp_sql := ' NULL, NULL, NULL, NULL, ';
711: END IF;
712:
713:
714: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
715:
716: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
717:
718: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580

Line 718: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580

714: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
715:
716: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
717:
718: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
719: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
720: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
721: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
722: END IF;

Line 719: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';

715:
716: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
717:
718: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
719: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
720: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
721: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
722: END IF;
723:

Line 720: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN

716: IF (MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
717:
718: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
719: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
720: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
721: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
722: END IF;
723:
724: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';

Line 721: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';

717:
718: IF (MSC_CL_PULL.v_apps_ver > MSC_UTIL.G_APPS115) THEN -- bug 8819580
719: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
720: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
721: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_FLEX_V';
722: END IF;
723:
724: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
725: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;

Line 731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew Onhand is targ/comp ' || MSC_CL_PULL.v_view_name);

727: ELSE
728: v_temp_sql := v_temp_sql || ' NULL, NULL, NULL,';
729: end if;
730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP v_temp_sql ' || v_temp_sql);
731: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP VIew Onhand is targ/comp ' || MSC_CL_PULL.v_view_name);
732: v_sql_stmt:=
733: 'insert into MSC_ST_SUPPLIES'
734: ||' ( INVENTORY_ITEM_ID,'
735: ||' ORGANIZATION_ID,'

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

771: ||' SYSDATE,'
772: ||' 2,'
773: ||' :v_refresh_id,'
774: ||' :v_instance_id'
775: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
776: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
777:
778: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
779: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP v_sql_stmt ' || v_sql_stmt);

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

774: ||' :v_instance_id'
775: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
776: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
777:
778: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
779: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'SRP v_sql_stmt ' || v_sql_stmt);
780: COMMIT;
781:
782: END IF; -- incremental refresh

Line 784: END IF; -- MSC_CL_PULL.OH_ENABLED

780: COMMIT;
781:
782: END IF; -- incremental refresh
783:
784: END IF; -- MSC_CL_PULL.OH_ENABLED
785:
786: END LOAD_OH_SUPPLY;
787:
788:

Line 795: IF MSC_CL_PULL.MPS_ENABLED= MSC_UTIL.SYS_YES THEN

791: BEGIN
792:
793: -- ====================== 8: MPS ====================
794:
795: IF MSC_CL_PULL.MPS_ENABLED= MSC_UTIL.SYS_YES THEN
796:
797: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
798:
799: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

793: -- ====================== 8: MPS ====================
794:
795: IF MSC_CL_PULL.MPS_ENABLED= MSC_UTIL.SYS_YES THEN
796:
797: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
798:
799: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
800: MSC_CL_PULL.v_view_name := 'MRP_AD_MPS_SUPPLIES_V';
801:

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

795: IF MSC_CL_PULL.MPS_ENABLED= MSC_UTIL.SYS_YES THEN
796:
797: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
798:
799: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
800: MSC_CL_PULL.v_view_name := 'MRP_AD_MPS_SUPPLIES_V';
801:
802: v_sql_stmt:=
803: 'insert into MSC_ST_SUPPLIES'

Line 800: MSC_CL_PULL.v_view_name := 'MRP_AD_MPS_SUPPLIES_V';

796:
797: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
798:
799: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
800: MSC_CL_PULL.v_view_name := 'MRP_AD_MPS_SUPPLIES_V';
801:
802: v_sql_stmt:=
803: 'insert into MSC_ST_SUPPLIES'
804: ||' ( DISPOSITION_ID,'

Line 819: ||' from MRP_AD_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

815: ||' x.ORDER_TYPE,'
816: ||' 1,'
817: ||' :v_refresh_id,'
818: ||' :v_instance_id'
819: ||' from MRP_AD_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
820: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
821: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
822:
823: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

816: ||' 1,'
817: ||' :v_refresh_id,'
818: ||' :v_instance_id'
819: ||' from MRP_AD_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
820: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
821: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
822:
823: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
824:

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

819: ||' from MRP_AD_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
820: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
821: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
822:
823: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
824:
825: COMMIT;
826:
827: END IF;

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

825: COMMIT;
826:
827: END IF;
828:
829: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
830: MSC_CL_PULL.v_view_name := 'MRP_AP_MPS_SUPPLIES_V';
831:
832: v_sql_stmt:=
833: 'insert into MSC_ST_SUPPLIES'

Line 830: MSC_CL_PULL.v_view_name := 'MRP_AP_MPS_SUPPLIES_V';

826:
827: END IF;
828:
829: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
830: MSC_CL_PULL.v_view_name := 'MRP_AP_MPS_SUPPLIES_V';
831:
832: v_sql_stmt:=
833: 'insert into MSC_ST_SUPPLIES'
834: ||' ( DISPOSITION_ID,'

Line 878: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

874: ||' 2,'
875: ||' :v_refresh_id,'
876: ||' :v_instance_id,'
877: ||' x.schedule_origination_type '
878: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
879: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
880: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
881: ||' x.RN2>'||MSC_CL_PULL.v_lrn
882: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';

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

876: ||' :v_instance_id,'
877: ||' x.schedule_origination_type '
878: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
879: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
880: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
881: ||' x.RN2>'||MSC_CL_PULL.v_lrn
882: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
883: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
884:

Line 881: ||' x.RN2>'||MSC_CL_PULL.v_lrn

877: ||' x.schedule_origination_type '
878: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
879: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
880: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
881: ||' x.RN2>'||MSC_CL_PULL.v_lrn
882: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
883: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
884:
885: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

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

878: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
879: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
880: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
881: ||' x.RN2>'||MSC_CL_PULL.v_lrn
882: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
883: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
884:
885: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
886: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

879: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
880: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
881: ||' x.RN2>'||MSC_CL_PULL.v_lrn
882: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
883: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
884:
885: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
886: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
887:

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

881: ||' x.RN2>'||MSC_CL_PULL.v_lrn
882: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
883: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
884:
885: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
886: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
887:
888: COMMIT;
889:

Line 886: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

882: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
883: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
884:
885: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
886: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
887:
888: COMMIT;
889:
890: END IF; -- MSC_CL_PULL.MPS_ENABLED

Line 890: END IF; -- MSC_CL_PULL.MPS_ENABLED

886: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
887:
888: COMMIT;
889:
890: END IF; -- MSC_CL_PULL.MPS_ENABLED
891:
892: --VENDOR_ID, VENDOR_SITE_ID
893:
894: END LOAD_MPS_SUPPLY;

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

896:
897: PROCEDURE LOAD_USER_SUPPLY IS
898: BEGIN
899:
900: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
901: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
902:
903: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
904:

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

897: PROCEDURE LOAD_USER_SUPPLY IS
898: BEGIN
899:
900: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
901: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
902:
903: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
904:
905: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

899:
900: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
901: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
902:
903: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
904:
905: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
906: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
907:

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

901: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
902:
903: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
904:
905: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
906: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
907:
908: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
909: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

Line 906: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';

902:
903: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
904:
905: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
906: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
907:
908: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
909: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
910: ELSE

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

904:
905: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
906: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
907:
908: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
909: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
910: ELSE
911: v_temp_sql := NULL;
912: END IF;

Line 929: ||' FROM MRP_AD_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

925: ||' x.ORGANIZATION_ID,'
926: ||' 1,'
927: ||' :v_refresh_id,'
928: ||' :v_instance_id'
929: ||' FROM MRP_AD_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
930: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
931: || v_temp_sql;
932:
933: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

926: ||' 1,'
927: ||' :v_refresh_id,'
928: ||' :v_instance_id'
929: ||' FROM MRP_AD_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
930: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
931: || v_temp_sql;
932:
933: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
934:

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

929: ||' FROM MRP_AD_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
930: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
931: || v_temp_sql;
932:
933: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
934:
935: COMMIT;
936:
937: END IF;

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

935: COMMIT;
936:
937: END IF;
938:
939: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
940: MSC_CL_PULL.v_view_name := 'MRP_AP_USER_SUPPLIES_V';
941:
942: v_sql_stmt:=
943: ' INSERT INTO MSC_ST_SUPPLIES'

Line 940: MSC_CL_PULL.v_view_name := 'MRP_AP_USER_SUPPLIES_V';

936:
937: END IF;
938:
939: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
940: MSC_CL_PULL.v_view_name := 'MRP_AP_USER_SUPPLIES_V';
941:
942: v_sql_stmt:=
943: ' INSERT INTO MSC_ST_SUPPLIES'
944: ||'( DISPOSITION_ID,'

Line 970: ||' FROM MRP_AP_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'

966: ||' x.DEMAND_CLASS,'
967: ||' 2,'
968: ||' :v_refresh_id,'
969: ||' :v_instance_id'
970: ||' FROM MRP_AP_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
971: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
972: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
973: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
974:

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

968: ||' :v_refresh_id,'
969: ||' :v_instance_id'
970: ||' FROM MRP_AP_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
971: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
972: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
973: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
974:
975: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
976: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

969: ||' :v_instance_id'
970: ||' FROM MRP_AP_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
971: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
972: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
973: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
974:
975: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
976: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
977:

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

971: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
972: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
973: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
974:
975: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
976: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
977:
978: COMMIT;
979:

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

972: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
973: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
974:
975: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
976: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
977:
978: COMMIT;
979:
980: END IF;

Line 998: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN

994: BEGIN
995:
996: lv_task_start_time := sysdate;
997:
998: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
999: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1000: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1001:
1002: /* Added this code for VMI changes */

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

995:
996: lv_task_start_time := sysdate;
997:
998: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
999: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1000: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1001:
1002: /* Added this code for VMI changes */
1003: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

Line 1000: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';

996: lv_task_start_time := sysdate;
997:
998: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
999: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1000: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1001:
1002: /* Added this code for VMI changes */
1003: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1004: v_temp_sql := 'x.VMI_FLAG,x.PO_LINE_LOCATION_ID,x.PO_DISTRIBUTION_ID, ';

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

999: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1000: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1001:
1002: /* Added this code for VMI changes */
1003: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1004: v_temp_sql := 'x.VMI_FLAG,x.PO_LINE_LOCATION_ID,x.PO_DISTRIBUTION_ID, ';
1005: ELSE
1006: v_temp_sql := ' NULL,NULL,NULL, ';
1007: END IF;

Line 1010: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 6324690

1006: v_temp_sql := ' NULL,NULL,NULL, ';
1007: END IF;
1008:
1009: /* Added this code for SRP changes Bug 6324690 */
1010: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 6324690
1011: v_view_name := 'MRP_AP_PO_CSP_SUPPLY_V';
1012: v_order_type := 'x.order_type,';
1013: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1014: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';

Line 1013: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN

1009: /* Added this code for SRP changes Bug 6324690 */
1010: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 6324690
1011: v_view_name := 'MRP_AP_PO_CSP_SUPPLY_V';
1012: v_order_type := 'x.order_type,';
1013: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1014: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1015: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
1016: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
1017: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'

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

1021: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
1022: v_order_type := '1,';
1023: END IF;
1024:
1025: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1026: v_coll_order_type := ' x.ORDER_TYPE, ';
1027:
1028: ELSE
1029: v_coll_order_type := ' NULL ,';

Line 1142: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'

1138: ||' x.ACCEPTANCE_REQUIRED_FLAG,'
1139: ||' x.POSTPROCESSING_LEAD_TIME,'
1140: /* CP-ACK ends */
1141: ||' :v_instance_id'
1142: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1143: ||v_view_name||MSC_CL_PULL.v_dblink||' x'
1144: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1145: ||' AND mpp.project_id (+)= x.project_id'
1146: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'

Line 1143: ||v_view_name||MSC_CL_PULL.v_dblink||' x'

1139: ||' x.POSTPROCESSING_LEAD_TIME,'
1140: /* CP-ACK ends */
1141: ||' :v_instance_id'
1142: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1143: ||v_view_name||MSC_CL_PULL.v_dblink||' x'
1144: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1145: ||' AND mpp.project_id (+)= x.project_id'
1146: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
1147: ||' 1, x.MRP_TO_Organization_ID,'

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

1148: ||' x.Organization_ID)'
1149: ||' and DECODE( :v_mps_consume_profile_value,'
1150: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1151: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1152: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
1153: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1155:
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);

Line 1153: ||' x.RN2>'||MSC_CL_PULL.v_lrn

1149: ||' and DECODE( :v_mps_consume_profile_value,'
1150: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1151: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1152: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
1153: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1155:
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1157:

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

1150: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1151: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1152: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
1153: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1155:
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1157:
1158: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

Line 1158: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

1154: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1155:
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1157:
1158: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1159: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1160: MSC_CL_PULL.v_mps_consume_profile_value,
1161: MSC_CL_PULL.v_mps_consume_profile_value,
1162: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1159: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

1155:
1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1157:
1158: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1159: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1160: MSC_CL_PULL.v_mps_consume_profile_value,
1161: MSC_CL_PULL.v_mps_consume_profile_value,
1162: MSC_CL_PULL.v_mps_consume_profile_value,
1163: MSC_CL_PULL.v_dgmt,

Line 1160: MSC_CL_PULL.v_mps_consume_profile_value,

1156: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1157:
1158: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1159: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1160: MSC_CL_PULL.v_mps_consume_profile_value,
1161: MSC_CL_PULL.v_mps_consume_profile_value,
1162: MSC_CL_PULL.v_mps_consume_profile_value,
1163: MSC_CL_PULL.v_dgmt,
1164: MSC_CL_PULL.v_refresh_id,

Line 1161: MSC_CL_PULL.v_mps_consume_profile_value,

1157:
1158: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1159: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1160: MSC_CL_PULL.v_mps_consume_profile_value,
1161: MSC_CL_PULL.v_mps_consume_profile_value,
1162: MSC_CL_PULL.v_mps_consume_profile_value,
1163: MSC_CL_PULL.v_dgmt,
1164: MSC_CL_PULL.v_refresh_id,
1165: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,

Line 1162: MSC_CL_PULL.v_mps_consume_profile_value,

1158: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1159: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1160: MSC_CL_PULL.v_mps_consume_profile_value,
1161: MSC_CL_PULL.v_mps_consume_profile_value,
1162: MSC_CL_PULL.v_mps_consume_profile_value,
1163: MSC_CL_PULL.v_dgmt,
1164: MSC_CL_PULL.v_refresh_id,
1165: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1166: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,

Line 1163: MSC_CL_PULL.v_dgmt,

1159: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1160: MSC_CL_PULL.v_mps_consume_profile_value,
1161: MSC_CL_PULL.v_mps_consume_profile_value,
1162: MSC_CL_PULL.v_mps_consume_profile_value,
1163: MSC_CL_PULL.v_dgmt,
1164: MSC_CL_PULL.v_refresh_id,
1165: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1166: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1167: MSC_CL_PULL.v_instance_id,

Line 1164: MSC_CL_PULL.v_refresh_id,

1160: MSC_CL_PULL.v_mps_consume_profile_value,
1161: MSC_CL_PULL.v_mps_consume_profile_value,
1162: MSC_CL_PULL.v_mps_consume_profile_value,
1163: MSC_CL_PULL.v_dgmt,
1164: MSC_CL_PULL.v_refresh_id,
1165: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1166: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1167: MSC_CL_PULL.v_instance_id,
1168: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1167: MSC_CL_PULL.v_instance_id,

1163: MSC_CL_PULL.v_dgmt,
1164: MSC_CL_PULL.v_refresh_id,
1165: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1166: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1167: MSC_CL_PULL.v_instance_id,
1168: MSC_CL_PULL.v_mps_consume_profile_value,
1169: MSC_CL_PULL.v_mps_consume_profile_value;
1170:
1171: COMMIT;

Line 1168: MSC_CL_PULL.v_mps_consume_profile_value,

1164: MSC_CL_PULL.v_refresh_id,
1165: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1166: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1167: MSC_CL_PULL.v_instance_id,
1168: MSC_CL_PULL.v_mps_consume_profile_value,
1169: MSC_CL_PULL.v_mps_consume_profile_value;
1170:
1171: COMMIT;
1172:

Line 1169: MSC_CL_PULL.v_mps_consume_profile_value;

1165: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1166: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1167: MSC_CL_PULL.v_instance_id,
1168: MSC_CL_PULL.v_mps_consume_profile_value,
1169: MSC_CL_PULL.v_mps_consume_profile_value;
1170:
1171: COMMIT;
1172:
1173: END IF ;

Line 1185: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN

1181: BEGIN
1182:
1183: lv_task_start_time := sysdate;
1184:
1185: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
1186: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1187: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1188:
1189: /* Added this code for VMI changes */

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

1182:
1183: lv_task_start_time := sysdate;
1184:
1185: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
1186: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1187: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1188:
1189: /* Added this code for VMI changes */
1190: /*Begin

Line 1187: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';

1183: lv_task_start_time := sysdate;
1184:
1185: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
1186: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1187: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1188:
1189: /* Added this code for VMI changes */
1190: /*Begin
1191: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS120,'x.VMI_FLAG,',MSC_UTIL.G_APPS115,'x.VMI_FLAG,',' NULL, ')

Line 1191: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS120,'x.VMI_FLAG,',MSC_UTIL.G_APPS115,'x.VMI_FLAG,',' NULL, ')

1187: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1188:
1189: /* Added this code for VMI changes */
1190: /*Begin
1191: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS120,'x.VMI_FLAG,',MSC_UTIL.G_APPS115,'x.VMI_FLAG,',' NULL, ')
1192: into v_temp_sql
1193: from dual;
1194: End;*/
1195:

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

1192: into v_temp_sql
1193: from dual;
1194: End;*/
1195:
1196: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1197: v_temp_sql := ' x.VMI_FLAG, x.POSTPROCESSING_LEAD_TIME, ';
1198: ELSE
1199: v_temp_sql := ' NULL, NULL, ';
1200: END IF;

Line 1210: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- condition MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 changed to MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 for 8819580

1206: Order_type is 2.4 - Normal Ireq From Good Sub inv --- Cond Good
1207: Order_type is 2.5 - Normal Ireq From BAD Sub inv --- Cond Bad
1208: Order_type is 2 - Normal Ireq without any Subinv attached --- Cond N/A
1209: */
1210: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- condition MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 changed to MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 for 8819580
1211: v_temp_sql := v_temp_sql||' decode(x.order_type,2.2,73,2.3,87,2) , ';
1212: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1213: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1214: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

Line 1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN

1222: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1223: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1224: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1225: || '), ';
1226: /* ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1227: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1228: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1229: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1230: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '

Line 1321: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'

1317: /* CP change starts */
1318: ||' x.NEW_ORDER_PLACEMENT_DATE,'
1319: /* CP change starts */
1320: ||' :v_instance_id'
1321: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1322: ||' MRP_AP_PO_REQ_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
1323: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1324: ||' AND mpp.project_id (+)= x.project_id'
1325: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'

Line 1322: ||' MRP_AP_PO_REQ_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'

1318: ||' x.NEW_ORDER_PLACEMENT_DATE,'
1319: /* CP change starts */
1320: ||' :v_instance_id'
1321: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1322: ||' MRP_AP_PO_REQ_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
1323: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1324: ||' AND mpp.project_id (+)= x.project_id'
1325: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
1326: ||' 1, x.MRP_TO_Organization_ID,'

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

1327: ||' x.Organization_ID)'
1328: ||' and DECODE( :v_mps_consume_profile_value,'
1329: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1330: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1331: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
1332: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1333: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

Line 1332: ||' x.RN2>'||MSC_CL_PULL.v_lrn

1328: ||' and DECODE( :v_mps_consume_profile_value,'
1329: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1330: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1331: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
1332: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1333: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1336: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

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

1329: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1330: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1331: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
1332: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1333: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1336: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1337: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

1331: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
1332: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1333: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1336: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1337: MSC_CL_PULL.v_mps_consume_profile_value,
1338: MSC_CL_PULL.v_mps_consume_profile_value,
1339: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1336: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

1332: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1333: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1336: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1337: MSC_CL_PULL.v_mps_consume_profile_value,
1338: MSC_CL_PULL.v_mps_consume_profile_value,
1339: MSC_CL_PULL.v_mps_consume_profile_value,
1340: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 1337: MSC_CL_PULL.v_mps_consume_profile_value,

1333: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1336: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1337: MSC_CL_PULL.v_mps_consume_profile_value,
1338: MSC_CL_PULL.v_mps_consume_profile_value,
1339: MSC_CL_PULL.v_mps_consume_profile_value,
1340: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1341: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1338: MSC_CL_PULL.v_mps_consume_profile_value,

1334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1336: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1337: MSC_CL_PULL.v_mps_consume_profile_value,
1338: MSC_CL_PULL.v_mps_consume_profile_value,
1339: MSC_CL_PULL.v_mps_consume_profile_value,
1340: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1341: MSC_CL_PULL.v_mps_consume_profile_value,
1342: MSC_CL_PULL.v_mps_consume_profile_value;

Line 1339: MSC_CL_PULL.v_mps_consume_profile_value,

1335: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1336: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1337: MSC_CL_PULL.v_mps_consume_profile_value,
1338: MSC_CL_PULL.v_mps_consume_profile_value,
1339: MSC_CL_PULL.v_mps_consume_profile_value,
1340: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1341: MSC_CL_PULL.v_mps_consume_profile_value,
1342: MSC_CL_PULL.v_mps_consume_profile_value;
1343:

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

1336: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1337: MSC_CL_PULL.v_mps_consume_profile_value,
1338: MSC_CL_PULL.v_mps_consume_profile_value,
1339: MSC_CL_PULL.v_mps_consume_profile_value,
1340: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1341: MSC_CL_PULL.v_mps_consume_profile_value,
1342: MSC_CL_PULL.v_mps_consume_profile_value;
1343:
1344: COMMIT;

Line 1341: MSC_CL_PULL.v_mps_consume_profile_value,

1337: MSC_CL_PULL.v_mps_consume_profile_value,
1338: MSC_CL_PULL.v_mps_consume_profile_value,
1339: MSC_CL_PULL.v_mps_consume_profile_value,
1340: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1341: MSC_CL_PULL.v_mps_consume_profile_value,
1342: MSC_CL_PULL.v_mps_consume_profile_value;
1343:
1344: COMMIT;
1345:

Line 1342: MSC_CL_PULL.v_mps_consume_profile_value;

1338: MSC_CL_PULL.v_mps_consume_profile_value,
1339: MSC_CL_PULL.v_mps_consume_profile_value,
1340: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1341: MSC_CL_PULL.v_mps_consume_profile_value,
1342: MSC_CL_PULL.v_mps_consume_profile_value;
1343:
1344: COMMIT;
1345:
1346: END IF ;