PROMPT PROMPT INV17-backup.sql PROMPT From Note:1472074.1 Inventory Standard Datafix Instruction #17: Fixing Duplicate Sales Order Transactions In MTI, MMTT and MMTPROMPTPROMPT Views are created to facilitate SQL for backup tables.PROMPT a. View Table MMT vs. MTIcreate or replace view mmt_mti_records_v asselect a.transaction_interface_id ,a.picking_line_id frommtl_material_transactions b, mtl_transactions_interface awhere a.picking_line_id = b.picking_line_idand a.trx_source_line_id = b.trx_source_line_idand a.inventory_item_id = b.inventory_item_idand b.transaction_type_id = a.transaction_type_idand b.transaction_source_type_id in (2,8)and b.picking_line_id is not null ;PROMPT b. View Table MMTT vs. MTIcreate or replace view mmtt_mti_records_v asselect a.transaction_interface_id ,a.picking_line_id frommtl_material_transactions_temp b, mtl_transactions_interface awhere a.picking_line_id = b.picking_line_idand a.trx_source_line_id = b.trx_source_line_idand a.inventory_item_id = b.inventory_item_idand b.transaction_type_id = a.transaction_type_idand b.transaction_source_type_id in (2,8)and b.picking_line_id is not null ;PROMPT c. View MMT vs. MMTTcreate or replace view mmt_mmtt_records_v asselect a.transaction_temp_id,a.picking_line_id frommtl_material_transactions b, mtl_material_transactions_temp awhere a.picking_line_id = b.picking_line_idand a.trx_source_line_id = b.trx_source_line_idand a.inventory_item_id = b.inventory_item_idand b.transaction_type_id = a.transaction_type_idand b.transaction_source_type_id in ( 2,8)and b.picking_line_id is not null;PROMPT Create Backup table: mti_dup_backupcreate table mti_dup_backup_13sep as (select * from mtl_transactions_interfacewhere transaction_interface_id in (select transaction_interface_id from mmt_mti_records_v));PROMPT Create Backup table: msni_dup_backupcreate table msni_dup_backup_13sep as (select * from mtl_serial_numbers_interfacewhere transaction_interface_id in (select transaction_interface_id from mmt_mti_records_v))union(select * from mtl_serial_numbers_interface msni where msni.transaction_interface_id in (select mtli.serial_transaction_temp_idfrom mtl_transaction_lots_interface mtliwhere mtli.transaction_interface_id in (select transaction_interface_id frommmt_mti_records_v )));PROMPT Create Backup table: mtli_dup_backupcreate table mtli_dup_backup_13sep as (select * from mtl_transaction_lots_interface where transaction_interface_id in (select transaction_interface_id from mmt_mti_records_v));PROMPT Create Backup table: mti_dup_backup_mmttcreate table mti_dup_backup_mmtt_13sep as (select * from mtl_transactions_interfacewhere transaction_interface_id in (select transaction_interface_id from mmtt_mti_records_v));PROMPT Create Backup table: msni_dup_backup_mmttcreate table msni_dup_backup_mmtt_13sep as (select * from mtl_serial_numbers_interfacewhere transaction_interface_id in (select transaction_interface_id from mmtt_mti_records_v))union(select * from mtl_serial_numbers_interface msni where msni.transaction_interface_id in (select mtli.serial_transaction_temp_idfrom mtl_transaction_lots_interface mtliwhere mtli.transaction_interface_id in (select transaction_interface_id frommmtt_mti_records_v )));PROMPT Create Backup table: mtli_dup_backup_mmttcreate table mtli_dup_backup_mmtt_13sep as (select * from mtl_transaction_lots_interface where transaction_interface_id in (select transaction_interface_id from mmtt_mti_records_v));PROMPT Create Backup table: mmtt_dup_backupcreate table mmtt_dup_backup_13sep as (select * from mtl_material_transactions_tempwhere transaction_temp_id in (select transaction_temp_id from mmt_mmtt_records_v));PROMPT Create Backup table: msnt_dup_backupcreate table msnt_dup_backup_13sep as(select * from mtl_serial_numbers_tempwhere transaction_temp_id in (select transaction_temp_id from mmt_mmtt_records_v))union(select * from mtl_serial_numbers_temp msnt where msnt.transaction_temp_id in (select mtlt.serial_transaction_temp_idfrom mtl_transaction_lots_temp mtltwhere mtlt.transaction_temp_id in (select transaction_temp_id frommmt_mmtt_records_v )));PROMPT Create Backup table: mtlt_dup_backupcreate table mtlt_dup_backup_13sep as (select * from mtl_transaction_lots_temp where transaction_temp_id in (select transaction_temp_id from mmt_mmtt_records_v ));PROMPT CommitCOMMIT;