APPS.AHL_MC_ITEMGROUP_PVT dependencies on AHL_ITEM_GROUPS_TL

Line 1990: AHL_ITEM_GROUPS_B b, AHL_ITEM_GROUPS_TL tl

1986: TL.LANGUAGE,
1987: TL.SOURCE_LANG,
1988: TL.DESCRIPTION
1989: FROM
1990: AHL_ITEM_GROUPS_B b, AHL_ITEM_GROUPS_TL tl
1991: WHERE
1992: b.ITEM_GROUP_ID = tl.ITEM_GROUP_ID
1993: AND b.ITEM_GROUP_ID = p_item_group_id
1994: AND tl.LANGUAGE = USERENV('LANG')

Line 3692: INSERT INTO ahl_item_groups_tl_h

3688: FROM ahl_item_groups_b
3689: WHERE item_group_id = p_ItemGroups_id;
3690:
3691:
3692: INSERT INTO ahl_item_groups_tl_h
3693: (item_group_h_id ,
3694: language ,
3695: last_update_date ,
3696: last_updated_by ,

Line 3712: FROM ahl_item_groups_tl

3708: creation_date ,
3709: created_by ,
3710: description ,
3711: last_update_login
3712: FROM ahl_item_groups_tl
3713: WHERE item_group_id = p_ItemGroups_id;
3714:
3715:
3716:

Line 4136: Delete from ahl_item_groups_tl

4132:
4133: -- This is to delete the temporary version of Item group.
4134:
4135:
4136: Delete from ahl_item_groups_tl
4137: where item_group_id = l_itemgroup_det.item_group_id;
4138:
4139: Delete from ahl_item_groups_b
4140: where item_group_id = l_itemgroup_det.item_group_id;