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: /* Added this code for VMI changes */
77: Begin

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: /* Added this code for VMI changes */
77: Begin
78:

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

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

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

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

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

173: ||' x.INTRANSIT_OWNING_ORG_ID,'
174: ||' x.REQUISITION_LINE_ID,'
175: ||' :v_refresh_id,'
176: ||' :v_instance_id'
177: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
178: ||' 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,'

Line 178: ||' MRP_AP_PO_SHIP_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'

174: ||' x.REQUISITION_LINE_ID,'
175: ||' :v_refresh_id,'
176: ||' :v_instance_id'
177: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
178: ||' 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: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

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: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
312: v_temp_sql := 'x.VMI_FLAG,';

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

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: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
312: v_temp_sql := 'x.VMI_FLAG,';
313: ELSE
314: v_temp_sql := ' NULL, ';
315: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

Line 401: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

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

Line 402: MSC_CL_PULL.v_mps_consume_profile_value,

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

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

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

Line 404: MSC_CL_PULL.v_mps_consume_profile_value,

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

Line 405: MSC_CL_PULL.v_mps_consume_profile_value;

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

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

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

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

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

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

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

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

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

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

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

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

456: ||' 1, NVL(x.arrived_flag, 2), 2)= 2)'
457: ||' AND (x.RN2>'||MSC_CL_PULL.v_lrn||')';
458:
459:
460: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
461: MSC_CL_PULL.v_so_ship_arrive_value;
462:
463: COMMIT;
464:

Line 461: MSC_CL_PULL.v_so_ship_arrive_value;

457: ||' AND (x.RN2>'||MSC_CL_PULL.v_lrn||')';
458:
459:
460: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
461: MSC_CL_PULL.v_so_ship_arrive_value;
462:
463: COMMIT;
464:
465: END IF; -- MSC_CL_PULL.PO_ENABLED

Line 465: END IF; -- MSC_CL_PULL.PO_ENABLED

461: MSC_CL_PULL.v_so_ship_arrive_value;
462:
463: COMMIT;
464:
465: END IF; -- MSC_CL_PULL.PO_ENABLED
466:
467:
468: END LOAD_PO_SUPPLY;
469:

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

474:
475:
476: -- ====================== 6: On Hand ====================
477:
478: IF MSC_CL_PULL.OH_ENABLED= MSC_UTIL.SYS_YES THEN
479:
480: --=================== Net Change Mode: Delete ==================
481:
482: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

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

478: IF MSC_CL_PULL.OH_ENABLED= MSC_UTIL.SYS_YES THEN
479:
480: --=================== Net Change Mode: Delete ==================
481:
482: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
483:
484: -- delete
485: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
486: v_temp_sql := ' x.QUANTITY, x.PROJECT_ID,x.TASK_ID,x.END_ITEM_UNIT_NUMBER,

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

481:
482: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
483:
484: -- delete
485: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
486: v_temp_sql := ' x.QUANTITY, x.PROJECT_ID,x.TASK_ID,x.END_ITEM_UNIT_NUMBER,
487: decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
488: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
489: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),

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

496: NULL,
497: NULL, ';
498: END IF;
499:
500: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
501: MSC_CL_PULL.v_view_name := 'MRP_AD_ONHAND_SUPPLIES_V';
502:
503: v_sql_stmt:=
504: ' insert into MSC_ST_SUPPLIES'

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

497: NULL, ';
498: END IF;
499:
500: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
501: MSC_CL_PULL.v_view_name := 'MRP_AD_ONHAND_SUPPLIES_V';
502:
503: v_sql_stmt:=
504: ' insert into MSC_ST_SUPPLIES'
505: ||' ( INVENTORY_ITEM_ID,'

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

527: ||' 1,'
528: || v_temp_sql --for 11i sources
529: ||' :v_refresh_id,'
530: ||' :v_instance_id'
531: ||' from MRP_AD_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
532: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
533: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
534:
535: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

529: ||' :v_refresh_id,'
530: ||' :v_instance_id'
531: ||' from MRP_AD_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
532: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
533: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
534:
535: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
536:
537: COMMIT;

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

531: ||' from MRP_AD_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
532: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
533: ||' AND x.RN>'||MSC_CL_PULL.v_lrn;
534:
535: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
536:
537: COMMIT;
538:
539: -- insert/update

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

538:
539: -- insert/update
540:
541: /* Added this code for VMI changes */
542: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
543: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
544: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
545: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
546: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';

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

548: ELSE
549: v_temp_sql := ' NULL, NULL, NULL, NULL, ';
550: END IF;
551:
552: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
553:
554: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
555: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
556: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';

Line 554: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159

550: END IF;
551:
552: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
553:
554: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
555: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
556: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
557: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;
558:

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

551:
552: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
553:
554: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
555: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
556: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
557: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;
558:
559: ELSE

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

556: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
557: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;
558:
559: ELSE
560: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
561: v_temp_sql := v_temp_sql || ' NULL, NULL, NULL,';
562: end if;
563:
564:

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

604: ||' 2,'
605: || v_temp_sql
606: ||' :v_refresh_id,'
607: ||' :v_instance_id'
608: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x '
609: /*
610: ||' ( SELECT DISTINCT'
611: ||' inventory_item_id,'
612: ||' organization_id,'

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

611: ||' inventory_item_id,'
612: ||' organization_id,'
613: ||' subinventory_code,'
614: ||' lot_number'
615: ||' FROM MRP_AN_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink
616: ||' WHERE ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
617: ||' AND rn>'||MSC_CL_PULL.v_lrn||') a'
618: ||' WHERE a.inventory_item_id= x.inventory_item_id'
619: ||' AND a.organization_id= x.organization_id'

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

613: ||' subinventory_code,'
614: ||' lot_number'
615: ||' FROM MRP_AN_ONHAND_SUPPLIES_V'||MSC_CL_PULL.v_dblink
616: ||' WHERE ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
617: ||' AND rn>'||MSC_CL_PULL.v_lrn||') a'
618: ||' WHERE a.inventory_item_id= x.inventory_item_id'
619: ||' AND a.organization_id= x.organization_id'
620: ||' AND NVL(a.subinventory_code,'' '')= NVL( x.subinventory_code,'' '')'
621: ||' AND NVL(a.lot_number,'' '')= NVL( x.lot_number,'' '')';*/

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

619: ||' AND a.organization_id= x.organization_id'
620: ||' AND NVL(a.subinventory_code,'' '')= NVL( x.subinventory_code,'' '')'
621: ||' AND NVL(a.lot_number,'' '')= NVL( x.lot_number,'' '')';*/
622: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
623: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
624: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
625:
626: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
627:

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

620: ||' AND NVL(a.subinventory_code,'' '')= NVL( x.subinventory_code,'' '')'
621: ||' AND NVL(a.lot_number,'' '')= NVL( x.lot_number,'' '')';*/
622: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
623: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
624: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
625:
626: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
627:
628: COMMIT;

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

622: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
623: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
624: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
625:
626: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
627:
628: COMMIT;
629:
630: ELSE -- complete refresh

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

628: COMMIT;
629:
630: ELSE -- complete refresh
631:
632: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
633: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
634:
635: /* Added this code for VMI changes */
636: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

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

629:
630: ELSE -- complete refresh
631:
632: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
633: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
634:
635: /* Added this code for VMI changes */
636: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
637: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),

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

632: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
633: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
634:
635: /* Added this code for VMI changes */
636: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
637: v_temp_sql := ' decode(x.PLANNING_ORGANIZATION_ID, -1, NULL, x.PLANNING_ORGANIZATION_ID),
638: decode(x.PLANNING_TP_TYPE, -1, NULL, x.PLANNING_TP_TYPE),
639: decode(x.OWNING_ORGANIZATION_ID, -1, NULL, x.OWNING_ORGANIZATION_ID),
640: decode(x.OWNING_TP_TYPE, -1, NULL, x.OWNING_TP_TYPE), ';

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

643: v_temp_sql := ' NULL, NULL, NULL, NULL, ';
644: END IF;
645:
646:
647: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
648:
649: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
650: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
651: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';

Line 649: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159

645:
646:
647: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
648:
649: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
650: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
651: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
652: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;
653:

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

646:
647: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
648:
649: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 5684159
650: MSC_CL_PULL.v_view_name := 'MRP_AP1_ONHAND_SUPPLIES_V';
651: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
652: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;
653:
654: ELSE

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

651: v_Decode := ',DECODE(NVL(x.CONDITION_TYPE, '||''''||'G'||''''||'),'||''''||'G'||''''||', '||v_item_type_good||','||v_item_type_bad||'),';
652: v_temp_sql := v_temp_sql ||'x.SR_CUSTOMER_ACCT_ID,'||v_item_type_id ||v_Decode;
653:
654: ELSE
655: MSC_CL_PULL.v_view_name := 'MRP_AP_ONHAND_SUPPLIES_V';
656: v_temp_sql := v_temp_sql || ' NULL, NULL, NULL,';
657: end if;
658:
659:

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

699: ||' SYSDATE,'
700: ||' 2,'
701: ||' :v_refresh_id,'
702: ||' :v_instance_id'
703: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
704: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
705:
706: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
707:

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

702: ||' :v_instance_id'
703: ||' FROM '||MSC_CL_PULL.v_view_name||MSC_CL_PULL.v_dblink||' x'
704: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
705:
706: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
707:
708: COMMIT;
709:
710: END IF; -- incremental refresh

Line 712: END IF; -- MSC_CL_PULL.OH_ENABLED

708: COMMIT;
709:
710: END IF; -- incremental refresh
711:
712: END IF; -- MSC_CL_PULL.OH_ENABLED
713:
714: END LOAD_OH_SUPPLY;
715:
716:

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

719: BEGIN
720:
721: -- ====================== 8: MPS ====================
722:
723: IF MSC_CL_PULL.MPS_ENABLED= MSC_UTIL.SYS_YES THEN
724:
725: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
726:
727: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

721: -- ====================== 8: MPS ====================
722:
723: IF MSC_CL_PULL.MPS_ENABLED= MSC_UTIL.SYS_YES THEN
724:
725: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
726:
727: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
728: MSC_CL_PULL.v_view_name := 'MRP_AD_MPS_SUPPLIES_V';
729:

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

723: IF MSC_CL_PULL.MPS_ENABLED= MSC_UTIL.SYS_YES THEN
724:
725: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
726:
727: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
728: MSC_CL_PULL.v_view_name := 'MRP_AD_MPS_SUPPLIES_V';
729:
730: v_sql_stmt:=
731: 'insert into MSC_ST_SUPPLIES'

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

724:
725: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
726:
727: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
728: MSC_CL_PULL.v_view_name := 'MRP_AD_MPS_SUPPLIES_V';
729:
730: v_sql_stmt:=
731: 'insert into MSC_ST_SUPPLIES'
732: ||' ( DISPOSITION_ID,'

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

743: ||' x.ORDER_TYPE,'
744: ||' 1,'
745: ||' :v_refresh_id,'
746: ||' :v_instance_id'
747: ||' from MRP_AD_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
748: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
749: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
750:
751: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

744: ||' 1,'
745: ||' :v_refresh_id,'
746: ||' :v_instance_id'
747: ||' from MRP_AD_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
748: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
749: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
750:
751: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
752:

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

747: ||' from MRP_AD_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
748: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
749: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
750:
751: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
752:
753: COMMIT;
754:
755: END IF;

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

753: COMMIT;
754:
755: END IF;
756:
757: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
758: MSC_CL_PULL.v_view_name := 'MRP_AP_MPS_SUPPLIES_V';
759:
760: v_sql_stmt:=
761: 'insert into MSC_ST_SUPPLIES'

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

754:
755: END IF;
756:
757: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
758: MSC_CL_PULL.v_view_name := 'MRP_AP_MPS_SUPPLIES_V';
759:
760: v_sql_stmt:=
761: 'insert into MSC_ST_SUPPLIES'
762: ||' ( DISPOSITION_ID,'

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

802: ||' 2,'
803: ||' :v_refresh_id,'
804: ||' :v_instance_id,'
805: ||' x.schedule_origination_type '
806: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
807: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
808: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
809: ||' x.RN2>'||MSC_CL_PULL.v_lrn
810: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';

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

804: ||' :v_instance_id,'
805: ||' x.schedule_origination_type '
806: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
807: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
808: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
809: ||' x.RN2>'||MSC_CL_PULL.v_lrn
810: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
811: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
812:

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

805: ||' x.schedule_origination_type '
806: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
807: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
808: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
809: ||' x.RN2>'||MSC_CL_PULL.v_lrn
810: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
811: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
812:
813: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,

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

806: ||' from MRP_AP_MPS_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
807: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
808: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
809: ||' x.RN2>'||MSC_CL_PULL.v_lrn
810: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
811: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
812:
813: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
814: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

807: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
808: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
809: ||' x.RN2>'||MSC_CL_PULL.v_lrn
810: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
811: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
812:
813: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
814: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
815:

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

809: ||' x.RN2>'||MSC_CL_PULL.v_lrn
810: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
811: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
812:
813: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
814: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
815:
816: COMMIT;
817:

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

810: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
811: --||' OR x.RN4>'||MSC_CL_PULL.v_lrn||')';
812:
813: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_dgmt,
814: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
815:
816: COMMIT;
817:
818: END IF; -- MSC_CL_PULL.MPS_ENABLED

Line 818: END IF; -- MSC_CL_PULL.MPS_ENABLED

814: MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
815:
816: COMMIT;
817:
818: END IF; -- MSC_CL_PULL.MPS_ENABLED
819:
820: --VENDOR_ID, VENDOR_SITE_ID
821:
822: END LOAD_MPS_SUPPLY;

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

824:
825: PROCEDURE LOAD_USER_SUPPLY IS
826: BEGIN
827:
828: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
829: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
830:
831: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
832:

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

825: PROCEDURE LOAD_USER_SUPPLY IS
826: BEGIN
827:
828: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
829: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
830:
831: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
832:
833: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';

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

827:
828: IF MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
829: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
830:
831: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
832:
833: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
834: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
835:

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

829: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
830:
831: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
832:
833: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
834: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
835:
836: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
837: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

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

830:
831: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
832:
833: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
834: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
835:
836: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
837: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
838: ELSE

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

832:
833: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
834: MSC_CL_PULL.v_view_name := 'MRP_AD_USER_SUPPLIES_V';
835:
836: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
837: v_temp_sql := ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
838: ELSE
839: v_temp_sql := NULL;
840: END IF;

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

853: ||' x.ORGANIZATION_ID,'
854: ||' 1,'
855: ||' :v_refresh_id,'
856: ||' :v_instance_id'
857: ||' FROM MRP_AD_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
858: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
859: || v_temp_sql;
860:
861: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

854: ||' 1,'
855: ||' :v_refresh_id,'
856: ||' :v_instance_id'
857: ||' FROM MRP_AD_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
858: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
859: || v_temp_sql;
860:
861: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
862:

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

857: ||' FROM MRP_AD_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
858: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
859: || v_temp_sql;
860:
861: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
862:
863: COMMIT;
864:
865: END IF;

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

863: COMMIT;
864:
865: END IF;
866:
867: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
868: MSC_CL_PULL.v_view_name := 'MRP_AP_USER_SUPPLIES_V';
869:
870: v_sql_stmt:=
871: ' INSERT INTO MSC_ST_SUPPLIES'

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

864:
865: END IF;
866:
867: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
868: MSC_CL_PULL.v_view_name := 'MRP_AP_USER_SUPPLIES_V';
869:
870: v_sql_stmt:=
871: ' INSERT INTO MSC_ST_SUPPLIES'
872: ||'( DISPOSITION_ID,'

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

894: ||' x.DEMAND_CLASS,'
895: ||' 2,'
896: ||' :v_refresh_id,'
897: ||' :v_instance_id'
898: ||' FROM MRP_AP_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
899: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
900: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
901: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
902:

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

896: ||' :v_refresh_id,'
897: ||' :v_instance_id'
898: ||' FROM MRP_AP_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
899: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
900: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
901: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
902:
903: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
904: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

897: ||' :v_instance_id'
898: ||' FROM MRP_AP_USER_SUPPLIES_V'||MSC_CL_PULL.v_dblink||' x'
899: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
900: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
901: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
902:
903: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
904: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
905:

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

899: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
900: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
901: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
902:
903: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
904: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
905:
906: COMMIT;
907:

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

900: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
901: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
902:
903: --EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
904: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
905:
906: COMMIT;
907:
908: END IF;

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

920: BEGIN
921:
922: lv_task_start_time := sysdate;
923:
924: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
925: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
926: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
927:
928: /* Added this code for VMI changes */

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

921:
922: lv_task_start_time := sysdate;
923:
924: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
925: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
926: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
927:
928: /* Added this code for VMI changes */
929: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN

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

922: lv_task_start_time := sysdate;
923:
924: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
925: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
926: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
927:
928: /* Added this code for VMI changes */
929: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
930: v_temp_sql := 'x.VMI_FLAG,x.PO_LINE_LOCATION_ID,x.PO_DISTRIBUTION_ID, ';

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

925: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
926: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
927:
928: /* Added this code for VMI changes */
929: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
930: v_temp_sql := 'x.VMI_FLAG,x.PO_LINE_LOCATION_ID,x.PO_DISTRIBUTION_ID, ';
931: ELSE
932: v_temp_sql := ' NULL,NULL,NULL, ';
933: END IF;

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

932: v_temp_sql := ' NULL,NULL,NULL, ';
933: END IF;
934:
935: /* Added this code for SRP changes Bug 6324690 */
936: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 6324690
937: v_view_name := 'MRP_AP_PO_CSP_SUPPLY_V';
938: v_order_type := 'x.order_type,';
939: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
940: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';

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

935: /* Added this code for SRP changes Bug 6324690 */
936: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN -- SRP Changes Bug # 6324690
937: v_view_name := 'MRP_AP_PO_CSP_SUPPLY_V';
938: v_order_type := 'x.order_type,';
939: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
940: v_view_name := 'MRP_AP_PO_PO_SUPPLY_V';
941: v_order_type := ' decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'',''),'
942: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''','',''||x.VENDOR_ID||'')''),'
943: || '0,decode(INSTR('''||MSC_UTIL.v_ext_repair_sup_id_str||''',''(''||x.VENDOR_ID||'',''),'

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

1054: ||' x.ACCEPTANCE_REQUIRED_FLAG,'
1055: ||' x.POSTPROCESSING_LEAD_TIME,'
1056: /* CP-ACK ends */
1057: ||' :v_instance_id'
1058: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1059: ||v_view_name||MSC_CL_PULL.v_dblink||' x'
1060: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1061: ||' AND mpp.project_id (+)= x.project_id'
1062: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'

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

1055: ||' x.POSTPROCESSING_LEAD_TIME,'
1056: /* CP-ACK ends */
1057: ||' :v_instance_id'
1058: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1059: ||v_view_name||MSC_CL_PULL.v_dblink||' x'
1060: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1061: ||' AND mpp.project_id (+)= x.project_id'
1062: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
1063: ||' 1, x.MRP_TO_Organization_ID,'

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

1064: ||' x.Organization_ID)'
1065: ||' and DECODE( :v_mps_consume_profile_value,'
1066: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1067: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1068: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
1069: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1070: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1071:
1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);

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

1065: ||' and DECODE( :v_mps_consume_profile_value,'
1066: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1067: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1068: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
1069: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1070: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1071:
1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1073:

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

1066: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1067: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1068: ||' AND (' -- x.RN1>'||MSC_CL_PULL.v_lrn
1069: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1070: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1071:
1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1073:
1074: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

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

1070: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1071:
1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1073:
1074: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1075: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1076: MSC_CL_PULL.v_mps_consume_profile_value,
1077: MSC_CL_PULL.v_mps_consume_profile_value,
1078: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1075: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

1071:
1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1073:
1074: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1075: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1076: MSC_CL_PULL.v_mps_consume_profile_value,
1077: MSC_CL_PULL.v_mps_consume_profile_value,
1078: MSC_CL_PULL.v_mps_consume_profile_value,
1079: MSC_CL_PULL.v_dgmt,

Line 1076: MSC_CL_PULL.v_mps_consume_profile_value,

1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql :'||v_sql_stmt);
1073:
1074: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1075: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1076: MSC_CL_PULL.v_mps_consume_profile_value,
1077: MSC_CL_PULL.v_mps_consume_profile_value,
1078: MSC_CL_PULL.v_mps_consume_profile_value,
1079: MSC_CL_PULL.v_dgmt,
1080: MSC_CL_PULL.v_refresh_id,

Line 1077: MSC_CL_PULL.v_mps_consume_profile_value,

1073:
1074: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1075: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1076: MSC_CL_PULL.v_mps_consume_profile_value,
1077: MSC_CL_PULL.v_mps_consume_profile_value,
1078: MSC_CL_PULL.v_mps_consume_profile_value,
1079: MSC_CL_PULL.v_dgmt,
1080: MSC_CL_PULL.v_refresh_id,
1081: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,

Line 1078: MSC_CL_PULL.v_mps_consume_profile_value,

1074: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1075: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1076: MSC_CL_PULL.v_mps_consume_profile_value,
1077: MSC_CL_PULL.v_mps_consume_profile_value,
1078: MSC_CL_PULL.v_mps_consume_profile_value,
1079: MSC_CL_PULL.v_dgmt,
1080: MSC_CL_PULL.v_refresh_id,
1081: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1082: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,

Line 1079: MSC_CL_PULL.v_dgmt,

1075: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1076: MSC_CL_PULL.v_mps_consume_profile_value,
1077: MSC_CL_PULL.v_mps_consume_profile_value,
1078: MSC_CL_PULL.v_mps_consume_profile_value,
1079: MSC_CL_PULL.v_dgmt,
1080: MSC_CL_PULL.v_refresh_id,
1081: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1082: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1083: MSC_CL_PULL.v_instance_id,

Line 1080: MSC_CL_PULL.v_refresh_id,

1076: MSC_CL_PULL.v_mps_consume_profile_value,
1077: MSC_CL_PULL.v_mps_consume_profile_value,
1078: MSC_CL_PULL.v_mps_consume_profile_value,
1079: MSC_CL_PULL.v_dgmt,
1080: MSC_CL_PULL.v_refresh_id,
1081: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1082: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1083: MSC_CL_PULL.v_instance_id,
1084: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1083: MSC_CL_PULL.v_instance_id,

1079: MSC_CL_PULL.v_dgmt,
1080: MSC_CL_PULL.v_refresh_id,
1081: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1082: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1083: MSC_CL_PULL.v_instance_id,
1084: MSC_CL_PULL.v_mps_consume_profile_value,
1085: MSC_CL_PULL.v_mps_consume_profile_value;
1086:
1087: COMMIT;

Line 1084: MSC_CL_PULL.v_mps_consume_profile_value,

1080: MSC_CL_PULL.v_refresh_id,
1081: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1082: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1083: MSC_CL_PULL.v_instance_id,
1084: MSC_CL_PULL.v_mps_consume_profile_value,
1085: MSC_CL_PULL.v_mps_consume_profile_value;
1086:
1087: COMMIT;
1088:

Line 1085: MSC_CL_PULL.v_mps_consume_profile_value;

1081: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1082: MSC_UTIL.G_MSC_CONFIGURATION, MSC_UTIL.G_CONF_APS,
1083: MSC_CL_PULL.v_instance_id,
1084: MSC_CL_PULL.v_mps_consume_profile_value,
1085: MSC_CL_PULL.v_mps_consume_profile_value;
1086:
1087: COMMIT;
1088:
1089: END IF ;

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

1097: BEGIN
1098:
1099: lv_task_start_time := sysdate;
1100:
1101: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
1102: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1103: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1104:
1105: /* Added this code for VMI changes */

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

1098:
1099: lv_task_start_time := sysdate;
1100:
1101: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
1102: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1103: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1104:
1105: /* Added this code for VMI changes */
1106: /*Begin

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

1099: lv_task_start_time := sysdate;
1100:
1101: IF MSC_CL_PULL.PO_ENABLED= MSC_UTIL.SYS_YES THEN
1102: MSC_CL_PULL.v_table_name:= 'MSC_ST_SUPPLIES';
1103: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1104:
1105: /* Added this code for VMI changes */
1106: /*Begin
1107: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS120,'x.VMI_FLAG,',MSC_UTIL.G_APPS115,'x.VMI_FLAG,',' NULL, ')

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

1103: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_REQ_SUPPLY_V';
1104:
1105: /* Added this code for VMI changes */
1106: /*Begin
1107: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS120,'x.VMI_FLAG,',MSC_UTIL.G_APPS115,'x.VMI_FLAG,',' NULL, ')
1108: into v_temp_sql
1109: from dual;
1110: End;*/
1111:

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

1108: into v_temp_sql
1109: from dual;
1110: End;*/
1111:
1112: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1113: v_temp_sql := ' x.VMI_FLAG, x.POSTPROCESSING_LEAD_TIME, ';
1114: ELSE
1115: v_temp_sql := ' NULL, NULL, ';
1116: END IF;

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

1122: Order_type is 2.4 - Normal Ireq From Good Sub inv --- Cond Good
1123: Order_type is 2.5 - Normal Ireq From BAD Sub inv --- Cond Bad
1124: Order_type is 2 - Normal Ireq without any Subinv attached --- Cond N/A
1125: */
1126: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1127: v_temp_sql := v_temp_sql||' decode(x.order_type,2.2,73,2.3,87,2) , ';
1128: v_temp_sql := v_temp_sql ||' decode(x.order_type,
1129: 2.1,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID
1130: ||',2.2,'||MSC_UTIL.G_PARTCONDN_ITEMTYPEID

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

1138: ||',2.3,'||MSC_UTIL.G_PARTCONDN_GOOD
1139: ||',2.4,'||MSC_UTIL.G_PARTCONDN_GOOD
1140: ||',2.5,'||MSC_UTIL.G_PARTCONDN_BAD
1141: || '), ';
1142: ELSIF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA='Y') THEN
1143: v_temp_sql := v_temp_sql||' decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'',''),'
1144: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''','',''||x.FROM_ORGANIZATION_ID||'')''), '
1145: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'',''), '
1146: || '0,decode(INSTR('''||MSC_UTIL.v_depot_org_str||''',''(''||x.FROM_ORGANIZATION_ID||'')''), '

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

1233: /* CP change starts */
1234: ||' x.NEW_ORDER_PLACEMENT_DATE,'
1235: /* CP change starts */
1236: ||' :v_instance_id'
1237: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1238: ||' MRP_AP_PO_REQ_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
1239: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1240: ||' AND mpp.project_id (+)= x.project_id'
1241: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'

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

1234: ||' x.NEW_ORDER_PLACEMENT_DATE,'
1235: /* CP change starts */
1236: ||' :v_instance_id'
1237: ||' from PJM_PROJECT_PARAMETERS'||MSC_CL_PULL.v_dblink||' mpp,'
1238: ||' MRP_AP_PO_REQ_SUPPLY_V'||MSC_CL_PULL.v_dblink||' x'
1239: ||' where x.TO_ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1240: ||' AND mpp.project_id (+)= x.project_id'
1241: ||' and mpp.organization_id (+)= DECODE( :v_mps_consume_profile_value,'
1242: ||' 1, x.MRP_TO_Organization_ID,'

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

1243: ||' x.Organization_ID)'
1244: ||' and DECODE( :v_mps_consume_profile_value,'
1245: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1246: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1247: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
1248: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1249: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1251: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,

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

1244: ||' and DECODE( :v_mps_consume_profile_value,'
1245: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1246: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1247: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
1248: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1249: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1251: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1252: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

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

1245: ||' 1, x.MRP_DESTINATION_TYPE_CODE,'
1246: ||' x.DESTINATION_TYPE_CODE)= ''INVENTORY'''
1247: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
1248: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1249: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1251: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1252: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1253: MSC_CL_PULL.v_mps_consume_profile_value,

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

1247: ||' AND (' --x.RN1>'||MSC_CL_PULL.v_lrn
1248: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1249: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1251: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1252: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1253: MSC_CL_PULL.v_mps_consume_profile_value,
1254: MSC_CL_PULL.v_mps_consume_profile_value,
1255: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1252: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,

1248: ||' x.RN2>'||MSC_CL_PULL.v_lrn
1249: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1251: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1252: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1253: MSC_CL_PULL.v_mps_consume_profile_value,
1254: MSC_CL_PULL.v_mps_consume_profile_value,
1255: MSC_CL_PULL.v_mps_consume_profile_value,
1256: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,

Line 1253: MSC_CL_PULL.v_mps_consume_profile_value,

1249: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1251: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1252: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1253: MSC_CL_PULL.v_mps_consume_profile_value,
1254: MSC_CL_PULL.v_mps_consume_profile_value,
1255: MSC_CL_PULL.v_mps_consume_profile_value,
1256: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1257: MSC_CL_PULL.v_mps_consume_profile_value,

Line 1254: MSC_CL_PULL.v_mps_consume_profile_value,

1250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Test Sql PO_REC INSERT :'||v_sql_stmt);
1251: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1252: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1253: MSC_CL_PULL.v_mps_consume_profile_value,
1254: MSC_CL_PULL.v_mps_consume_profile_value,
1255: MSC_CL_PULL.v_mps_consume_profile_value,
1256: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1257: MSC_CL_PULL.v_mps_consume_profile_value,
1258: MSC_CL_PULL.v_mps_consume_profile_value;

Line 1255: MSC_CL_PULL.v_mps_consume_profile_value,

1251: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_instance_id,
1252: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1253: MSC_CL_PULL.v_mps_consume_profile_value,
1254: MSC_CL_PULL.v_mps_consume_profile_value,
1255: MSC_CL_PULL.v_mps_consume_profile_value,
1256: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1257: MSC_CL_PULL.v_mps_consume_profile_value,
1258: MSC_CL_PULL.v_mps_consume_profile_value;
1259:

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

1252: MSC_CL_PULL.v_mps_consume_profile_value, MSC_CL_PULL.v_dgmt,
1253: MSC_CL_PULL.v_mps_consume_profile_value,
1254: MSC_CL_PULL.v_mps_consume_profile_value,
1255: MSC_CL_PULL.v_mps_consume_profile_value,
1256: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1257: MSC_CL_PULL.v_mps_consume_profile_value,
1258: MSC_CL_PULL.v_mps_consume_profile_value;
1259:
1260: COMMIT;

Line 1257: MSC_CL_PULL.v_mps_consume_profile_value,

1253: MSC_CL_PULL.v_mps_consume_profile_value,
1254: MSC_CL_PULL.v_mps_consume_profile_value,
1255: MSC_CL_PULL.v_mps_consume_profile_value,
1256: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1257: MSC_CL_PULL.v_mps_consume_profile_value,
1258: MSC_CL_PULL.v_mps_consume_profile_value;
1259:
1260: COMMIT;
1261:

Line 1258: MSC_CL_PULL.v_mps_consume_profile_value;

1254: MSC_CL_PULL.v_mps_consume_profile_value,
1255: MSC_CL_PULL.v_mps_consume_profile_value,
1256: MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,
1257: MSC_CL_PULL.v_mps_consume_profile_value,
1258: MSC_CL_PULL.v_mps_consume_profile_value;
1259:
1260: COMMIT;
1261:
1262: END IF ;