2174: -- For getting the Alternate Items for an Item Group
2175: CURSOR get_alternate_items (c_item_group_id NUMBER)
2176: IS
2177: SELECT inventory_item_id
2178: FROM AHL_ITEM_ASSOCIATIONS_B
2179: WHERE item_group_id=c_item_group_id
2180: ORDER BY priority;
2181:
2182: -- For Checking whether an Item exisits in an Organization.
2300: -- For getting the Alternate Items for an Item Group
2301: CURSOR get_alternate_items (c_item_group_id NUMBER)
2302: IS
2303: SELECT inventory_item_id
2304: FROM AHL_ITEM_ASSOCIATIONS_B
2305: WHERE item_group_id=c_item_group_id
2306: ORDER BY priority;
2307:
2308: -- For Checking whether an Item exisits in an Organization.