APPS.AHL_MC_NODE_PVT dependencies on AHL_ITEM_GROUPS_B

Line 2339: FROM ahl_item_groups_b

2335: p_ig_id in number
2336: )
2337: IS
2338: SELECT type_code, name
2339: FROM ahl_item_groups_b
2340: WHERE item_group_id = p_ig_id;
2341:
2342: -- Define get_item_group_id to retrieve item_group_id given name of the item group
2343: CURSOR get_item_group_csr

Line 2349: FROM ahl_item_groups_b

2345: p_ig_name in VARCHAR2
2346: )
2347: IS
2348: SELECT item_group_id, type_code, name
2349: FROM ahl_item_groups_b
2350: WHERE upper(name) = upper (p_ig_name) AND
2351: source_item_group_id IS NULL;
2352:
2353: -- 1. Define local variables

Line 2694: FROM ahl_item_groups_b

2690: -- Define cursor get_item_group_id to retrieve item group id, type and status
2691: CURSOR get_item_group_id
2692: IS
2693: SELECT item_group_id, type_code, status_code
2694: FROM ahl_item_groups_b
2695: WHERE upper(name) = upper (p_x_node_rec.item_group_name) AND
2696: source_item_group_id IS NULL;
2697:
2698: -- Define cursor check_item_assos_qty to check quantity = 1 for all item associations