2851: -- For getting the Alternate Items for an Item Group
2852: CURSOR get_alternate_items (c_item_group_id NUMBER)
2853: IS
2854: SELECT inventory_item_id
2855: FROM AHL_ITEM_ASSOCIATIONS_B
2856: WHERE item_group_id=c_item_group_id
2857: ORDER BY priority;
2858:
2859: -- For Checking whether an Item exisits in an Organization.
3094: -- For getting the Alternate Items for an Item Group
3095: CURSOR get_alternate_items (c_item_group_id NUMBER)
3096: IS
3097: SELECT inventory_item_id
3098: FROM AHL_ITEM_ASSOCIATIONS_B
3099: WHERE item_group_id=c_item_group_id
3100: ORDER BY priority;
3101:
3102: -- For Checking whether an Item exisits in an Organization.