eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_MC_NODE_PVT dependencies on AHL_ITEM_GROUPS_B

Line 2340: FROM ahl_item_groups_b

2336: p_ig_id in number
2337: )
2338: IS
2339: SELECT type_code, name
2340: FROM ahl_item_groups_b
2341: WHERE item_group_id = p_ig_id;
2342:
2343: -- Define get_item_group_id to retrieve item_group_id given name of the item group
2344: -- SATHAPLI::made the item group name join case sensitive

Line 2351: FROM ahl_item_groups_b

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

Line 2697: FROM ahl_item_groups_b

2693: -- SATHAPLI::Bug 9089133, 08-Feb-2010, made the item group name join case sensitive
2694: CURSOR get_item_group_id
2695: IS
2696: SELECT item_group_id, type_code, status_code
2697: FROM ahl_item_groups_b
2698: WHERE name = p_x_node_rec.item_group_name AND
2699: source_item_group_id IS NULL;
2700:
2701: -- Define cursor check_item_assos_qty to check quantity = 1 for all item associations