INV - Inventory Item Details

SELECT 
     itm.INVENTORY_ITEM_ID, 
     itm.ORGANIZATION_ID, 
     itm.ITEM_NUMBER, 
     itm.ENABLED_FLAG, 
     DECODE(itm.location_control_code,1,'N','Y') LOC_CTL, 
     DECODE(itm.lot_control_code,1,'N','Y') LOT_CTL, 
     DECODE(itm.revision_qty_control_code,1,'N','Y') REV_CTL, 
     DECODE(itm.serial_number_control_code,2,'Predefined',5,'At Receipt',6,'SO Issue','N') SER_CTL, 
     DECODE(itm.restrict_locators_code,1,'Y','N') RESTR_LOC, 
     DECODE(itm.restrict_subinventories_code,1,'Y','N') RESTR_SUB, 
     DECODE(itm.reservable_type,1,'Y','N') RESV_FLAG, 
     itm.PURCHASING_ENABLED_FLAG, 
     itm.CUSTOMER_ORDER_ENABLED_FLAG, 
     itm.INTERNAL_ORDER_ENABLED_FLAG, 
     itm.PURCHASING_ITEM_FLAG, 
     itm.SHIPPABLE_ITEM_FLAG, 
     itm.CUSTOMER_ORDER_FLAG, 
     itm.INTERNAL_ORDER_FLAG, 
     itm.INVENTORY_ITEM_FLAG, 
     itm.INVENTORY_ASSET_FLAG, 
     itm.mtl_transactions_enabled_flag TRANS_FLAG, 
     itm.shippable_item_flag SHIP_FLAG, 
     itm.replenish_to_order_flag ATO_FLAG, 
     itm.ship_model_complete_flag SMC_FLAG 
 FROM 
     EGP_SYSTEM_ITEMS_B itm 
 WHERE 
     itm.ITEM_NUMBER LIKE 'AS54%' 
 ORDER BY 
     itm.INVENTORY_ITEM_ID, 
     itm.ORGANIZATION_ID;