APPS.OPI_DBI_REP_UOM_STD_CONV_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 351: mtl_units_of_measure convs

347: base_rep_uom_code
348: FROM opi_dbi_rep_uoms
349: WHERE measure_code in ('WT', 'VOL')
350: AND rep_uom_code IS NOT NULL) msr_mst,
351: mtl_units_of_measure convs
352: WHERE msr_mst.rep_uom_class = convs.uom_class;
353:
354: return;
355:

Line 464: mtl_units_of_measure_vl from_class,

460: opi_dbi_uom_class_std_conv convs
461: WHERE ( convs.from_base_uom_code = msr_mst.base_rep_uom_code
462: OR convs.to_base_uom_code = msr_mst.base_rep_uom_code))
463: from_rep_bases,
464: mtl_units_of_measure_vl from_class,
465: mtl_units_of_measure_vl from_uoms
466: WHERE from_rep_bases.base_from_uom_code = from_class.uom_code
467: AND from_class.base_uom_flag = C_IS_BASE_UOM
468: AND from_class.uom_class = from_uoms.uom_class;

Line 465: mtl_units_of_measure_vl from_uoms

461: WHERE ( convs.from_base_uom_code = msr_mst.base_rep_uom_code
462: OR convs.to_base_uom_code = msr_mst.base_rep_uom_code))
463: from_rep_bases,
464: mtl_units_of_measure_vl from_class,
465: mtl_units_of_measure_vl from_uoms
466: WHERE from_rep_bases.base_from_uom_code = from_class.uom_code
467: AND from_class.base_uom_flag = C_IS_BASE_UOM
468: AND from_class.uom_class = from_uoms.uom_class;
469: