APPS.INVUPD1B dependencies on MTL_SYSTEM_ITEMS_INTERFACE_S

Line 4016: UPDATE MTL_SYSTEM_ITEMS_INTERFACE SET ROW = msii_temp_data WHERE ROWID = row_id;

4012: msii_temp_data.TRADE_ITEM_DESCRIPTOR := trim(msii_temp_data.TRADE_ITEM_DESCRIPTOR);
4013: END IF;
4014:
4015:
4016: UPDATE MTL_SYSTEM_ITEMS_INTERFACE SET ROW = msii_temp_data WHERE ROWID = row_id;
4017:
4018: -- End 5565453 : Perf issue reducing the shared memory
4019:
4020: RETURN (0);

Line 4262: transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)

4258: IF status <> 0 THEN
4259: ----Bug: 3019435 Changed the code with in IF st.
4260: UPDATE mtl_item_revisions_interface
4261: SET process_flag = l_process_flag_3,
4262: transaction_id = NVL(transaction_id,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval)
4263: WHERE item_number = cr.item_number
4264: AND inventory_item_id IS NULL
4265: AND process_flag = l_process_flag_1
4266: AND set_process_id = xset_id

Line 4270: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

4266: AND set_process_id = xset_id
4267: AND organization_id = cr.organization_id
4268: RETURNING transaction_id INTO tran_id;
4269: /*
4270: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4271: INTO tran_id
4272: FROM dual;
4273: */
4274: dumm_status := INVPUOPI.mtl_log_interface_err(

Line 4319: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval

4315:
4316: --Assign Transaction Id
4317: FOR cr IN c_fill_transaction_id LOOP
4318:
4319: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
4320: INTO tran_id FROM dual;
4321:
4322: UPDATE mtl_item_revisions_interface
4323: SET transaction_id = tran_id