APPS.INV_MINMAX_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 1325: FROM mtl_system_items_vl msiv , mtl_units_of_measure_vl muom

1321: primary uom code */
1322:
1323: SELECT uom_code
1324: INTO l_puom
1325: FROM mtl_system_items_vl msiv , mtl_units_of_measure_vl muom
1326: WHERE msiv.inventory_item_id = p_item_id
1327: AND msiv.organization_id = p_org_id
1328: AND muom.unit_of_measure = msiv.primary_unit_of_measure;
1329:

Line 3991: from mtl_system_items_vl msiv , mtl_units_of_measure_vl muom

3987: l_check_uom := 0;
3988:
3989: select uom_code
3990: into l_unit_of_issue
3991: from mtl_system_items_vl msiv , mtl_units_of_measure_vl muom
3992: where msiv.inventory_item_id = p_item_id
3993: and msiv.organization_id = p_organization_id
3994: and muom.unit_of_measure = NVL(msiv.unit_of_issue,msiv.primary_unit_of_measure);
3995:

Line 4586: l_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%type := NULL;

4582: -- MUOM table based on unit_of_measure info from the po_requisitions_interface_all.
4583:
4584: FUNCTION get_item_uom_code (p_uom_name VARCHAR2) RETURN VARCHAR2 IS
4585:
4586: l_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%type := NULL;
4587:
4588: BEGIN
4589:
4590: SELECT uom_code

Line 4592: FROM mtl_units_of_measure_vl

4588: BEGIN
4589:
4590: SELECT uom_code
4591: INTO l_uom_code
4592: FROM mtl_units_of_measure_vl
4593: WHERE unit_of_measure = p_uom_name;
4594:
4595: RETURN (l_uom_code);
4596: