APPS.INV_ITEM_REVISION_PUB dependencies on MTL_ITEM_REVISIONS_TL

Line 997: INSERT INTO mtl_item_revisions_TL

993: END IF;
994:
995: -- Insert into TL table
996:
997: INSERT INTO mtl_item_revisions_TL
998: ( Inventory_Item_Id
999: , Organization_Id
1000: , Revision_id
1001: , Language

Line 1720: UPDATE mtl_item_revisions_TL

1716: END IF;
1717:
1718: -- Update the description in the TL table
1719: --
1720: UPDATE mtl_item_revisions_TL
1721: SET description = DECODE( p_Item_Revision_rec.description, G_Miss_Char, description, --Bug: 3055810 replaced NULL with G_Miss_Char
1722: p_Item_Revision_rec.description)
1723: , last_updated_by = G_User_Id
1724: , last_update_date = l_sysdate

Line 2156: DELETE FROM mtl_item_revisions_TL

2152: --
2153: -- Remove the corresponding TL entries for this revision record
2154: -- from the TL table
2155: --
2156: DELETE FROM mtl_item_revisions_TL
2157: WHERE revision_id = G_revision_id;
2158:
2159: --
2160: -- Remove the corresponding entries from pending item status table