APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_ITEM_CLASS_UOM_V

Line 2053: FROM AHL_ITEM_CLASS_UOM_V

2049: c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
2050: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
2051: IS
2052: SELECT 'X'
2053: FROM AHL_ITEM_CLASS_UOM_V
2054: WHERE uom_code = c_uom_code
2055: AND inventory_item_id = c_inventory_item_id
2056: AND inventory_org_id = c_inventory_org_id;
2057:

Line 2062: FROM AHL_ITEM_CLASS_UOM_V UOM, AHL_ITEM_ASSOCIATIONS_B ASSOC

2058: CURSOR get_uom_for_item_group ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE,
2059: c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE )
2060: IS
2061: SELECT 'X'
2062: FROM AHL_ITEM_CLASS_UOM_V UOM, AHL_ITEM_ASSOCIATIONS_B ASSOC
2063: WHERE UOM.uom_code = c_uom_code
2064: AND UOM.inventory_item_id = ASSOC.inventory_item_id
2065: AND UOM.inventory_org_id = ASSOC.inventory_org_id
2066: AND ASSOC.item_group_id = c_item_group_id;