DBA Data[Home] [Help]

APPS.INV_ITEM_REVISION_PUB dependencies on MTL_ITEM_REVISIONS_TL

Line 1052: INSERT INTO mtl_item_revisions_TL

1048: END IF;
1049:
1050: -- Insert into TL table
1051:
1052: INSERT INTO mtl_item_revisions_TL
1053: ( Inventory_Item_Id
1054: , Organization_Id
1055: , Revision_id
1056: , Language

Line 1782: UPDATE mtl_item_revisions_TL

1778: END IF;
1779:
1780: -- Update the description in the TL table
1781: --
1782: UPDATE mtl_item_revisions_TL
1783: SET description = DECODE( p_Item_Revision_rec.description, G_Miss_Char, description, --Bug: 3055810 replaced NULL with G_Miss_Char
1784: p_Item_Revision_rec.description)
1785: , last_updated_by = G_User_Id
1786: , last_update_date = l_sysdate

Line 2218: DELETE FROM mtl_item_revisions_TL

2214: --
2215: -- Remove the corresponding TL entries for this revision record
2216: -- from the TL table
2217: --
2218: DELETE FROM mtl_item_revisions_TL
2219: WHERE revision_id = G_revision_id;
2220:
2221: --
2222: -- Remove the corresponding entries from pending item status table