APPS.INVUPD2B dependencies on MTL_ITEM_REVISIONS_INTERFACE

Line 5434: FROM mtl_item_revisions_interface rev

5430: --2808277 : Revision update support
5431: CURSOR C_rev_processed_records
5432: IS
5433: SELECT rev.*, rev.rowid
5434: FROM mtl_item_revisions_interface rev
5435: WHERE( rev.set_process_id = xset_id
5436: OR rev.set_process_id = xset_id + 1000000000000 )
5437: AND rev.transaction_type = 'UPDATE'
5438: AND rev.process_flag = 4;

Line 6699: UPDATE mtl_item_revisions_interface

6695: END LOOP;
6696:
6697: EXCEPTION
6698: WHEN resource_busy THEN
6699: UPDATE mtl_item_revisions_interface
6700: SET process_flag = 3,
6701: request_id = req_id,
6702: PROGRAM_APPLICATION_ID = prg_appid,
6703: PROGRAM_ID = prg_id,

Line 6755: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';

6751: and transaction_type in ('UPDATE','AUTO_CHILD')
6752: and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000);
6753:
6754: --2808277 : Start Revision Update support
6755: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';
6756:
6757: update MTL_ITEM_REVISIONS_INTERFACE
6758: set process_flag = 7,
6759: request_id = nvl(request_id,req_id),

Line 6757: update MTL_ITEM_REVISIONS_INTERFACE

6753:
6754: --2808277 : Start Revision Update support
6755: table_name := 'MTL_ITEM_REVISIONS_INTERFACE';
6756:
6757: update MTL_ITEM_REVISIONS_INTERFACE
6758: set process_flag = 7,
6759: request_id = nvl(request_id,req_id),
6760: program_application_id = nvl(program_application_id,prg_appid),
6761: PROGRAM_ID = nvl(PROGRAM_ID,prg_id),