APPS.INV_COPY_ITEM_CP dependencies on MTL_ITEM_REVISIONS_B_S

Line 936: the sequence 'MTL_ITEM_REVISIONS_B_S';

932: ORDER BY mir.REVISION,effectivity_date ;
933:
934: /*myerrams,
935: Following code is to update mtl_item_revisions_interface table with Revision Id, which is generated using
936: the sequence 'MTL_ITEM_REVISIONS_B_S';
937: Bug: 4892069
938: */
939: IF p_validate = 'N'
940: THEN

Line 955: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL into l_revision_id from dual;

951: FETCH c_item_rev_update_cursor into l_org_id, l_inv_item_id, l_revision;
952: EXIT WHEN c_item_rev_update_cursor%NOTFOUND;
953:
954: --Get the new Revision Id from Sequence.
955: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL into l_revision_id from dual;
956:
957: --Update Inferface table with mandatroy Revision Id Attribute.
958: UPDATE mtl_item_revisions_interface
959: SET revision_id = l_revision_id