SELECT mp.organization_id, MSIB.inventory_item_id, TO_CHAR (msib.CREATION_DATE, 'DD-Mon-YY') Creation_date, (SELECT description FROM fnd_user WHERE user_id = msib.created_by) created_by1, mp.organization_code ORG_CODE, msib.SEGMENT1 item_code, item_type, INVENTORY_ITEM_STATUS_CODE Item_status, CAT1.CATEGORY_CONCAT_SEGS INVentory_CATEGORY, CAT2.CATEGORY_CONCAT_SEGS PLANNING_CATEGORY, CAT2.CATEGORY_ID, msib.INVENTORY_ITEM_STATUS_CODE status, I...