APPS.BOMPECOD dependencies on MTL_ITEM_REVISIONS_B

Line 68: FROM MTL_ITEM_REVISIONS_B

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
71: AND IMPLEMENTATION_DATE IS NULL);
72:

Line 73: DELETE FROM MTL_ITEM_REVISIONS_B

69: WHERE CHANGE_NOTICE = P_CHANGE_NOTICE
70: AND ORGANIZATION_ID = P_ORGANIZATION_ID
71: AND IMPLEMENTATION_DATE IS NULL);
72:
73: DELETE FROM MTL_ITEM_REVISIONS_B
74: WHERE CHANGE_NOTICE = P_CHANGE_NOTICE
75: AND ORGANIZATION_ID = P_ORGANIZATION_ID
76: AND IMPLEMENTATION_DATE IS NULL;
77:

Line 79: UPDATE MTL_ITEM_REVISIONS_B

75: AND ORGANIZATION_ID = P_ORGANIZATION_ID
76: AND IMPLEMENTATION_DATE IS NULL;
77:
78:
79: UPDATE MTL_ITEM_REVISIONS_B
80: SET CHANGE_NOTICE = NULL,
81: REVISED_ITEM_SEQUENCE_ID = NULL
82: WHERE CHANGE_NOTICE = P_CHANGE_NOTICE
83: AND ORGANIZATION_ID = P_ORGANIZATION_ID