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_ITEM_PULL dependencies on MSC_UTIL

Line 16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;

12: v_temp_sql3 VARCHAR2(32767);
13: v_temp_sql4 VARCHAR2(32767);
14:
15: -- NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
16: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
17:
18: v_gmp_routine_name VARCHAR2(50);
19: v_maxnum_of_orgstr NUMBER := NVL(FND_PROFILE.VALUE('MSC_MAXNUM_FOR_ORGSTR'),500); -- Default num of org is 500
20:

Line 29: IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN

25:
26: PROCEDURE LOAD_CATEGORY IS
27: BEGIN
28:
29: IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN
30:
31: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
32: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_CATEGORIES';
33: MSC_CL_PULL.v_view_name := 'MRP_AD_ITEM_CATEGORIES_V';

Line 77: ||' substrb(x.CATEGORY_NAME,1,'||MSC_UTIL.G_ITEMCAT_LEN||'),' --10436070

73: ||' x.INVENTORY_ITEM_ID,'
74: ||' x.ORGANIZATION_ID,'
75: ||' x.CATEGORY_SET_ID,'
76: ||' x.CATEGORY_ID,'
77: ||' substrb(x.CATEGORY_NAME,1,'||MSC_UTIL.G_ITEMCAT_LEN||'),' --10436070
78: ||' x.DESCRIPTION,'
79: ||' x.DISABLE_DATE- :v_dgmt,'
80: ||' x.SUMMARY_FLAG,'
81: ||' x.ENABLED_FLAG,'

Line 88: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

84: ||' 2,'
85: ||' :v_refresh_id,'
86: ||' :v_instance_id'
87: ||' from MRP_AP_ITEM_CATEGORIES_V'||MSC_CL_PULL.v_dblink||' x'
88: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
89: --||' AND NVL(x.LANGUAGE, :v_lang)= :v_lang'
90: ||' AND ( x.RN2>'||MSC_CL_PULL.v_lrn||')';
91:
92: /*

Line 110: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

106: ||' 2,'
107: ||' :v_refresh_id,'
108: ||' :v_instance_id'
109: ||' from MRP_AP_ITEM_CATEGORIES_V'||MSC_CL_PULL.v_dblink||' x'
110: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
111: ||' AND NVL(x.LANGUAGE, :v_lang)= :v_lang'
112: ||' AND ( x.RN3>'||MSC_CL_PULL.v_lrn||')'
113: ||' UNION '
114: ||' select'

Line 130: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

126: ||' 2,'
127: ||' :v_refresh_id,'
128: ||' :v_instance_id'
129: ||' from MRP_AP_ITEM_CATEGORIES_V'||MSC_CL_PULL.v_dblink||' x'
130: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
131: ||' AND NVL(x.LANGUAGE, :v_lang)= :v_lang'
132: ||' AND ( x.RN4>'||MSC_CL_PULL.v_lrn||')' ;
133: */
134: ELSE

Line 167: ||' substrb(x.CATEGORY_NAME,1,'||MSC_UTIL.G_ITEMCAT_LEN||'),' --10436070

163: ||' x.INVENTORY_ITEM_ID,'
164: ||' x.ORGANIZATION_ID,'
165: ||' x.CATEGORY_SET_ID,'
166: ||' x.CATEGORY_ID,'
167: ||' substrb(x.CATEGORY_NAME,1,'||MSC_UTIL.G_ITEMCAT_LEN||'),' --10436070
168: ||' x.DESCRIPTION,'
169: ||' x.DISABLE_DATE- :v_dgmt,'
170: ||' x.SUMMARY_FLAG,'
171: ||' x.ENABLED_FLAG,'

Line 178: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

174: ||' 2,'
175: ||' :v_refresh_id,'
176: ||' :v_instance_id'
177: ||' from MRP_AP_ITEM_CATEGORIES_V'||MSC_CL_PULL.v_dblink||' x'
178: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
179: -- bug 4365337 remove lang cond ||' AND NVL(x.LANGUAGE, :v_lang)= :v_lang'
180: --bug 4365337 remove v_union_sql and instead add cond. on RN2
181: || v_union_sql ;
182: --||' AND x.RN2 >'||MSC_CL_PULL.v_lrn;

Line 265: p_worker_num, MSC_UTIL.SYS_YES,

261:
262: cursor org IS
263: select /*+ INDEX(MSC_INSTANCE_ORGS MSC_INSTANCE_ORGS_U1) */ organization_id org_id,
264: DECODE( MOD(rownum,MSC_CL_PULL.TOTAL_IWN),
265: p_worker_num, MSC_UTIL.SYS_YES,
266: MSC_UTIL.SYS_NO) yes_flag
267: from msc_instance_orgs
268: where sr_instance_id= MSC_CL_PULL.v_instance_id
269: and enabled_flag= 1

Line 266: MSC_UTIL.SYS_NO) yes_flag

262: cursor org IS
263: select /*+ INDEX(MSC_INSTANCE_ORGS MSC_INSTANCE_ORGS_U1) */ organization_id org_id,
264: DECODE( MOD(rownum,MSC_CL_PULL.TOTAL_IWN),
265: p_worker_num, MSC_UTIL.SYS_YES,
266: MSC_UTIL.SYS_NO) yes_flag
267: from msc_instance_orgs
268: where sr_instance_id= MSC_CL_PULL.v_instance_id
269: and enabled_flag= 1
270: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group))

Line 270: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group))

266: MSC_UTIL.SYS_NO) yes_flag
267: from msc_instance_orgs
268: where sr_instance_id= MSC_CL_PULL.v_instance_id
269: and enabled_flag= 1
270: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group))
271: order by
272: organization_id;
273:
274: lv_org_count NUMBER:=0;

Line 278: IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN

274: lv_org_count NUMBER:=0;
275:
276: BEGIN
277:
278: IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN
279:
280: select count(mio.organization_id)
281: into lv_org_count
282: from msc_instance_orgs mio,

Line 287: and (( mcp.org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or

283: msc_coll_parameters mcp
284: where mio.sr_instance_id= MSC_CL_PULL.v_instance_id
285: and mcp.instance_id = MSC_CL_PULL.v_instance_id
286: and mio.enabled_flag= 1
287: and (( mcp.org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or
288: (mio.org_group=mcp.org_group));
289:
290: if (lv_org_count > v_maxnum_of_orgstr) then
291: lv_in_org_str := ' IN (select a.organization_id '

Line 299: || MSC_UTIL.G_ALL_ORGANIZATIONS

295: || ' where sr_instance_id= ' || MSC_CL_PULL.v_instance_id
296: || ' and enabled_flag= 1 '
297: || ' and (('''
298: || MSC_CL_PULL.v_org_group ||''' = '''
299: || MSC_UTIL.G_ALL_ORGANIZATIONS
300: ||''' ) or (org_group = '''|| MSC_CL_PULL.v_org_group
301: ||''' ))) a '
302: ||' where mod(seqnum,' || MSC_CL_PULL.TOTAL_IWN ||') = '
303: || p_worker_num

Line 306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Item Org String : '||lv_in_org_str);

302: ||' where mod(seqnum,' || MSC_CL_PULL.TOTAL_IWN ||') = '
303: || p_worker_num
304: || ')' ;
305:
306: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Item Org String : '||lv_in_org_str);
307:
308: else
309: lv_org_count :=0; -- reset Org Count
310: FOR lc_ins_org IN org LOOP

Line 312: IF lc_ins_org.yes_flag = MSC_UTIL.SYS_YES THEN

308: else
309: lv_org_count :=0; -- reset Org Count
310: FOR lc_ins_org IN org LOOP
311:
312: IF lc_ins_org.yes_flag = MSC_UTIL.SYS_YES THEN
313: lv_org_count := lv_org_count + 1;
314:
315: IF lv_org_count = 1 THEN
316: lv_in_org_str:=' IN ('|| lc_ins_org.org_id;

Line 332: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then

328: END IF;
329: end if; -- For Huge Number of Org
330: MSC_CL_PULL.v_table_name:= 'MSC_ST_SYSTEM_ITEMS';
331:
332: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then
333: MSC_CL_PULL.v_view_name := 'MRP_AP_NOCOST_SYSTEM_ITEMS_V';
334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);
335: else
336: MSC_CL_PULL.v_view_name := 'MRP_AP_SYSTEM_ITEMS_V';

Line 334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);

330: MSC_CL_PULL.v_table_name:= 'MSC_ST_SYSTEM_ITEMS';
331:
332: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then
333: MSC_CL_PULL.v_view_name := 'MRP_AP_NOCOST_SYSTEM_ITEMS_V';
334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);
335: else
336: MSC_CL_PULL.v_view_name := 'MRP_AP_SYSTEM_ITEMS_V';
337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);
338: end if;

Line 337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);

333: MSC_CL_PULL.v_view_name := 'MRP_AP_NOCOST_SYSTEM_ITEMS_V';
334: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);
335: else
336: MSC_CL_PULL.v_view_name := 'MRP_AP_SYSTEM_ITEMS_V';
337: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : View name = ' || MSC_CL_PULL.v_view_name);
338: end if;
339:
340: BEGIN
341:

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

338: end if;
339:
340: BEGIN
341:
342: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN
343:
344: v_temp_sql := 'NULL, NULL, NULL, NULL, NULL, x.DESCRIPTION, x.LIST_PRICE ,x.ITEM_NAME, '
345: ||'NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,'
346: ||' NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL,NULL,NULL,NULL, NULL,NULL,'; /* ds change added null*/

Line 348: ELSIF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110 THEN

344: v_temp_sql := 'NULL, NULL, NULL, NULL, NULL, x.DESCRIPTION, x.LIST_PRICE ,x.ITEM_NAME, '
345: ||'NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,'
346: ||' NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL,NULL,NULL,NULL, NULL,NULL,'; /* ds change added null*/
347:
348: ELSIF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS110 THEN
349:
350: v_temp_sql := 'x.REPLENISH_TO_ORDER_FLAG,x.PICK_COMPONENTS_FLAG ,NULL, NULL,NULL, '
351: ||' x.DESCRIPTION, x.LIST_PRICE , x.ITEM_NAME, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, '
352: ||' NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL,NULL,NULL, NULL, NULL,NULL,'; /* ds change added null for eam_item_type*/

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

350: v_temp_sql := 'x.REPLENISH_TO_ORDER_FLAG,x.PICK_COMPONENTS_FLAG ,NULL, NULL,NULL, '
351: ||' x.DESCRIPTION, x.LIST_PRICE , x.ITEM_NAME, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL, '
352: ||' NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL,NULL,NULL, NULL, NULL,NULL,'; /* ds change added null for eam_item_type*/
353:
354: ELSIF (MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS115) THEN
355:
356: v_temp_sql := ' x.REPLENISH_TO_ORDER_FLAG, x.PICK_COMPONENTS_FLAG ,';
357:
358: BEGIN

Line 373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug Message - Base uom code : '||lv_uom_code);

369: WHEN OTHERS THEN
370: lv_uom_code := NULL;
371: v_temp_sql := v_temp_sql || ' -99999, ';
372: END ;
373: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug Message - Base uom code : '||lv_uom_code);
374:
375:
376: v_temp_sql := v_temp_sql || ' x.CREATE_SUPPLY_FLAG,x.SUBSTITUTION_WINDOW, ';
377:

Line 391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');

387:
388: EXCEPTION
389: WHEN NO_DATA_FOUND THEN
390: -- This means that the base installed lang is different than the userenv(LANG)
391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');
392: lv_base_lang_diff := 2;
393: WHEN OTHERS THEN
394: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');
395: lv_base_lang_diff := 1;

Line 394: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');

390: -- This means that the base installed lang is different than the userenv(LANG)
391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');
392: lv_base_lang_diff := 2;
393: WHEN OTHERS THEN
394: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');
395: lv_base_lang_diff := 1;
396: END ;
397:
398: IF (lv_base_lang_diff = 1) THEN

Line 416: select instance_code, DECODE(A2M_DBLINK, NULL, MSC_UTIL.NULL_DBLINK, A2M_DBLINK)

412: BEGIN
413: -- check if the base language is different than the installed lang in source instance
414: -- If the base installed_flag is same as userenv lang- then dont go to TL table
415:
416: select instance_code, DECODE(A2M_DBLINK, NULL, MSC_UTIL.NULL_DBLINK, A2M_DBLINK)
417: into lv_icode, v_dblink_a2m
418: from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;
419:
420: v_sql_stmt := ' select item_name_from_kfv '

Line 424: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';

420: v_sql_stmt := ' select item_name_from_kfv '
421: ||' from MRP_AP_APPS_INSTANCES_ALL'||MSC_CL_PULL.v_dblink
422: ||' WHERE INSTANCE_ID = '||MSC_CL_PULL.v_instance_id
423: ||' AND INSTANCE_CODE= '''||lv_icode||''''
424: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';
425:
426: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);
427:
428: execute immediate v_sql_stmt into lv_item_name;

Line 426: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);

422: ||' WHERE INSTANCE_ID = '||MSC_CL_PULL.v_instance_id
423: ||' AND INSTANCE_CODE= '''||lv_icode||''''
424: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';
425:
426: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);
427:
428: execute immediate v_sql_stmt into lv_item_name;
429:
430: EXCEPTION

Line 432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);

428: execute immediate v_sql_stmt into lv_item_name;
429:
430: EXCEPTION
431: WHEN OTHERS THEN
432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);
433: lv_item_name := 'x.SEGMENT1';
434: END ;
435:
436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);

Line 436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);

432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);
433: lv_item_name := 'x.SEGMENT1';
434: END ;
435:
436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);
437: v_temp_sql := v_temp_sql ||' '|| lv_item_name ||', ';
438:
439: -- for Bugfix 3057925
440: v_temp_sql := v_temp_sql ||' x.REDUCE_MPS,x.CRITICAL_COMPONENT_FLAG,x.VMI_MINIMUM_UNITS,x.VMI_MINIMUM_DAYS,x.VMI_MAXIMUM_UNITS, '

Line 450: ELSIF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN --# For Bug 5606037 SRP Changes

446:
447:
448: /* # For Bug 5606037 SRP Changes NULL Colums to collect Item Attribute Data */
449:
450: ELSIF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 THEN --# For Bug 5606037 SRP Changes
451:
452: v_temp_sql := ' x.REPLENISH_TO_ORDER_FLAG, x.PICK_COMPONENTS_FLAG ,';
453:
454: BEGIN

Line 469: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug Message - Base uom code : '||lv_uom_code);

465: WHEN OTHERS THEN
466: lv_uom_code := NULL;
467: v_temp_sql := v_temp_sql || ' -99999, ';
468: END ;
469: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug Message - Base uom code : '||lv_uom_code);
470: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt of MSC_UTIL.G_APPS120 - ' || v_sql_stmt);
471:
472: v_temp_sql := v_temp_sql || ' x.CREATE_SUPPLY_FLAG,x.SUBSTITUTION_WINDOW, ';
473:

Line 470: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt of MSC_UTIL.G_APPS120 - ' || v_sql_stmt);

466: lv_uom_code := NULL;
467: v_temp_sql := v_temp_sql || ' -99999, ';
468: END ;
469: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug Message - Base uom code : '||lv_uom_code);
470: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt of MSC_UTIL.G_APPS120 - ' || v_sql_stmt);
471:
472: v_temp_sql := v_temp_sql || ' x.CREATE_SUPPLY_FLAG,x.SUBSTITUTION_WINDOW, ';
473:
474: BEGIN

Line 487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');

483:
484: EXCEPTION
485: WHEN NO_DATA_FOUND THEN
486: -- This means that the base installed lang is different than the userenv(LANG)
487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');
488: lv_base_lang_diff := 2;
489: WHEN OTHERS THEN
490: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');
491: lv_base_lang_diff := 1;

Line 490: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');

486: -- This means that the base installed lang is different than the userenv(LANG)
487: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Source Environment Language is different then Base Installed Language');
488: lv_base_lang_diff := 2;
489: WHEN OTHERS THEN
490: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Unhandled Exception when trying to identify Base Installed Language');
491: lv_base_lang_diff := 1;
492: END ;
493:
494: IF (lv_base_lang_diff = 1) THEN

Line 512: select instance_code, DECODE(A2M_DBLINK, NULL, MSC_UTIL.NULL_DBLINK, A2M_DBLINK)

508: BEGIN
509: -- check if the base language is different than the installed lang in source instance
510: -- If the base installed_flag is same as userenv lang- then dont go to TL table
511:
512: select instance_code, DECODE(A2M_DBLINK, NULL, MSC_UTIL.NULL_DBLINK, A2M_DBLINK)
513: into lv_icode, v_dblink_a2m
514: from msc_apps_instances where instance_id = MSC_CL_PULL.v_instance_id;
515:
516: v_sql_stmt := ' select item_name_from_kfv '

Line 520: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';

516: v_sql_stmt := ' select item_name_from_kfv '
517: ||' from MRP_AP_APPS_INSTANCES_ALL'||MSC_CL_PULL.v_dblink
518: ||' WHERE INSTANCE_ID = '||MSC_CL_PULL.v_instance_id
519: ||' AND INSTANCE_CODE= '''||lv_icode||''''
520: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';
521:
522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);
523:
524: execute immediate v_sql_stmt into lv_item_name;

Line 522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);

518: ||' WHERE INSTANCE_ID = '||MSC_CL_PULL.v_instance_id
519: ||' AND INSTANCE_CODE= '''||lv_icode||''''
520: ||' AND nvl(A2M_DBLINK,'||''''||MSC_UTIL.NULL_DBLINK ||''''||') = '''||v_dblink_a2m||'''';
521:
522: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'item kfv v_sql_stmt - ' || v_sql_stmt);
523:
524: execute immediate v_sql_stmt into lv_item_name;
525:
526: EXCEPTION

Line 528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);

524: execute immediate v_sql_stmt into lv_item_name;
525:
526: EXCEPTION
527: WHEN OTHERS THEN
528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);
529: lv_item_name := 'x.SEGMENT1';
530: END ;
531:
532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);

Line 532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);

528: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Error in deriving item_name kfv...setting to segment1 - ' || sqlerrm);
529: lv_item_name := 'x.SEGMENT1';
530: END ;
531:
532: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: Item Name String: '|| lv_item_name);
533: v_temp_sql := v_temp_sql ||' '|| lv_item_name ||', ';
534:
535: -- for Bugfix 3057925
536: v_temp_sql := v_temp_sql ||' x.REDUCE_MPS,x.CRITICAL_COMPONENT_FLAG,x.VMI_MINIMUM_UNITS,x.VMI_MINIMUM_DAYS,x.VMI_MAXIMUM_UNITS, '

Line 543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: v_temp_sql String: '|| v_temp_sql);

539: ||' x.DAYS_MAX_INV_SUPPLY,x.DAYS_MAX_INV_WINDOW,x.DRP_PLANNED_FLAG,x.CONTINOUS_TRANSFER,x.CONVERGENCE,x.DIVERGENCE,'
540: ||' x.EAM_ITEM_TYPE, x.MSIB_CREATION_DATE, x.SHORTAGE_TYPE , x.EXCESS_TYPE ,x.PLANNING_TIME_FENCE_CODE,x.REPAIR_LEADTIME,x.preposition_point,x.REPAIR_YIELD,x.repair_program,'; /* ds change eam_item_type added */
541: --# For Bug 5606037 SRP Changes
542:
543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug: v_temp_sql String: '|| v_temp_sql);
544: END IF; --# For Bug 5606037 SRP Changes
545:
546: End;
547:

Line 549: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then

545:
546: End;
547:
548:
549: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then
550: lv_view_name_stmt := ' from MRP_AP_NOCOST_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';
551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);
552: else
553: lv_view_name_stmt := ' from MRP_AP_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';

Line 551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);

547:
548:
549: if (MSC_CL_PULL.G_COLLECT_ITEM_COSTS = 'N') and (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115) then
550: lv_view_name_stmt := ' from MRP_AP_NOCOST_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';
551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);
552: else
553: lv_view_name_stmt := ' from MRP_AP_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';
554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);
555: end if;

Line 554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);

550: lv_view_name_stmt := ' from MRP_AP_NOCOST_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';
551: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);
552: else
553: lv_view_name_stmt := ' from MRP_AP_SYSTEM_ITEMS_V'||MSC_CL_PULL.v_dblink||' x';
554: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Debug : lv_view_name_stmt = ' || lv_view_name_stmt);
555: end if;
556:
557:
558:

Line 701: ||' substrb(x.CATEGORY_NAME,1,'||MSC_UTIL.G_ITEMCAT_LEN||'),' --10436070

697: ||' x.DEMAND_TIME_FENCE_DAYS,'
698: ||' x.ABC_CLASS_ID,'
699: ||' x.ABC_CLASS_NAME,'
700: ||' x.CATEGORY_ID,'
701: ||' substrb(x.CATEGORY_NAME,1,'||MSC_UTIL.G_ITEMCAT_LEN||'),' --10436070
702: ||' x.MRP_PLANNING_CODE,'
703: ||' x.FIXED_LEAD_TIME,'
704: ||' x.VARIABLE_LEAD_TIME,'
705: ||' x.PREPROCESSING_LEAD_TIME,'

Line 808: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug : view sql stmt = ' || v_sql_stmt);

804:
805:
806: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
807:
808: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug : view sql stmt = ' || v_sql_stmt);
809: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'debug: v_temp_sql ='||v_temp_sql);
810: EXECUTE IMMEDIATE v_sql_stmt
811: USING MSC_CL_PULL.V_ICODE,
812: MSC_CL_PULL.v_mso_item_dmd_penalty,

Line 809: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'debug: v_temp_sql ='||v_temp_sql);

805:
806: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
807:
808: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Debug : view sql stmt = ' || v_sql_stmt);
809: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'debug: v_temp_sql ='||v_temp_sql);
810: EXECUTE IMMEDIATE v_sql_stmt
811: USING MSC_CL_PULL.V_ICODE,
812: MSC_CL_PULL.v_mso_item_dmd_penalty,
813: MSC_CL_PULL.v_mso_item_cap_penalty,

Line 847: IF MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED=MSC_UTIL.ASL_YES_RETAIN_CP THEN

843: lv_last_asl_collection_date DATE ;
844: BEGIN
845:
846:
847: IF MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED=MSC_UTIL.ASL_YES_RETAIN_CP THEN
848:
849: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_SUPPLIERS';
850:
851: /*ASL */

Line 854: ELSIF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 and MSC_CL_PULL.v_lrnn <>-1) THEN -- incremental

850:
851: /*ASL */
852: IF MSC_CL_PULL.v_lrnn = -1 THEN
853: MSC_CL_PULL.v_view_name := 'MRP_AP_PO_SUPPLIERS_V';
854: ELSIF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 and MSC_CL_PULL.v_lrnn <>-1) THEN -- incremental
855: MSC_CL_PULL.v_view_name := 'MRP_AN_PO_SUPPLIERS_V';
856: v_sql_stmt := 'Select min (nvl(LAST_SUCC_ASL_REF_TIME,SYSDATE-365000))'
857: ||' From msc_instance_orgs '
858: ||' Where sr_instance_id = ' || MSC_CL_PULL.v_instance_id

Line 859: ||' And organization_id '|| MSC_UTIL.v_in_org_str;

855: MSC_CL_PULL.v_view_name := 'MRP_AN_PO_SUPPLIERS_V';
856: v_sql_stmt := 'Select min (nvl(LAST_SUCC_ASL_REF_TIME,SYSDATE-365000))'
857: ||' From msc_instance_orgs '
858: ||' Where sr_instance_id = ' || MSC_CL_PULL.v_instance_id
859: ||' And organization_id '|| MSC_UTIL.v_in_org_str;
860:
861: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
862:
863: EXECUTE IMMEDIATE v_sql_stmt into lv_last_asl_collection_date;

Line 861: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

857: ||' From msc_instance_orgs '
858: ||' Where sr_instance_id = ' || MSC_CL_PULL.v_instance_id
859: ||' And organization_id '|| MSC_UTIL.v_in_org_str;
860:
861: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
862:
863: EXECUTE IMMEDIATE v_sql_stmt into lv_last_asl_collection_date;
864:
865: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

Line 865: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

861: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
862:
863: EXECUTE IMMEDIATE v_sql_stmt into lv_last_asl_collection_date;
864:
865: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'last successful ASL Collection refresh time is '||lv_last_asl_collection_date);
867: END IF ;
868: /*ASL*/
869:

Line 866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'last successful ASL Collection refresh time is '||lv_last_asl_collection_date);

862:
863: EXECUTE IMMEDIATE v_sql_stmt into lv_last_asl_collection_date;
864:
865: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
866: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'last successful ASL Collection refresh time is '||lv_last_asl_collection_date);
867: END IF ;
868: /*ASL*/
869:
870: /* Added this to collect Item Price information for a supplier

Line 873: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS107,' NULL,', ' x.ITEM_PRICE,')

869:
870: /* Added this to collect Item Price information for a supplier
871: from 11i/110 source */
872: Begin
873: Select decode(MSC_CL_PULL.v_apps_ver,MSC_UTIL.G_APPS107,' NULL,', ' x.ITEM_PRICE,')
874: into v_temp_sql
875: from dual;
876: End;
877:

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

875: from dual;
876: End;
877:
878: /* Added this code for VMI changes */
879: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
880: v_temp_sql1 := ' x.ENABLE_VMI_FLAG, x.VMI_MIN_QTY, x.VMI_MAX_QTY, x.ENABLE_VMI_AUTO_REPLENISH_FLAG, x.VMI_REPLENISHMENT_APPROVAL,'
881: || ' x.REPLENISHMENT_METHOD,x.MIN_MINMAX_DAYS,x.MAX_MINMAX_DAYS,x.FORECAST_HORIZON,x.FIXED_ORDER_QUANTITY, ';
882:
883: ELSE

Line 963: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

959: ||' x.PRIMARY_VENDOR_ITEM,'
960: /* SCE Change end */
961: ||' :v_instance_id'
962: ||' from MRP_AP_PO_SUPPLIERS_V'||MSC_CL_PULL.v_dblink||' x'
963: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
964:
965: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
966: MSC_CL_PULL.v_mso_sup_cap_penalty,
967: MSC_CL_PULL.v_instance_id,

Line 971: ELSIF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 and MSC_CL_PULL.v_lrnn <>-1) THEN -- incremental (ASL net change )

967: MSC_CL_PULL.v_instance_id,
968: MSC_CL_PULL.v_refresh_id,
969: MSC_CL_PULL.v_instance_id;
970:
971: ELSIF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 and MSC_CL_PULL.v_lrnn <>-1) THEN -- incremental (ASL net change )
972:
973: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'GLOBAL ASL net change ');
974: v_sql_stmt:=
975: ' insert into MSC_ST_ITEM_SUPPLIERS'

Line 973: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'GLOBAL ASL net change ');

969: MSC_CL_PULL.v_instance_id;
970:
971: ELSIF (MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 and MSC_CL_PULL.v_lrnn <>-1) THEN -- incremental (ASL net change )
972:
973: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'GLOBAL ASL net change ');
974: v_sql_stmt:=
975: ' insert into MSC_ST_ITEM_SUPPLIERS'
976: ||' ( INVENTORY_ITEM_ID,'
977: ||' USING_ORGANIZATION_ID,'

Line 1047: ||' WHERE (x.USING_ORGANIZATION_ID = -1 or x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str ||')'

1043: ||' x.PRIMARY_VENDOR_ITEM,'
1044: /* SCE Change end */
1045: ||' :v_instance_id'
1046: ||' from MRP_AN_PO_GLOBAL_ASL_V '||MSC_CL_PULL.v_dblink||' x'
1047: ||' WHERE (x.USING_ORGANIZATION_ID = -1 or x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str ||')'
1048: ||' AND (x.DATE1 > :lv_last_asl_collection_date or x.DATE2 > :lv_last_asl_collection_date )';
1049:
1050: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
1051:

Line 1050: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);

1046: ||' from MRP_AN_PO_GLOBAL_ASL_V '||MSC_CL_PULL.v_dblink||' x'
1047: ||' WHERE (x.USING_ORGANIZATION_ID = -1 or x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str ||')'
1048: ||' AND (x.DATE1 > :lv_last_asl_collection_date or x.DATE2 > :lv_last_asl_collection_date )';
1049:
1050: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement is ' || v_sql_stmt);
1051:
1052:
1053: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1054: MSC_CL_PULL.v_mso_sup_cap_penalty,

Line 1061: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'GLOBAL ASL ROW COUNT IS ' || SQL%ROWCOUNT);

1057: MSC_CL_PULL.v_instance_id,
1058: lv_last_asl_collection_date,
1059: lv_last_asl_collection_date;
1060:
1061: -- MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'GLOBAL ASL ROW COUNT IS ' || SQL%ROWCOUNT);
1062:
1063:
1064: END IF ; --end global ASL
1065:

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

1070: only global ASLs are in this view and the local ASLs are in
1071: MRP_AP_PO_LOCAL_ASL_V. Hence adding another insert stmt. to insert local ASLs.
1072: */
1073:
1074: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 ) THEN
1075:
1076: IF MSC_CL_PULL.v_lrnn =-1 THEN -- COMPLETE REFRESH
1077: v_sql_stmt:=
1078: ' insert into MSC_ST_ITEM_SUPPLIERS'

Line 1150: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1146: ||' x.PRIMARY_VENDOR_ITEM,'
1147: /* SCE Change end */
1148: ||' :v_instance_id'
1149: ||' from MRP_AP_PO_LOCAL_ASL_V'||MSC_CL_PULL.v_dblink||' x'
1150: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1151:
1152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Collecting from MRP_AP_PO_LOCAL_ASL_V');
1153:
1154: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,

Line 1152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Collecting from MRP_AP_PO_LOCAL_ASL_V');

1148: ||' :v_instance_id'
1149: ||' from MRP_AP_PO_LOCAL_ASL_V'||MSC_CL_PULL.v_dblink||' x'
1150: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1151:
1152: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Collecting from MRP_AP_PO_LOCAL_ASL_V');
1153:
1154: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1155: MSC_CL_PULL.v_mso_sup_cap_penalty,
1156: MSC_CL_PULL.v_instance_id,

Line 1161: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'LOCAL ASL net change ');

1157: MSC_CL_PULL.v_refresh_id,
1158: MSC_CL_PULL.v_instance_id;
1159: COMMIT;
1160: ELSE -- LOCAL ASL NET CHANGE
1161: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'LOCAL ASL net change ');
1162: v_sql_stmt:=
1163: ' insert into MSC_ST_ITEM_SUPPLIERS'
1164: ||' ( INVENTORY_ITEM_ID,'
1165: ||' USING_ORGANIZATION_ID,'

Line 1235: ||' WHERE x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str

1231: ||' x.PRIMARY_VENDOR_ITEM,'
1232: /* SCE Change end */
1233: ||' :v_instance_id'
1234: ||' from MRP_AN_PO_LOCAL_ASL_V '||MSC_CL_PULL.v_dblink||' x'
1235: ||' WHERE x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str
1236: ||' AND (x.DATE1 > :lv_last_asl_collection_date or x.DATE2 > :lv_last_asl_collection_date )';
1237:
1238: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement lcal ASL ' || v_sql_stmt);
1239:

Line 1238: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement lcal ASL ' || v_sql_stmt);

1234: ||' from MRP_AN_PO_LOCAL_ASL_V '||MSC_CL_PULL.v_dblink||' x'
1235: ||' WHERE x.USING_ORGANIZATION_ID ' || MSC_UTIL.v_in_org_str
1236: ||' AND (x.DATE1 > :lv_last_asl_collection_date or x.DATE2 > :lv_last_asl_collection_date )';
1237:
1238: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'the sql statement lcal ASL ' || v_sql_stmt);
1239:
1240: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.V_ICODE,
1241: MSC_CL_PULL.v_mso_sup_cap_penalty,
1242: MSC_CL_PULL.v_instance_id,

Line 1248: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'LOCAL ASL ROW COUNT IS ' || SQL%ROWCOUNT);

1244: MSC_CL_PULL.v_instance_id,
1245: lv_last_asl_collection_date,
1246: lv_last_asl_collection_date;
1247:
1248: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'LOCAL ASL ROW COUNT IS ' || SQL%ROWCOUNT);
1249: COMMIT ;
1250: END IF ;
1251: END IF; ---- MSC_CL_PULL.v_apps_ver === 115
1252:

Line 1256: IF (MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES_RETAIN_CP) AND

1252:
1253: END IF;
1254:
1255:
1256: IF (MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES_RETAIN_CP) AND
1257: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1258: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1259:
1260: --- LOAD NET_CHAGE for DELETE --------

Line 1257: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND

1253: END IF;
1254:
1255:
1256: IF (MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES_RETAIN_CP) AND
1257: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1258: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1259:
1260: --- LOAD NET_CHAGE for DELETE --------
1261:

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

1254:
1255:
1256: IF (MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES or MSC_CL_PULL.SUPPLIER_CAP_ENABLED= MSC_UTIL.ASL_YES_RETAIN_CP) AND
1257: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS107 AND
1258: MSC_CL_PULL.v_apps_ver<> MSC_UTIL.G_APPS110 THEN
1259:
1260: --- LOAD NET_CHAGE for DELETE --------
1261:
1262: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 1290: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

1286: ||' :v_refresh_id,'
1287: ||' :v_instance_id'
1288: ||' from MRP_AD_SUPPLIER_CAPACITIES_V'||MSC_CL_PULL.v_dblink||' x'
1289: ||' WHERE x.RN> :v_lrn '
1290: ||' AND x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
1291:
1292: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id, MSC_CL_PULL.v_lrn;
1293:
1294: COMMIT;

Line 1319: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1315: ||' 2,'
1316: ||' :v_refresh_id,'
1317: ||' :v_instance_id'
1318: ||' from MRP_AP_SUPPLIER_CAPACITIES_V'||MSC_CL_PULL.v_dblink||' x'
1319: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1320: ||' AND (x.RN2 > :v_lrn)';
1321:
1322: ELSE
1323:

Line 1355: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str

1351: ||' 2,'
1352: ||' :v_refresh_id,'
1353: ||' :v_instance_id'
1354: ||' from MRP_AP_SUPPLIER_CAPACITIES_V'||MSC_CL_PULL.v_dblink||' x'
1355: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str
1356: || v_union_sql;
1357:
1358:
1359: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh

Line 1402: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str ;

1398: ||' 2,'
1399: ||' :v_refresh_id,'
1400: ||' :v_instance_id'
1401: ||' from MRP_AP_SUPPLIER_FLEX_FENCES_V'||MSC_CL_PULL.v_dblink||' x'
1402: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str ;
1403:
1404: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1405:
1406: COMMIT;

Line 1420: IF MSC_CL_PULL.ITEM_SUBST_ENABLED = MSC_UTIL.SYS_YES THEN

1416: PROCEDURE LOAD_ITEM_SUBSTITUTES IS
1417: v_condition varchar2(1000);
1418: BEGIN
1419:
1420: IF MSC_CL_PULL.ITEM_SUBST_ENABLED = MSC_UTIL.SYS_YES THEN
1421:
1422: -- IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
1423:
1424: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN --For Bug 5632379 SRP Changes

Line 1424: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN --For Bug 5632379 SRP Changes

1420: IF MSC_CL_PULL.ITEM_SUBST_ENABLED = MSC_UTIL.SYS_YES THEN
1421:
1422: -- IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
1423:
1424: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 AND MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN --For Bug 5632379 SRP Changes
1425: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_SUBSTITUTES';
1426: MSC_CL_PULL.v_view_name := 'MRP_AP_ITEM_SUPERSESSION_REL_V';
1427: v_sql_stmt:=
1428: ' INSERT INTO MSC_ST_ITEM_SUBSTITUTES'

Line 1453: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn || ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1449: ||' :v_instance_id,'
1450: ||' 2,'
1451: ||' x.ORGANIZATION_ID'
1452: ||' FROM MRP_AP_ITEM_SUPERSESSION_REL_V'||MSC_CL_PULL.v_dblink||' x'
1453: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn || ' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1454:
1455: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id;
1456:
1457: COMMIT;

Line 1496: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1492: ||' 2,'
1493: ||' x.ORGANIZATION_ID'
1494: ||' FROM MRP_AP_ITEM_SUBSTITUTES_V'||MSC_CL_PULL.v_dblink||' x'
1495: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1496: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1497:
1498:
1499: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id;
1500:

Line 1505: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_CL_PULL.v_lrnn<> -1) THEN -- incremental refresh

1501: COMMIT;
1502:
1503: --END IF; --COMPLETE REFRESH For Bug 5702475 SRP Changes
1504:
1505: IF (MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120 AND MSC_CL_PULL.v_lrnn<> -1) THEN -- incremental refresh
1506:
1507: MSC_CL_PULL.v_table_name:= 'MSC_ST_ITEM_SUBSTITUTES';
1508: MSC_CL_PULL.v_view_name := 'MRP_AD_ITEM_RELATIONSHIPS_V';
1509: v_condition:=null;

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

1508: MSC_CL_PULL.v_view_name := 'MRP_AD_ITEM_RELATIONSHIPS_V';
1509: v_condition:=null;
1510:
1511: --For Bug 5702475 SRP Changes
1512: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS120) THEN
1513: v_condition:= ' and x.relationship_type_id in (2,5,8,18 ) ';
1514: else
1515: v_condition:= ' and x.relationship_type_id in (2) ';
1516: end if;

Line 1539: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;

1535: ||' :v_instance_id'
1536: ||' FROM MRP_AD_ITEM_RELATIONSHIPS_V'||MSC_CL_PULL.v_dblink||' x'
1537: ||' WHERE x.RN>'||MSC_CL_PULL.v_lrn
1538: || v_condition
1539: ||' AND x.ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
1540:
1541:
1542: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
1543:

Line 1566: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))

1562: ( select x.organization_id
1563: FROM msc_instance_orgs x
1564: WHERE x.sr_instance_id= MSC_CL_PULL.v_instance_id
1565: and x.enabled_flag= 1
1566: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))
1567: );
1568: commit;
1569:
1570: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_EAM_NO_ACTIVITY_ITEM'),'No Activity Item');

Line 1622: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group));

1618: MTL_PARAMETERS org
1619: WHERE sr_instance_id= MSC_CL_PULL.v_instance_id
1620: and enabled_flag= 1
1621: and org.ORGANIZATION_ID = x.ORGANIZATION_ID
1622: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (org_group = MSC_CL_PULL.v_org_group));
1623:
1624: commit;
1625:
1626: lv_item_name := NVL(FND_PROFILE.VALUE('MSC_WIP_NONSTD_JOB_ITEM'),'Non Standard Job Item');

Line 1677: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group));

1673: MTL_PARAMETERS org
1674: WHERE x.sr_instance_id= MSC_CL_PULL.v_instance_id
1675: and x.enabled_flag= 1
1676: and org.ORGANIZATION_ID = x.ORGANIZATION_ID
1677: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group));
1678:
1679: commit;
1680:
1681: /*inserting dummy items for aggregation */

Line 1731: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';

1727: ||' MTL_PARAMETERS'||MSC_CL_PULL.v_dblink||' org '
1728: ||' WHERE x.sr_instance_id= '|| MSC_CL_PULL.v_instance_id
1729: ||' and x.enabled_flag= 1 '
1730: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID '
1731: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';
1732:
1733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||lv_ins_stmt);
1734:
1735: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_PULL.V_ICODE;

Line 1733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||lv_ins_stmt);

1729: ||' and x.enabled_flag= 1 '
1730: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID '
1731: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';
1732:
1733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||lv_ins_stmt);
1734:
1735: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_PULL.V_ICODE;
1736: commit;
1737:

Line 1787: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';

1783: ||' MTL_PARAMETERS'||MSC_CL_PULL.v_dblink||' org '
1784: ||' WHERE x.sr_instance_id= '|| MSC_CL_PULL.v_instance_id
1785: ||' and x.enabled_flag= 1 '
1786: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID '
1787: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';
1788:
1789: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||lv_ins_stmt);
1790: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_PULL.V_ICODE;
1791: commit;

Line 1789: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||lv_ins_stmt);

1785: ||' and x.enabled_flag= 1 '
1786: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID '
1787: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';
1788:
1789: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||lv_ins_stmt);
1790: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_PULL.V_ICODE;
1791: commit;
1792:
1793: lv_ins_stmt := ' insert into MSC_ST_SYSTEM_ITEMS ( '

Line 1842: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';

1838: ||' MTL_PARAMETERS'||MSC_CL_PULL.v_dblink||' org '
1839: ||' WHERE x.sr_instance_id= '|| MSC_CL_PULL.v_instance_id
1840: ||' and x.enabled_flag= 1 '
1841: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID '
1842: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';
1843:
1844: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||lv_ins_stmt);
1845: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_PULL.V_ICODE ;
1846: commit;

Line 1844: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||lv_ins_stmt);

1840: ||' and x.enabled_flag= 1 '
1841: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID '
1842: ||' and (('''||MSC_CL_PULL.v_org_group||''' = '''||MSC_UTIL.G_ALL_ORGANIZATIONS ||''') or (x.org_group = '''|| MSC_CL_PULL.v_org_group ||'''))';
1843:
1844: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'lv_sql_stmt ' ||lv_ins_stmt);
1845: EXECUTE IMMEDIATE lv_ins_stmt USING MSC_CL_PULL.V_ICODE ;
1846: commit;
1847:
1848: END INSERT_DUMMY_ITEMS;

Line 1878: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug1 - ' || lv_sql_stmt);

1874: lv_sql_stmt:= 'SELECT category_set_id FROM '||lv_table_name
1875: ||' WHERE category_set_name = '''||lv_category_set_name
1876: ||''' AND nvl(language,''' || MSC_CL_PULL.v_lang || ''')=''' || MSC_CL_PULL.v_lang || '''';
1877:
1878: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug1 - ' || lv_sql_stmt);
1879:
1880: EXECUTE IMMEDIATE lv_sql_stmt INTO lv_category_set_id ;
1881: EXCEPTION
1882: WHEN NO_DATA_FOUND THEN

Line 1920: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))

1916: ( select x.organization_id
1917: FROM msc_instance_orgs x
1918: WHERE x.sr_instance_id= MSC_CL_PULL.v_instance_id
1919: and x.enabled_flag= 1
1920: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))
1921: );
1922: commit;
1923:
1924: lv_category_name := NVL(FND_PROFILE.VALUE('MSC_NO_ACTIVITY_ITEM_CATEGORY'),'NEW.MISC');

Line 1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug2 - ' || lv_sql_stmt);

1927: lv_sql_stmt:= 'SELECT category_id,description FROM ' ||lv_table_name
1928: || ' WHERE category_name = '''||lv_category_name
1929: || ''' AND nvl(language,''' || MSC_CL_PULL.v_lang || ''')=''' || MSC_CL_PULL.v_lang || '''and rownum=1';
1930:
1931: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'debug2 - ' || lv_sql_stmt);
1932:
1933: EXECUTE IMMEDIATE lv_sql_stmt INTO lv_category_id,lv_category_description ;
1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN

Line 1973: ||' and (('''||MSC_CL_PULL.v_org_group ||'''='''|| MSC_UTIL.G_ALL_ORGANIZATIONS||''' ) or (org_group ='''|| MSC_CL_PULL.v_org_group||'''))';

1969: || lv_table_name ||' org '
1970: ||' WHERE x.sr_instance_id='|| MSC_CL_PULL.v_instance_id
1971: ||' and x.enabled_flag= 1'
1972: ||' and org.ORGANIZATION_ID = x.ORGANIZATION_ID'
1973: ||' and (('''||MSC_CL_PULL.v_org_group ||'''='''|| MSC_UTIL.G_ALL_ORGANIZATIONS||''' ) or (org_group ='''|| MSC_CL_PULL.v_org_group||'''))';
1974:
1975:
1976:
1977: for lv_item_id in -1004..-1000 loop

Line 1991: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))

1987: ( select x.organization_id
1988: FROM msc_instance_orgs x
1989: WHERE x.sr_instance_id= MSC_CL_PULL.v_instance_id
1990: and x.enabled_flag= 1
1991: and ((MSC_CL_PULL.v_org_group = MSC_UTIL.G_ALL_ORGANIZATIONS ) or (x.org_group = MSC_CL_PULL.v_org_group))
1992: );
1993:
1994: commit;
1995:

Line 2020: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;

2016: ||' x.ORGANIZATION_ID,'
2017: ||' x.ASSIGNMENT_GROUP_ID,'
2018: ||' :v_instance_id'
2019: ||' from MRP_AP_ABC_CLASSES_V'||MSC_CL_PULL.v_dblink||' x'
2020: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_org_str;
2021:
2022:
2023: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_instance_id;
2024: