SELECT 
--MIC.INVENTORY_ITEM_ID "INVENTORY_ITEM_ID",
SUBSTR( MSB.DESCRIPTION ,1,30)/* EXP_MTL_SYSTEM_B.OUTGRP1.ITEM_DESC */ "DESCRIPTION",
MSB.ORGANIZATION_ID "ORGANIZATION_ID",
MSB.ITEM_TYPE "ITEM_TYPE",
MSB.SALES_ACCOUNT "SALES_ACCOUNT",
MSB.EXPENSE_ACCOUNT "EXPENSE_ACCOUNT",
SUBSTR( MSB.ATTRIBUTE4,1,30)/* EXP_MTL_SYSTEM_B.OUTGRP1.ADDITIONAL_DESC */ "ADDITIONAL_DESC",
--SUBSTR( MST.LONG_DESCRIPTION,1,255)/* EXP_MTL_SYSTEM_ITEMS_TL.OUTGRP1.LONG_DESC */ "LONG_DESC",
SUBSTR( MSB.ATTRIBUTE1,1,1)/* EXP_MTL_SYSTEM_B.OUTGRP1.SUSPECT_ITEM_FLAG */ "SUSPECT_ITEM_FLAG",
SUBSTR( MSB.ATTRIBUTE2,1,30)/* EXP_MTL_SYSTEM_B.OUTGRP1.TRAFFIC_CODE */ "TRAFFIC_CODE",
SUBSTR( MSB.ATTRIBUTE3,1,30)/* EXP_MTL_SYSTEM_B.OUTGRP1.PICKING_ATTRIBUTE */ "PICKING_ATTRIBUTE",
SUBSTR( MSB.ATTRIBUTE5,1,30)/* EXP_MTL_SYSTEM_B.OUTGRP1.CONTINUITY_PROG_CODE */ "CONTINUITY_PROG_CODE",
SUBSTR( MSB.ATTRIBUTE6,1,30)/* EXP_MTL_SYSTEM_B.OUTGRP1.NOTE_TO_CSR */ "NOTE_TO_CSR",
SUBSTR( MSB.ATTRIBUTE7,1,1)/* EXP_MTL_SYSTEM_B.OUTGRP1.PRINT_PACK_SLIP_PACK */ "PRINT_PACK_SLIP_PACK",
SUBSTR( MSB.ATTRIBUTE8,1,1)/* EXP_MTL_SYSTEM_B.OUTGRP1.LOT_CONTROLED_FLAG */ "LOT_CONTROLED_FLAG",
SUBSTR( MSB.ATTRIBUTE9,1,30)/* EXP_MTL_SYSTEM_B.OUTGRP1.COUNTRY_OF_ORIGIN */ "COUNTRY_OF_ORIGIN",
SUBSTR( MSB.ATTRIBUTE11,1,30)/* EXP_MTL_SYSTEM_B.OUTGRP1.MDB_CALCLE_NOTE */ "MDB_CALCLE_NOTE",
MSB.PRIMARY_UOM_CODE "PRIMARY_UOM_CODE",
MSB.WEIGHT_UOM_CODE "WEIGHT_UOM_CODE",
MSB.UNIT_WEIGHT "UNIT_WEIGHT",
MSB.DIMENSION_UOM_CODE "DIMENSION_UOM_CODE",
MSB.UNIT_LENGTH "UNIT_LENGTH",
MSB.UNIT_HEIGHT "UNIT_HEIGHT",
MSB.UNIT_WIDTH "UNIT_WIDTH",
MSB.INVENTORY_ITEM_FLAG "INVENTORY_ITEM_FLAG",
MSB.PURCHASING_ITEM_FLAG "PURCHASING_ITEM_FLAG",
MSB.OUTSIDE_OPERATION_FLAG "OUTSIDE_OPERATION_FLAG",
MSB.TAXABLE_FLAG "TAXABLE_FLAG",
MSB.HAZARD_CLASS_ID "HAZARD_CLASS_ID",
MSB.PREPROCESSING_LEAD_TIME "PREPROCESSING_LEAD_TIME",
MSB.POSTPROCESSING_LEAD_TIME "POSTPROCESSING_LEAD_TIME",
MSB.BUILD_IN_WIP_FLAG "BUILD_IN_WIP_FLAG",
MSB.WIP_SUPPLY_TYPE "WIP_SUPPLY_TYPE",
MSB.WIP_SUPPLY_SUBINVENTORY "WIP_SUPPLY_SUBINVENTORY",
MSB.CUSTOMER_ORDER_FLAG "CUSTOMER_ORDER_FLAG",
MSB.CUSTOMER_ORDER_ENABLED_FLAG "CUSTOMER_ORDER_ENABLED_FLAG",
MSB.SHIPPABLE_ITEM_FLAG "SHIPPABLE_ITEM_FLAG",
MSB.PICK_COMPONENTS_FLAG "PICK_COMPONENTS_FLAG",
MSB.RETURNABLE_FLAG "RETURNABLE_FLAG",
MSB.INVOICEABLE_ITEM_FLAG "INVOICEABLE_ITEM_FLAG",
MSB.INVOICE_ENABLED_FLAG "INVOICE_ENABLED_FLAG",
(select mcb.segment1 "categroy item type" from MTL_CATEGORIES_B MCB where mcb.structure_id = 101 )

FROM
MTL_SYSTEM_ITEMS_B MSB,
MTL_CATEGORIES_B MCB,
MTL_SYSTEM_ITEMS_TL MST,
MTL_ITEM_CATEGORIES MIC

WHERE
MCB.CATEGORY_ID = MIC.CATEGORY_ID
AND
MST.INVENTORY_ITEM_ID = MSB.INVENTORY_ITEM_ID
AND
MST.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND
MSB.LAST_UPDATE_DATE > MSB.LAST_UPDATE_DATE - 1