DBA Data[Home] [Help]

APPS.BOMPECOD dependencies on MTL_ITEM_REVISIONS_TL

Line 66: DELETE FROM MTL_ITEM_REVISIONS_TL

62: WHERE R.ORGANIZATION_ID = P_ORGANIZATION_ID
63: AND R.CHANGE_NOTICE = P_CHANGE_NOTICE
64: AND R.REVISED_ITEM_SEQUENCE_ID = C.REVISED_ITEM_SEQUENCE_ID);
65:
66: DELETE FROM MTL_ITEM_REVISIONS_TL
67: WHERE REVISION_ID IN (SELECT REVISION_ID
68: FROM MTL_ITEM_REVISIONS_B
69: WHERE CHANGE_NOTICE = P_CHANGE_NOTICE
70: AND ORGANIZATION_ID = P_ORGANIZATION_ID