Report on item categories

SELECT PV.VENDOR_NAME,
MSI.INVENTORY_ITEM_ID,
MSI.SEGMENT1 ITEM,
MSI.DESCRIPTION,
(MB.SEGMENT1||'-'||MB.SEGMENT2||'-'||MB.SEGMENT3) CATEGORY,
MB.CATEGORY_ID,
MT.DESCRIPTION CATEGORYNAME,
MSI.ORGANIZATION_ID,
MCSB.CATEGORY_SET_ID,
MCST.CATEGORY_SET_NAME,
MCSB.STRUCTURE_ID,
PASL.VENDOR_BUSINESS_TYPE
FROM PO_VENDORS PV,
MTL_SYSTEM_ITEMS_B MSI,
PO_APPROVED_SUPPLIER_LIST PASL,
MTL_CATEGORY_SET_VALID_CATS MCSV,
MTL_ITEM_CATEGORIES MIC,
MTL_CATEGORIES_B MB,
MTL_CATEGORIES_TL MT,
MTL_CATEGORY_SETS_B MCSB,
MTL_CATEGORY_SETS_TL MCST
WHERE PV.VENDOR_ID=PASL.VENDOR_ID
AND PASL.ITEM_ID=MSI.INVENTORY_ITEM_ID
AND PASL.OWNING_ORGANIZATION_ID=MSI.ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID=MSI.ORGANIZATION_ID
AND MB.CATEGORY_ID=MIC.CATEGORY_ID
AND MT.CATEGORY_ID=MIC.CATEGORY_ID
AND MCSV.CATEGORY_ID=MIC.CATEGORY_ID
AND MCSV.CATEGORY_SET_ID=MIC.CATEGORY_SET_ID
AND MCSV.CATEGORY_SET_ID=MCSB.CATEGORY_SET_ID
AND MCSV.CATEGORY_SET_ID=MCST.CATEGORY_SET_ID
AND VENDOR_NAME=:VENDORNAME