DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_ITEM_ASSOCIATIONS_B

Line 2855: FROM AHL_ITEM_ASSOCIATIONS_B

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.

Line 3098: FROM AHL_ITEM_ASSOCIATIONS_B

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.