APPS.INVNIRIS dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 449: UPDATE MTL_ITEM_REVISIONS_INTERFACE

445: I.ATTRIBUTE14 = NULL,
446: I.ATTRIBUTE15 = NULL
447: WHERE I.ROWID = CUR.ROWID;
448:
449: UPDATE MTL_ITEM_REVISIONS_INTERFACE
450: SET SET_PROCESS_ID = SET_PROCESS_ID + 3000000000000
451: WHERE INVENTORY_ITEM_ID = CUR.INVENTORY_ITEM_ID
452: AND ORGANIZATION_ID = CUR.ORGANIZATION_ID;
453:

Line 583: UPDATE mtl_item_revisions_interface

579: UPDATE mtl_system_items_interface
580: SET SET_PROCESS_ID = xset_id
581: WHERE ((SET_PROCESS_ID >= 3000000000000) OR (SET_PROCESS_ID = 3000000000000-999));
582:
583: UPDATE mtl_item_revisions_interface
584: SET SET_PROCESS_ID = xset_id
585: WHERE ((SET_PROCESS_ID >= 3000000000000) OR (SET_PROCESS_ID = 3000000000000-999));
586:
587:

Line 594: UPDATE mtl_item_revisions_interface i

590: CLOSE c_get_batch_policy;
591:
592: IF NVL(l_import_co_option,'N') = 'Y' THEN
593:
594: UPDATE mtl_item_revisions_interface i
595: SET i.process_flag = 5
596: WHERE i.process_flag = 2
597: AND i.set_process_id = xset_id
598: AND ((i.organization_id = org_id) or (all_org = 1))