APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_UNITS_OF_MEASURE

Line 2851: FROM MSC_UNITS_OF_MEASURE

2847: /* for the bug:2449749 removed the filter of sr_instance_id as the UOM code is global */
2848:
2849: SELECT DECODE(upper(uom_class),'WEIGHT',1 ,'VOLUME',2 , 1)
2850: INTO lv_uom_class_type
2851: FROM MSC_UNITS_OF_MEASURE
2852: WHERE UOM_CODE = c_rec.unit_of_measure;
2853: -- AND SR_INSTANCE_ID = c_rec.SR_INSTANCE_ID;
2854:
2855: EXCEPTION