Interface: BOM

1. Insert data into bom_bill_of_mtls_interface

INSERT INTO bom.bom_bill_of_mtls_interface 
       (process_flag, transaction_type, created_by, last_updated_by, creation_date, last_update_date,
        assembly_type,organization_id,item_number)
VALUES (1,'CREATE',64427,64427,sysdate,sysdate,1,4602, 'C00402829-E045000H');

2. Insert data into bom.bom_inventory_comps_interface

INSERT INTO bom.bom_inventory_comps_interface(process_flag, transaction_type,
        created_by, last_updated_by, creation_date, last_update_date,operation_seq_num,effectivity_date,organization_id,
        assembly_item_number,component_item_number,component_quantity)
VALUES (1, 'CREATE',64427,64427,sysdate,sysdate,1,sysdate,4602,'C00402829-E045000H','C00402829-E045000-',1);

3. Update component