INV - Inventory Item Details

SELECT 
     item.item_number, 
     org.organization_code, 
     item.inventory_item_id, 
     item.full_lead_time, 
     item.planner_code, 
     DECODE(item.mrp_planning_code,  
            3, 'MRP Planned', 
            4, 'MPS Planned', 
            6, 'Not Planned', 
            7, 'MRP/MPP Planned', 
            8, 'MPS/MPP Planned', 
            9, 'MPP Planned', 
            NULL) AS mrp_planning_code, 
     item.inventory_item_status_code, 
     item.minimum_order_quantity, 
     item.maximum_order_quantity, 
     item.fixed_order_quantity, 
     item.fixed_lot_multiplier, 
     DECODE(item.inventory_planning_code, 
            6, 'Not Planned', 
            2, 'Min-Max', 
            1, 'Reorder Point', 
            7, 'Vendor Managed') AS inventory_planning_code, 
     item.min_minmax_quantity, 
     item.max_minmax_quantity, 
     item.mtl_transactions_enabled_flag, 
     item.customer_order_enabled_flag, 
     item.so_transactions_flag, 
     item.primary_uom_code, 
     item.unit_length, 
     item.unit_width, 
     item.unit_height, 
     item.unit_weight, 
     item.WEIGHT_UOM_CODE, 
     item.UNIT_VOLUME, 
     item.VOLUME_UOM_CODE, 
     item.created_by, 
     item.creation_date, 
     item.last_updated_by, 
     item.last_update_date 
 FROM 
     egp_system_items item, 
     inv_org_parameters org 
 WHERE 
     item.organization_id = org.organization_id 
     AND org.organization_code = :INV_ORG_CODE 
     AND item.item_number = :item_number; 
 /* ------------------------------------------------------ */ 
 SELECT 
     ESIB.ITEM_NUMBER, 
     ESIT.DESCRIPTION, 
     ESIB.PRIMARY_UOM_CODE, 
     IR.RESERVATION_QUANTITY 
 FROM 
     EGP_SYSTEM_ITEMS_B ESIB, 
     EGP_SYSTEM_ITEMS_TL ESIT, 
     INV_RESERVATIONS IR 
 WHERE 
     ESIB.INVENTORY_ITEM_ID = ESIT.INVENTORY_ITEM_ID 
     AND ESIB.ORGANIZATION_ID = ESIT.ORGANIZATION_ID 
     AND ESIT.LANGUAGE = USERENV('LANG') 
     AND IR.INVENTORY_ITEM_ID = ESIB.INVENTORY_ITEM_ID 
     AND IR.ORGANIZATION_ID = ESIB.ORGANIZATION_ID 
     AND ESIB.item_number = :item_number;