SELECT mm.manufacturer_name,
mp.mfg_part_num,
mp.description,
msi.segment1 inv_item,
msi.description item_desc
FROM mtl_system_items msi, mtl_mfg_part_numbers mp, mtl_manufacturers mm
WHERE mm.manufacturer_id = mp.manufacturer_id
AND mp.inventory_item_id = msi.inventory_item_id
AND mp.organization_id = msi.organization_id
ORDER BY 1, 2
/
mp.mfg_part_num,
mp.description,
msi.segment1 inv_item,
msi.description item_desc
FROM mtl_system_items msi, mtl_mfg_part_numbers mp, mtl_manufacturers mm
WHERE mm.manufacturer_id = mp.manufacturer_id
AND mp.inventory_item_id = msi.inventory_item_id
AND mp.organization_id = msi.organization_id
ORDER BY 1, 2
/
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
ReplyDeleteLinkedInPCB
Thanks for sharing this information. To know more click on Exporter of Copper P-Trap in United Arab Emirates
ReplyDelete