[Home] [Help]
393: AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;
394: ELSE
395: OPEN x_to_sub FOR
396: SELECT secondary_inventory_name,description
397: FROM MTL_ITEM_SUB_EXP_VAL_V
398: WHERE ORGANIZATION_ID = l_org
399: AND INVENTORY_ITEM_ID = p_Inventory_Item_Id
400: AND SECONDARY_INVENTORY_NAME like p_Secondary_Inventory_Name;
401: END IF;