DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 1251: FROM mtl_units_of_measure muom, mtl_system_items msi

1247:
1248: -- find the uom class for the item's primary uom
1249: CURSOR c_primary_uom_class IS
1250: SELECT uom_class
1251: FROM mtl_units_of_measure muom, mtl_system_items msi
1252: WHERE msi.organization_id = p_organization_id
1253: AND msi.inventory_item_id = p_inventory_item_id
1254: AND muom.uom_code = msi.primary_uom_code;
1255:

Line 4718: FROM mtl_units_of_measure_vl

4714: -- high level rather than detail.
4715:
4716: CURSOR c_uom_class(p_uom IN VARCHAR2) IS
4717: SELECT uom_class
4718: FROM mtl_units_of_measure_vl
4719: WHERE uom_code = p_uom;
4720:
4721: BEGIN
4722: IF NOT(inv_cache.is_pickrelease AND g_debug IS NOT NULL) THEN