DBA Data[Home] [Help]

APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 179: FROM ahl_item_associations_b

175: where INSTANCE_ID = c_instance_id;
176:
177: CURSOR get_item_group_item_csr(c_item_group_id IN NUMBER) IS
178: SELECT inventory_item_id, inventory_org_id
179: FROM ahl_item_associations_b
180: WHERE item_group_id = c_item_group_id
181: AND interchange_type_code in ('1-WAY INTERCHANGEABLE', '2-WAY INTERCHANGEABLE')
182: ORDER BY priority;
183: