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

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

14: v_temp_sql5 VARCHAR2(1000);
15: v_rounding_Sql varchar2(1000);
16:
17: -- NULL_DBLINK CONSTANT VARCHAR2(1):= ' ';
18: -- NULL_DBLINK CONSTANT VARCHAR2(1) :=MSC_UTIL.NULL_DBLINK;
19: v_gmp_routine_name VARCHAR2(50);
20: GMP_ERROR EXCEPTION;
21:
22: --==================================================================

Line 72: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN --when not net collection

68: END IF;
69:
70:
71:
72: IF MSC_CL_PULL.v_lrnn= -1 AND MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN --when not net collection
73:
74:
75: MSC_CL_PULL.v_table_name:= 'MSC_ST_CALENDAR_ASSIGNMENTS';
76: MSC_CL_PULL.v_view_name := 'MRP_AP_CAL_ASSIGNMENTS_V';

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

253:
254: Begin
255:
256:
257: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
258: v_temp_sql:= 'x.capacity_units , ' ;
259: ELSE
260: v_temp_sql:=' NULL, ' ;
261: END IF ;

Line 284: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str

280: || v_temp_sql
281: ||' :v_refresh_id,'
282: ||' :v_instance_id'
283: ||' FROM MRP_AP_RESOURCE_SHIFTS_V'||MSC_CL_PULL.v_dblink||' x'
284: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str
285: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
286: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')';
287:
288: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;

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

462: -- =============================== NETCHAGE OF DELETE ======================
463:
464: /* ds change start */
465:
466: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
467: IF MSC_CL_PULL.v_lrnn<> -1 THEN -- incremental refresh
468: MSC_CL_PULL.v_table_name:= 'MSC_ST_RES_INSTANCE_CHANGES';
469: MSC_CL_PULL.v_view_name := 'MRP_AD_RES_INST_CHANGES_V';
470: v_sql_stmt:=

Line 504: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance change sql = '||v_sql_stmt);

500: ||' :v_instance_id'
501: ||' FROM MRP_AD_RES_INST_CHANGES_V'||MSC_CL_PULL.v_dblink||' x'
502: ||' WHERE x.RN >' ||MSC_CL_PULL.v_lrn;
503:
504: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Ds debug: res_instance change sql = '||v_sql_stmt);
505: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
506:
507: COMMIT;
508:

Line 554: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: res_instance changes sql = '||v_sql_stmt);

550: ||' FROM MRP_AP_RES_INST_CHANGES_V' ||MSC_CL_PULL.v_dblink ||' x'
551: ||' WHERE x.RN1>' ||MSC_CL_PULL.v_lrn
552: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn;
553:
554: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: res_instance changes sql = '||v_sql_stmt);
555: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
556: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RES_INST_CHANGES_V='|| SQL%ROWCOUNT);
557:
558: COMMIT;

Line 556: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RES_INST_CHANGES_V='|| SQL%ROWCOUNT);

552: ||' OR x.RN2>' ||MSC_CL_PULL.v_lrn;
553:
554: --MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'to be removed: Ds debug: res_instance changes sql = '||v_sql_stmt);
555: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
556: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Number of rows for MRP_AP_RES_INST_CHANGES_V='|| SQL%ROWCOUNT);
557:
558: COMMIT;
559: END IF; /* MSC_CL_PULL.v_lrnn= -1 */
560:

Line 561: END IF; /* MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 */

557:
558: COMMIT;
559: END IF; /* MSC_CL_PULL.v_lrnn= -1 */
560:
561: END IF; /* MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 */
562:
563: END LOAD_CALENDAR_DATE;
564:
565:

Line 574: --IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN /* PREPLACE START */

570: BEGIN
571:
572:
573: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
574: --IF MSC_CL_PULL.ITEM_ENABLED= MSC_UTIL.SYS_YES THEN /* PREPLACE START */
575:
576: MSC_CL_PULL.v_table_name:= 'MSC_ST_PARTNER_CONTACTS';
577: MSC_CL_PULL.v_view_name := 'MRP_AP_BUYER_CONTACTS_V';
578:

Line 605: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str;

601: ||' 2,'
602: ||' :v_refresh_id,'
603: ||' :v_instance_id'
604: ||' FROM MRP_AP_BUYER_CONTACTS_V'||MSC_CL_PULL.v_dblink||' x'
605: ||' WHERE x.ORGANIZATION_ID'||MSC_UTIL.v_in_all_org_str;
606:
607: EXECUTE IMMEDIATE v_sql_stmt
608: USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
609:

Line 639: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

635: lv_profile_inherit_op_seq := 2;
636:
637: END ;
638:
639: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
640: v_temp_tp_sql := NULL;
641: ELSE
642: v_temp_tp_sql := ' AND x.LAST_UPDATE_DATE > SYSDATE - :v_msc_tp_coll_window';
643: END IF;

Line 645: IF MSC_CL_PULL.VENDOR_ENABLED= MSC_UTIL.SYS_YES THEN

641: ELSE
642: v_temp_tp_sql := ' AND x.LAST_UPDATE_DATE > SYSDATE - :v_msc_tp_coll_window';
643: END IF;
644:
645: IF MSC_CL_PULL.VENDOR_ENABLED= MSC_UTIL.SYS_YES THEN
646:
647: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
648: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDORS_V';
649:

Line 673: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

669: ||' from MRP_AP_VENDORS_V'||MSC_CL_PULL.v_dblink||' x'
670: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
671: ||v_temp_tp_sql;
672:
673: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
674: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
675: ELSE
676: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
677: END IF;

Line 676: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;

672:
673: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
674: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
675: ELSE
676: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_dgmt, MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
677: END IF;
678:
679: COMMIT;
680:

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

681: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
682: MSC_CL_PULL.v_view_name := 'MRP_AP_VENDOR_SITES_V';
683:
684: /* for bug: 2459612, added code to collect OPERATING_UNIT from Vendor sites for 11i source instance */
685: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
686: v_temp_sql := ' x.OPERATING_UNIT,x.shipping_control, ';
687: ELSE
688: v_temp_sql := ' NULL,NULL,';
689: END IF;

Line 749: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

745: ||' WHERE (x.RN1>'||MSC_CL_PULL.v_lrn
746: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn||')'
747: ||v_temp_tp_sql;
748:
749: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
750: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
751: ELSE
752: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
753: END IF;

Line 752: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;

748:
749: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
750: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
751: ELSE
752: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
753: END IF;
754:
755: COMMIT;
756:

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

755: COMMIT;
756:
757: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
758:
759: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
760: v_temp_sql := 'x.ORGANIZATION_ID, ';
761: ELSE
762: v_temp_sql := ' NULL, ';
763: END IF;

Line 833: IF MSC_CL_PULL.CUSTOMER_ENABLED= MSC_UTIL.SYS_YES THEN

829:
830: END IF; -- MSC_CL_PULL.VENDOR_ENABLED
831:
832:
833: IF MSC_CL_PULL.CUSTOMER_ENABLED= MSC_UTIL.SYS_YES THEN
834:
835: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
836: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMERS_V';
837:

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

836: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMERS_V';
837:
838: BEGIN
839:
840: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
841: v_temp_sql2 := ' x.AGGREGATE_DEMAND_FLAG, ';
842: ELSE
843: v_temp_sql2 := ' NULL,';
844: END IF;

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

841: v_temp_sql2 := ' x.AGGREGATE_DEMAND_FLAG, ';
842: ELSE
843: v_temp_sql2 := ' NULL,';
844: END IF;
845: IF MSC_CL_PULL.v_apps_ver = MSC_UTIL.G_APPS107 THEN
846: v_temp_sql1 := ' NULL,';
847: ELSE
848: v_temp_sql1 := ' x.CUSTOMER_CLASS_CODE,';
849: END IF;

Line 852: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN

848: v_temp_sql1 := ' x.CUSTOMER_CLASS_CODE,';
849: END IF;
850:
851: ------ ===== # SRP Changes ======
852: IF (MSC_UTIL.G_COLLECT_SRP_DATA = 'Y') THEN
853: v_temp_sql2 := v_temp_sql2||' x.RESOURCE_TYPE, ';
854: ELSE
855: v_temp_sql2 := v_temp_sql2||' NULL,';
856: END IF;

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

854: ELSE
855: v_temp_sql2 := v_temp_sql2||' NULL,';
856: END IF;
857:
858: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
859: v_temp_sql2 := v_temp_sql2 || ' x.customer_type, x.CUST_ACCOUNT_NUMBER, ';
860: ELSE
861: v_temp_sql2 := v_temp_sql2 || ' NULL, NULL, ';
862: END IF;

Line 896: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

892: ||' from MRP_AP_CUSTOMERS_V'||MSC_CL_PULL.v_dblink||' x'
893: ||' WHERE x.RN1>'||MSC_CL_PULL.v_lrn
894: ||v_temp_tp_sql;
895:
896: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
897: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
898: ELSE
899: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
900: END IF;

Line 899: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;

895:
896: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
897: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
898: ELSE
899: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
900: END IF;
901:
902: COMMIT;
903:

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

903:
904: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNER_SITES';
905: MSC_CL_PULL.v_view_name := 'MRP_AP_CUSTOMER_SITES_V';
906:
907: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
908: v_temp_sql := ' x.POSTAL_CODE, x.CITY, x.STATE, x.COUNTRY,x.LOCATION_ID,x.SHIPPING_CONTROL, ';
909: ELSE
910: v_temp_sql := ' NULL,NULL,NULL,NULL,NULL,NULL, ';
911: END IF;

Line 972: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN

968: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
969: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')'
970: ||v_temp_tp_sql;
971:
972: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
973: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
974: ELSE
975: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
976: END IF;

Line 975: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;

971:
972: IF MSC_UTIL.v_msc_tp_coll_window = 0 THEN
973: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id;
974: ELSE
975: EXECUTE IMMEDIATE v_sql_stmt USING MSC_CL_PULL.v_refresh_id, MSC_CL_PULL.v_instance_id,MSC_UTIL.v_msc_tp_coll_window;
976: END IF;
977:
978: COMMIT;
979:

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

978: COMMIT;
979:
980: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete refresh
981:
982: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
983: v_temp_sql := 'x.ORGANIZATION_ID, ';
984: ELSE
985: v_temp_sql := ' NULL, ';
986: END IF;

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

1054:
1055: MSC_CL_PULL.v_table_name:= 'MSC_ST_TRADING_PARTNERS';
1056: MSC_CL_PULL.v_view_name := 'MRP_AP_ORGANIZATIONS_V';
1057:
1058: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1059: v_temp_sql:= 'x.BUSINESS_GROUP_ID,x.LEGAL_ENTITY, x.SET_OF_BOOKS_ID, x.CHART_OF_ACCOUNTS_ID, x.BUSINESS_GROUP_NAME,x.LEGAL_ENTITY_NAME, x.OPERATING_UNIT_NAME, ';
1060: ELSE
1061: v_temp_sql := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1062: END IF;

Line 1065: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN

1061: v_temp_sql := 'NULL,NULL,NULL,NULL,NULL,NULL,NULL,';
1062: END IF;
1063:
1064:
1065: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS121 THEN
1066: v_temp_sql5 := 'x.SUBCONTRACTING_SOURCE_ORG, ';
1067: ELSE
1068: v_temp_sql5 := 'NULL,';
1069: END IF;

Line 1216: ||' AND x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str

1212: ||' :v_instance_id,'
1213: ||' :lv_profile_inherit_op_seq'
1214: ||' from MRP_AP_ORGANIZATIONS_V'||MSC_CL_PULL.v_dblink||' x'
1215: ||' where NVL( x.LANGUAGE, :v_lang)= :v_lang'
1216: ||' AND x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1217: ||' AND ( x.RN1>'||MSC_CL_PULL.v_lrn
1218: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1219: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1220:

Line 1285: ||' WHERE x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str

1281: ||' 2,'
1282: ||' :v_refresh_id,'
1283: ||' :v_instance_id'
1284: ||' from MRP_AP_ORGANIZATION_SITES_V'||MSC_CL_PULL.v_dblink||' x'
1285: ||' WHERE x.SR_TP_ID'||MSC_UTIL.v_in_all_org_str
1286: ||' AND (x.RN1>'||MSC_CL_PULL.v_lrn
1287: ||' OR x.RN2>'||MSC_CL_PULL.v_lrn
1288: ||' OR x.RN3>'||MSC_CL_PULL.v_lrn||')';
1289:

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

1293:
1294: /* added this fix for bug # 2198339 to collect location associations for the Orgs */
1295: IF MSC_CL_PULL.v_lrnn= -1 THEN -- complete,targeted refresh
1296:
1297: IF MSC_CL_PULL.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
1298: v_temp_sql := 'x.ORGANIZATION_ID, ';
1299: ELSE
1300: v_temp_sql := ' NULL, ';
1301: END IF;

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

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

Line 1416: IF MSC_CL_PULL.UOM_ENABLED= MSC_UTIL.SYS_YES THEN

1412:
1413: PROCEDURE LOAD_UOM IS
1414: BEGIN
1415:
1416: IF MSC_CL_PULL.UOM_ENABLED= MSC_UTIL.SYS_YES THEN
1417:
1418: MSC_CL_PULL.v_table_name:= 'MSC_ST_UNITS_OF_MEASURE';
1419: MSC_CL_PULL.v_view_name := 'MRP_AP_UNITS_OF_MEASURE_V';
1420: