DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 2178: FROM AHL_ITEM_ASSOCIATIONS_B

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.

Line 2304: FROM AHL_ITEM_ASSOCIATIONS_B

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.