APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_GROUPS_TL

Line 1986: AHL_ITEM_GROUPS_B b, AHL_ITEM_GROUPS_TL tl

1982: TL.LANGUAGE,
1983: TL.SOURCE_LANG,
1984: TL.DESCRIPTION
1985: FROM
1986: AHL_ITEM_GROUPS_B b, AHL_ITEM_GROUPS_TL tl
1987: WHERE
1988: b.ITEM_GROUP_ID = tl.ITEM_GROUP_ID
1989: AND b.ITEM_GROUP_ID = p_item_group_id
1990: AND tl.LANGUAGE = USERENV('LANG')

Line 3682: INSERT INTO ahl_item_groups_tl_h

3678: FROM ahl_item_groups_b
3679: WHERE item_group_id = p_ItemGroups_id;
3680:
3681:
3682: INSERT INTO ahl_item_groups_tl_h
3683: (item_group_h_id ,
3684: language ,
3685: last_update_date ,
3686: last_updated_by ,

Line 3702: FROM ahl_item_groups_tl

3698: creation_date ,
3699: created_by ,
3700: description ,
3701: last_update_login
3702: FROM ahl_item_groups_tl
3703: WHERE item_group_id = p_ItemGroups_id;
3704:
3705:
3706:

Line 4110: Delete from ahl_item_groups_tl

4106:
4107: -- This is to delete the temporary version of Item group.
4108:
4109:
4110: Delete from ahl_item_groups_tl
4111: where item_group_id = l_itemgroup_det.item_group_id;
4112:
4113: Delete from ahl_item_groups_b
4114: where item_group_id = l_itemgroup_det.item_group_id;