APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ITEM_CLASS_UOM_V

Line 2185: FROM AHL_ITEM_CLASS_UOM_V

2181: c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
2182: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
2183: IS
2184: SELECT 'X'
2185: FROM AHL_ITEM_CLASS_UOM_V
2186: WHERE uom_code = c_uom_code
2187: AND inventory_item_id = c_inventory_item_id
2188: AND inventory_org_id = c_inventory_org_id;
2189:

Line 2194: FROM AHL_ITEM_CLASS_UOM_V UOM, AHL_ITEM_ASSOCIATIONS_B ASSOC

2190: CURSOR get_uom_for_item_group ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE,
2191: c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE )
2192: IS
2193: SELECT 'X'
2194: FROM AHL_ITEM_CLASS_UOM_V UOM, AHL_ITEM_ASSOCIATIONS_B ASSOC
2195: WHERE UOM.uom_code = c_uom_code
2196: AND UOM.inventory_item_id = ASSOC.inventory_item_id
2197: AND UOM.inventory_org_id = ASSOC.inventory_org_id
2198: AND ASSOC.item_group_id = c_item_group_id;