Join between mtl_system_items_b and mtl_serial_numbers

Join between mtl_system_items_b and mtl_serial_numbers

In this post , we will be discuss about the tables join between mtl_system_items_b and mtl_serial_numbers. mtl_system_items_b tables helps to store the Inventory item information and mtl_serial_numbers helps to store the serial number information in oracle apps. These two tables helps to extract the Inventory Item information and the serial numbers attached to that Inventory item in oracle apps.Here below I will share the joins and the sql query using joins between mtl_system_items_b and mtl_serial_numbers.

 

Important Tables Join between mtl_system_items_b and mtl_serial_numbers

1.mtl_serial_numbers

2.mtl_system_items_b

 

Detail Explanation of the SQL query using the join between mtl_system_items_b and mtl_serial_numbers

select msb.segment1 Item_code,msn.serial_number,msn.* from apps.mtl_serial_numbers msn,apps.mtl_system_items_b msb
where msn.inventory_item_id=msb.inventory_item_id
and msn.current_organization_id=msb.organization_id
and msn.serial_number=:p_serial_number